Access 2016 Intermediate

Lesson 2 – Modifying Tables

Access 2010

Steps

Practice Data

8. Select Create .

Click

The Edit Relationships dialog box closes, and a join line appears between the field lists.

9. Drag the desired field for the second join from the junction table field list to the corresponding field in the second related table field list. The Edit Relationships dialog box opens. 10. Select the Enforce Referential Integrity option. The Enforce Referential Integrity option is selected.

Drag Order Number in the Order Details field list to Order Number in the Orders field list

Click Enforce Referential Integrity

11. Select Create .

Click

The Edit Relationships dialog box closes, and a join line appears between the field lists.

12. Close the Relationships window.

A Microsoft Office Access warning box asks if you want to save the changes.

Click

13. Select Yes to save the changes.

Click

The Microsoft Office Access warning box and the Relationships window close, and the tables are related.

Close MODTAB1.ACCDB .

Page 48

OFFICEPRO, Inc.