Database building may be the most critical step in designing a new Information system. If you use Microsoft Access 2010, you may search for the tools that enable you reduce the rate of mistakes and misspells in data entry. Among of these, Access 2010 has a feature to base a new column in your table on a column in another table or query you created before in your database, so you can fill the records in the new column by choosing a value from a drop down list. This process can be explained in the following steps:
1- In design view, open the table that you want to add the new column into. Write the field name in the first empty row and choose Lookup Wizard from the data type drop-down list. Access lunches the lookup wizard.
View the Original article
Нема коментара:
Постави коментар