Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

Steps

Practice Data

6. Click Save As .

Click Save As .

The Save As screen appears.

7. Under Database File Types click Access Database (*.accdb). Access Database is selected.

Click Access Database

8. Select Save As

The Save As dialog box opens.

Click

9. In the Save As dialog box, click Save . The file is saved and an information dialog box appears saying the file is upgraded to the Access 2007 file format.

Click

P RINTING A R ELATIONSHIP D OCUMENT



Discussion

It is a good idea to document your database structure and relationships. The Documenter feature in Access allows you to view, print, and save the design characteristics of database objects. View and print such information as the properties associated with tables, queries, forms, and reports. This type of information is very useful for deciding what changes you want to make or when you have to maintain a database that was developed by someone else. Although the Relationship window is a good way to view table relationships, as well as join lines and types, you cannot print from it. The Documenter feature allows you to print the relationships between tables in your database. The relationship report that the Documenter feature produces provides information on related tables, their attributes, and the type of relationship, which in turn, provides you with all the information you need to analyze your database table relationships.

OFFICEPRO, Inc.

Page 131