Maintain data integrity - Microsoft Access 2013 - page 184

▪ For a short list of choices that won't change often, you can use a combo box. Clicking
the arrow at the right end of the combo box displays the list of choices, which you
provide as a lookup list. Depending on the properties associated with the combo box,
database users might be able to enter something else or they might be able to add
entries to the lookup list displayed in the future. Although you can create a lookup list
by hand, it is a lot easier to use the Lookup wizard.
TIP Access comes with three Quick Start lookup lists that are commonly used in businesses:
Payment Type, Priority, and Status. You can efficiently add one of these ready-made lookup
lists to a table by clicking the More Fields button in the Add & Delete group on the Fields
tool tab, and then clicking the field you want.

In this exercise, you'll use the Lookup wizard to create a list of states and provinces from
which users can choose.

SET UP You need the GardenCompany06 database you worked with in the preced-
ing exercise to complete this exercise. If necessary, open the database. Then display the
FieldTest table in Datasheet view, and follow the steps.

1

At the right end of the first record in the table, click the Click to Add field. On the
Fields tool tab, in the Add & Delete group, click the More Fields button, and then in
the Basic Types area, click Lookup & Relationship to start the Lookup wizard.

You can specify that the values in the list already exist in another table or that you will enter
them manually.