Page 7 of 10PREVNEXT

Create tables for a new Access 2007 database

Creating a lookup list

The first course in this series mentioned that you can sometimes use a lookup field instead of a table. For example, say you need to record the locations of your company's assets. If you have a large number of locations, such as offices on several floors, you'd store that data in a table because it's easier to manage that way. But if you only have a few locations, then it makes sense to store those options in a lookup field.

Lookup fields can store a list of options internally, or they can look up data from fields in other tables. These steps explain how to create a lookup field that stores options internally, in what Access calls a value list.

Callout 1 Switch your table to Datasheet view. You can do that by right-clicking the tab for the table and clicking Datasheet view.
Callout 2 Click the Datasheet tab, and in the Fields & Columns group, click Lookup Column to start the Lookup Wizard.
Callout 3 On the first page of the wizard, click I will type in the values that I want and click Next.
Callout 4 On the next page of the wizard, make sure the Number of columns box contains a 1 and then enter your options in the grid, one option per row.
Callout 5 On the third page of the wizard, enter a name for the new field and click Finish.

It's that easy to create a lookup field that uses a value list, but what if you need to change the items in the list? The practice session shows you how.

Page 7 of 10PREVNEXT