Microsoft Office Tutorials and References
In Depth Information
Analyzing and Documenting Your Database
to the specific objects you want to include in the analysis. To select all
the objects of an object type, click the tab for the type and then click the
Select All button. On the Current Database tab, click the Relationships
check box to ask Access to look at the relationships among your tables.
If you want Access to analyze all the object types, click the All Object
Types tab and then click the Select All button.
5. Click OK to begin the analysis.
Analysis may take a few minutes. When the analysis is complete, a new
Performance Analyzer dialog box appears, as shown in Figure 1-6. Each
result in the list is classified as a recommendation (a change that Access
recommends and can make for you), a suggestion (a change that Access
can make for you that may have some drawbacks), or an idea (a change
that Access can’t make but you can make yourself). When you click a
result, more information about the result appears at the bottom of the
Performance Analyzer dialog box.
6. For each recommendation or suggestion that you want Access to fix,
select the result and then click the Optimize button.
Access tries to make the recommended or suggested change and
displays a message about its success.
7. Make a note of the ideas that you may want to try.
Write down any of the ideas that you want to look into, because you
can’t print the ideas, and you can’t give any commands until you close
the Access windows.
8. Click the Close button to close the Performance Analyzer dialog box.
The Performance Analyzer does a good job of spotting fields that should be
indexed to speed searches and sorts.