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.