Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

T YPING A L OOKUP L IST



Discussion

You can increase data accuracy by adding a lookup field to a table. The user can then select the desired value from the lookup list, rather than having to type it. The values in a lookup list are usually stored in a field in a different table. If you want the sales representative’s initials to appear in the Customer Table Sales Rep field. For example, you can create a lookup to the Initials field in the Reps table. If the desired data is not stored elsewhere, you can type the lookup list values. The Lookup Wizard creates a combo box field for the lookup list; a combo box field displays a drop-down list that displays all of the available data values. By default, a lookup field does not limit input to values on the lookup list; the user can type an entry not on the list if desired. However, you can limit a field to only those values on the lookup list. A lookup list can contain multiple columns. If you are typing a new list of values, you can designate the number of columns desired and then type the desired values into each column. In addition, you can add a second field to a lookup list. For example, if you are creating a lookup list in the Customer table, you can add both the Initials and the Last Name fields from the Reps table to the lookup list.

Using the Lookup Wizard

OFFICEPRO, Inc.

Page 27