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.
Made with FlippingBook - Online magazine maker