Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010



Procedures

1. Open the desired table in Datasheet view.

2. Go to the end of the table and click the Click to Add button.

3. Select . 4. Select the option that specifies how you want the lookup column to get its values. . 6. Select the table or query that will provide the values for the lookup column. . 8. 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. 5. Select 7. Select

9. Select . 10. Select the desired sorting options.

11. Select . 12. Double-click the separator line to the right of any column header to automatically adjust the corresponding column width.

13. Select . 14. Type the desired label for the lookup column.

15. Select

.



Step-by-Step

Insert a lookup column in a table.

Open the Customers table in Datasheet view.

Steps

Practice Data

1. Go to the end of the table and click the Click to Add button. A short menu appears with a list of Field/Column types.

Click

Page 42

OFFICEPRO, Inc.