graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Fields: Add Fields to Tables (MultiValue Fields)

Review the MultiValue Field

The Lookup Wizard walked us through the task of creating a Lookup List. There are two additional choices in the last step of the Wizard: Limit to List and Allow Multiple Edits. By default, these options are not selected.

 

Where would you change them? Look in the Field Properties: There are two Tabs! We usually edit the General Properties. There is also a Lookup Tab. Well, let's look.

 

6. Try it: Review the Field Properties

Select a Field: Status.

Go to Field Properties-> Lookup.

 

What Do You See? The Properties are:

Display Control: Combo Box

Row Source Type: Value List.

Row Source:

Limit to List: Yes (Users can't add to the list).

Allow Multiple Values: Yes (Pick more than 1).

Allow Value List Edits: No.

Field Properties-> Lookup

graphic2