Microsoft Office Tutorials and References
In Depth Information
Analyzing and Documenting Your Database
✦ Objects That I Depend On: Choosing this option lists the tables, queries,
forms, and reports that directly provide input for this object. The objects
that a report depends on include the query or table that makes up its
record source and any reports used as subreports of this report.
After the Object Dependencies pane displays information about one object,
you can’t simply switch to another object. To see the dependencies for
another object, click the object in the Navigation Pane and then click the
Refresh link in the Object Dependencies pane. When you finish looking at
object dependencies, click the X button in the top-right corner of the pane.
Analyzing database performance
The Performance Analyzer examines and improves the speed and efficiency
of your database and suggests changes, such as shrinking unnecessarily
large fields and adding indexes. Creating indexes for fields in your tables
speeds sorting and searching. (See Book II, Chapter 2 for details on creating
an index for a field in a table.)
To improve your database’s performance, follow these steps:
1. Open the database.
2. Close any open objects.
The Performance Analyzer can’t analyze an open object.
3. Click the Analyze Performance button in the Analyze group on the
Database Tools tab of the Ribbon.
You see the Performance Analyzer dialog box, shown in Figure 1-5.
in this case,
4. Select the objects you want to analyze.
Select the object types you want (on the Tables, Queries, Forms,
Reports, Macros, and Modules tabs) and then click the check boxes next