Microsoft Office Tutorials and References
In Depth Information
Establishing Relationships Between Database Tables
Apart from linking tables in the Relationships window (a subject I explain
shortly), use these techniques on the (Relationship Tools) Design tab to
✦ Repositioning and resizing the tables: Each table appears in its own
window. Drag tables from place to place, drag a border to change a
window’s size, and scroll to see field names.
✦ Removing a table from the window: Select the table and click the Hide
✦ Removing all tables from the window: Click the Clear Layout button
and choose Yes in the confirmation box.
✦ Placing tables back on the window: Click the Show Table button, and in
the Show Table dialog box, select the tables and click the Add button.
✦ Placing all tables back in the window: To put all the tables with
relationships back in the window, click the All Relationships button.
✦ Studying a table’s relationships: Click the Clear Layout button to
remove all tables from the window; then place the table back in the
window, select it, and click the Direct Relationships button. All tables
that are related to the selected table are added to the layout.
To generate and print an Access report that shows how tables in your
database are linked, go to the (Relationship Tools) Design tab and click the
Relationship Report button. Then save the report and print it. Chapter 5 of
this mini-book explains reports.
Forging relationships between tables
On the (Relationship Tools) Design tab (refer to Figure 2-11), make sure that
both tables are on display and then follow these steps to forge a relationship
1. Click to select the field in one table; then hold down the mouse
button, drag the pointer to the field in the other table where you want
to forge the link, and release the mouse button.
You see the Edit Relationships dialog box, as shown in Figure 2-12. This
dragging between table fields is probably the most awkward thing you
undertake in Office 2013! If you do it right, a bar appears where the
pointer is while you move it over the second table, and the names of the
two fields appear in the Edit Relationships dialog box.
Notice the Relationship Type at the bottom of the dialog box. If you
accidentally create a link to the wrong field, choose the correct field from
the drop-down list in the dialog box.