Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

NOTE If you are creating a lookup list for a field that is the related field in a join, you must delete the join before using the Lookup Wizard.



Procedures

1. Open the desired table in Design view. 2. Click in the Data Type column for the field you want to create a lookup list. 3. Select the Data Type arrow . 4. Select Lookup Wizard... . 5. Select the desired lookup source.

6. Select . 7. Enter the desired number of lookup columns. 8. Select the box below the Col1 heading. 9. Type the first desired lookup value. 10. Enter additional lookup values as desired.

11. Select . 12. Type the label for the look up fields or keep the default. 13. Select whether to limit entries to the choice or store multiple values.

14. Select

.



Step-by-Step

Create a lookup list.

Open the Orders table in Design view.

Steps

Practice Data

1. Click in the Data Type column of the field for which you want to create a lookup list. A drop-down arrow appears in the Data Type column.

Click in the Data Type column of the Shipping Method field

2. Select the Data Type arrow.

Click Text

A list of available data types appears.

3. Select Lookup Wizard... . The Lookup Wizard opens.

Click Lookup Wizard...

Page 28

OFFICEPRO, Inc.