Access 2016 Advanced

Lesson 2 – Analyzing Tables

Access 2016



Procedures

1. On the Database Tools tab, click the Analyze Table button

.

2. Select

.

3. Select . 4. Select the table you want to analyze.

5. Select . 6. Select whether you want to allow the Table Analyzer Wizard to decide which fields are put in each table.

7. Select . 8. Double-click the title bar of the first table. 9. Type the desired table name. . 11. Double-click the title bar of the second table. 12. Type the desired table name. 10. Select

13. Select

.

14. Select . 15. Select the field you want to set as a primary key.

16. Click the Set Unique Identifier button

at the top of the Table Analyzer

Wizard window.

17. Select . 18. Select whether you want the Table Analyzer Wizard to create a query for you.

19. Select . 20. Close the Microsoft Access Help window, if necessary.



Step-by-Step

From the Student Data directory, open ANALYZE.ACCDB . Use the Table Analyzer Wizard.

Page 18

OFFICEPRO, Inc.