Access 2016 Advanced

Lesson 2 – Analyzing Tables

Access 2016

E XERCISE

A NALYZING T ABLES



Task

Analyze tables.

1. Open Analyzex.accdb . 2. Open the Table Analyzer Wizard. Select Next as needed and then select the Project List table. Select Next . 3. Allow the wizard to decide how to split the table. 4. Rename Table1 to Project and Table2 to Client . 5. Drag the State field from the Project field list below the City field in the Client field list. 6. Set the Client ID field as the primary key in the Client table. 7. Have the Table Analyzer Wizard create a query. 8. Select Finish . 9. Close the Microsoft Office Access Help window. View the tables and then close them and restore the Database window. 10. Analyze the performance of the Client and Payment tables. (Notice that the analysis result does not fit the data; changing the Zip field to a long integer field would not allow for zip codes with leading zeroes, such as 08054.) 11. Close the Performance Analyzer. 12. Close the database file.

Page 24

OFFICEPRO, Inc.