Database Reference
In-Depth Information
8
Click each entry in turn, and read the information in the
Analysis Notes
area.
TIP
Always scrutinize the suggestions. Some will help you refine the database and
correct aberrations before problems develop; others are not valid in context. For
example, the suggestion to create a relationship for the Products table and the
suggestion to change the data type of the PostalCode field to Long Integer are not
appropriate for this database.
9
Close the
Performance Analyzer
dialog box.
Finally, let's create a report of the structure of the database.
10
On the
Database Tools
tab, in the
Analyze
group, click the
Database Documenter
button to open the
Documenter
dialog box. Notice that this dialog box is identical to
the
Performance Analyzer
dialog box, with a page for each type of object the utility
can document and a page for all the existing database objects.
11
Click the
Tables
tab, and then click
Options
, which opens the
Print Table Definition
dialog box.
12
These print options are associated with tables.
TIP
The options associated with each type of database object vary, but they all
enable you to specify what items you want to include in the documentation for
that type of object.
12
In the
Print Table Definition
dialog box, click
Cancel
.