Access 2016 Intermediate

Lesson 6 - Using Advanced Query Wizards

Access 2016

however, having an order without the corresponding customer data will cause problems. Use the Find Unmatched Query Wizard to correct the problem by updating the Customers table.

NOTE Unmatched records cannot occur if referential integrity is enforced in the table relationship.



Procedures

1. Display All Access Objects in the Navigation Pane.

2. On the Create tab in the Queries group, select the Query Wizard button . 3. Select Find Unmatched Query Wizard . . 5. Select the desired table or query from the Which table or query contains records you want in the query results? list. . 7. Select the related table or query from the Which table or query contains the related records? list. 4. Select 6. Select

8. Select . 9. Select the desired field in the Fields in list on the left. 10. Select the matching field in the Fields in list on the right.

11. Click the Match button

.

12. Select . 13. Add the desired fields to the Selected fields list.

14. Select . 15. Type the desired query name.

Page 112

OFFICEPRO, Inc.