Access 2016 Advanced

Lesson 2 – Analyzing Tables

Access 2016

NOTE After selecting the Optimize button, the Performance Analyzer marks the action as Fixed . Use the Select All button to select all the results in the Analysis Results box.



Procedures

1. On the Database Tools tab, click the Analyze Performance button . 2. Select the tab containing the objects you want to analyze. 3. Select the objects you want to optimize. . 5. To view an explanation, click any result in the Analysis Results box. 4. Select

6. Select

.



Step-by-Step

Use the Performance Analyzer to analyze the efficiency of a database.

Steps

Practice Data

1. On the Database Tools tab, click the Analyze Performance button. The Performance Analyzer opens. 2. Select the tab containing the objects you want to analyze. The corresponding object types page appears. 3. Select the object you want to optimize. The object is selected. 4. Select additional objects as desired. The objects are selected.

Click

Click the All Object Types tab

Click

Customers

Click

Orders

Page 22

OFFICEPRO, Inc.