Access 2016 Intermediate

Access 2016

Lesson 6 – Using Advanced Query Wizards



Step-by-Step

Use the Find Unmatched Query Wizard.

If necessary, display All Access Objects in the Navigation Pane.

Steps

Practice Data

1. Select the Query Wizard button in the Queries group on the Create tab. The New Query dialog box opens.

Click

2. Select Find Unmatched Query Wizard . Find Unmatched Query Wizard is selected.

Click Find Unmatched Query Wizard

3. Select OK .

Click

The New Query dialog box closes, and the Find Unmatched Query Wizard opens. 4. Select the desired table or query from the Which table or query contains records you want in the query results? list. The table or query is selected.

Click Table: Orders

5. Select Next .

Click

The next page of the Find Unmatched Query Wizard appears.

6. Select the related table or query from the Which table or query contains the related records? list. The table or query is selected.

Click Table: Customers

7. Select Next .

Click

The next page of the Find Unmatched Query Wizard appears.

8. Select the desired field in the Fields in list on the left. The field is selected .

Click Customer ID , if necessary

OFFICEPRO, Inc.

Page 113