Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

example, you may have a list of customers in one table and a list of customer types and information related to each customer type in another; you can use a lookup column in the customer table to look up customer type data in the customer type table; choosing the customer type from a list helps ensure the accuracy of the data.

During data entry, a lookup column displays a drop-down arrow. You can use the arrow to access the available list of values, or you can type the desired value in the column.

Using the Lookup Wizard

NOTE Insert a lookup column by right-clicking the column heading to the left of where you want to insert the lookup column and then select Lookup Column . Click the right side of a lookup column to automatically display the lookup list. Use the Lookup Wizard in Design view to create a lookup for an existing field by selecting Lookup Wizard... from the Data Type drop-down list to the right of the field where you want to create the lookup. If the field happens to be a join field, you may have to delete the join before creating the lookup.

OFFICEPRO, Inc.

Page 41