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.
Made with FlippingBook - professional solution for displaying marketing and sales documents online