Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

Steps

Practice Data

2. Select Lookup & Relationship . The Lookup Wizard dialog box appears.

Click

3. Select the option that specifies how you want the lookup column to get its values. The option is selected.

Click

I want the lookup

column to look up the values in a table or query , if necessary

4. Select Next .

Click

The next page of the Lookup Wizard appears.

5. Select the table or query that will provide the values for the lookup column. The table or query is selected.

Click Table: Customer Type , if necessary

6. Select Next .

Click

The next page of the Lookup Wizard appears.

7. Double-click the field containing the values you want to look up to move it from the Available Fields list to the Selected Fields list. The fields appear in the Selected Fields list.

Double-click Description

8. Select Next .

Click

The next page of the Lookup Wizard appears.

9. Select Next .

Click

The next page of the Lookup Wizard appears.

10. Double-click the separator line to the right of any column header to automatically adjust the

Double-click the separator line to the right of the Description column header

corresponding column width. The column width is adjusted.

11. Select Next .

Click

The next page of the Lookup Wizard appears, with the text in the What label would you like for your lookup column? box selected.

OFFICEPRO, Inc.

Page 43