Access 2016 Advanced

Access 2016

Lesson 2 – Exploring Access

Close all open objects.

U SING THE P ERFORMANCE A NALYZER



Discussion

The Performance Analyzer analyzes the efficiency of your database to optimize its performance.

The Performance Analyzer window contains a page for each available object type in Access, as well as a Current Database page and an All Object Types page. The Current Database page allows you to analyze features that are not objects, such as relationships. You can analyze a single object or multiple objects on different pages. If you are analyzing different types of objects, the All Object Types page allows you to view all database objects in one location. The results of the performance analysis appear in the Analysis Results box. The results are categorized as a Recommendation , a Suggestion , or an Idea . The Analysis Notes box provides additional information about the selected result. Use the Optimize button to have Access perform the action suggested in a Recommendation or Suggestion ; you must manually perform the action for an Idea .

Performance Analyzer

OFFICEPRO, Inc.

Page 21