Access 2016 Intermediate

Access 2010

Lesson 2 – Modifying Tables

14. Select

to save the changes.



Step-by-Step

Create a many-to-many relationship.

If necessary, display the Database Tools tab.

Steps

Practice Data

1. Click the Relationships button on the Database Tools tab. The Relationships window opens, and the Design contextual tab appears. 2. Click the Show Table button on the Design tab, if necessary. The Show Table dialog box opens.

Click

Click

,if necessary

3. Select the tables you want to join. The table names are selected.

Hold [Ctrl] and click the Items , Order Details , and Orders tables.

4. Select Add .

Click

The tables appear in the Relationships window.

5. Select Close in the Show Table dialog box. The Show Table dialog box closes. 6. Drag the desired field for the first join from the junction table field list to the corresponding field in the related table field list. The Edit Relationships dialog box opens. 7. Select the Enforce Referential Integrity option. The Enforce Referential Integrity option is selected.

Click

Drag Product ID in the Order Details field list to Product ID in the Items field list

Click Enforce Referential Integrity

OFFICEPRO, Inc.

Page 47