Access 2016 Intermediate

Lesson 6 - Using Advanced Query Wizards

Access 2016

Steps

Practice Data

9. Select the matching field in the Fields in list on the right. The field is selected .

Click Customer Number , if necessary

10. Click the Match button. The fields are matched.

Click

11. Select Next .

Click

The next page of the Find Unmatched Query Wizard appears.

Add the following fields to the query: Customer ID , Order Number , and Order Date .

12. Add the desired fields to the Selected fields list. The fields appear in the Selected fields list.

13. Select Next .

Click

The next page of the Find Unmatched Query Wizard appears, with the text in the What would you like to name your query? box selected .

14. Type the desired query name.

Type Unmatched Orders

The text appears in the What would you like to name your query? box .

15. Select Finish .

Click

The Find Unmatched Query Wizard closes, the query runs, and the recordset appears in Datasheet view .

Note: If you were running this query in a working or live database, the records that appear in this query need to be corrected to ensure database integrity.

Close Datasheet view. Close QWIZARD.ACCDB .

Page 114

OFFICEPRO, Inc.