Connection to ascertain connectivity.
Data Link message box appears, indicating a successful connection, as shown
in Illustration 4.
Illustration 4: The Data Link message box
to close the message box.
to accept the settings for, and to close, the Data Link Properties
.adp file is created, and the Database window appears as shown in Illustration
Illustration 5: The .adp
File is Created ...
created our project file and established connectivity to the pubs
database, we are now ready to begin our database diagram.
and Navigate a Database Diagram
are presently interested, for purposes of the hypothetical business need of our
practice example, in creating a diagram of an entire database, we have the
option at any time of generating such a diagram for any portion of a
database, as well.
Click the Database
Diagrams button under Objects, as depicted (circled) in Illustration
Illustration 6: Begin by
Clicking Database Diagrams ...
Database Diagram in Designer, appearing in the right pane, as shown
(circled) in Illustration 7.
Double-click Create Database Diagram in Designer ...
diagram design area opens, together with the Add Table dialog, as
depicted in Illustration 8.
Illustration 8: Diagram
Design Surface with Add Table Dialog
Click the Authors table,
and, holding the SHIFT key down, click the Titles table. This
should select all tables.
(we can also add tables individually, as the Add Tables dialog
conveniently remains in place until we dismiss it).
to close the Add Tables dialog.
tables appear on the design surface, as shown in Illustration 9.
Auto-Generated Diagram (Zoomed to 75%)
navigate around a bit and explore some of the options we have for working with
lists for each of the tables appear, with keys indicated by a small key icon. The
view of the tables we see is the Column Names view, which we can change
for any table / tables we wish to view differently, via the Table Modes
button on the toolbar, shown in Illustration 10.
Illustration 10: Table
Modes Button, in the Toolbar
Click the Table
Modes button to expand it, as depicted in Illustration 11.
Illustration 11: Table
Modes Button - Expanded, Showing Options