Access 2016 Intermediate

Lesson 6 - Using Advanced Query Wizards

Access 2016

5. Select the desired table or query from the Which table or query do you want to search for duplicate field values? list.

6. Select . 7. Add the desired fields to the Duplicate-value fields list. . 9. Add the desired fields to the Additional query fields list. 8. Select

10. Select . 11. Type the desired query name.

12. Select

.



Step-by-Step

Use the Find Duplicates 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 Duplicates Query Wizard . The Find Duplicates Query Wizard is selected.

Click Find Duplicates Query Wizard

3. Select OK .

Click

The New Query dialog box closes, and the Find Duplicates Query Wizard opens. 4. Select the desired table or query from the Which table or query do you want to search for duplicate field values? list. The table or query is selected.

Click Table: Customers

Page 110

OFFICEPRO, Inc.