Access 2016 Advanced
Lesson 2 – Analyzing Tables
Access 2016
Steps
Practice Data
11. Double-click the title bar of the second table. A Table Analyzer Wizard dialog box opens with the text in the Table Name box selected.
Double-click the Table2 title bar
12. Type the desired table name.
Type Items
The name appears in the Table Name box.
13. Select OK .
Click
The Table Analyzer Wizard dialog box closes, and the new name appears in the table title bar.
14. Select Next > .
Click
The next page of the Table Analyzer Wizard appears.
15. Select the field you want to set as a primary key. The field is selected. 16. Click the Set Unique Identifier button at the top of the Table Analyzer Wizard window. A key symbol appears to the left of the selected field.
Click Product ID in the Items table, if necessary
Click
17. Select Next > .
Click
The next page of the Table Analyzer Wizard appears.
18. Select whether or not you want the Table Analyzer Wizard to create a query for you. The option is selected.
Click
Yes, create the
query.
19. Select Finish .
Click
The Table Analyzer Wizard closes, the new tables and query are created, the old table is renamed, and a Microsoft Office Access Help window opens. 20. Close the Microsoft Office Access Help window, if necessary. The Microsoft Office Access Help window closes.
Click on the Microsoft Office Access Help window title bar
Page 20
OFFICEPRO, Inc.
Made with FlippingBook - Online magazine maker