Access 2016 Advanced

Access 2016

Lesson 2 – Exploring Access

Steps

Practice Data

5. Select OK .

Click OK

The Performance Analyzer displays its recommendations in the Analysis Results box.

6. To view an explanation, click any result in the Analysis Results box. An explanation of the selected recommendation appears in the Analysis Notes box.

Click Table ‘Orders’:

7. Select Close .

Click

The Performance Analyzer closes.

Display Tables in the Navigation Pane, if necessary, and open the Customers table in Design view. Change the data type for the Customer Number field to Long Integer and close and save the Customers table. Open the Orders table in Design view. Change the data type for the Customer ID field to Long Integer . Then, close and save the Orders table. Practice the Concept: Open the Performance Analyzer, select all objects on the Tables page, and run the Performance Analyzer. Notice that the Performance Analyzer now has no suggestions for the selected objects. Select OK to close the Performance Analyzer message box. Close ANALYZE.ACCDB .

OFFICEPRO, Inc.

Page 23