Microsoft Office Tutorials and References
In Depth Information
Analyzing and Documenting Your Database
4. In the Save As dialog box, below the Save Database As heading, select
Access Database (*.accdb).
5. Click the Save As button.
6. Browse to the folder where you want to store the new version of your
database.
7. Enter a name for the database.
Access creates a new database containing all the objects in the old
database, stored in the new format, with the extension .accdb. Additionally,
a message warns you that this new database can’t be opened in Access
2003 or earlier versions.
8. Click OK.
Analyzing and Documenting Your Database
Access includes several commands that help you analyze your database,
especially how the objects in your database connect. The following sections
detail some of these commands.
Viewing relationships in the Relationships window
Keeping the relationships among tables straight can be tricky. For help, click
the Relationships button in the Relationships group on the Database Tools
tab of the Ribbon to display the Relationships window (shown in Figure 1-3),
which shows you how your tables connect. In an order-entry database, for
example, your Customers table has a one-to-many relationship with your
Orders table because one customer may place many orders, but each order
is placed by one — and only one — customer. (See Book II, Chapter 6 for
information on using this window, including moving items around.)
Figure 1-3:
The
Relationships
window can
get
complicated if your
database
has a lot of
tables.
Search JabSto ::




Custom Search