Append Data to a Table:

Find Duplicates Query

"There's a Query for that!" Access has a Find Duplicates Query Wizard that will walk you through the steps.

 

6. Try it: Find Duplicates Wizard

Go to Create->Queries->Query Design.

Click on Find Duplicates Wizard

 

Click OK. The Query Wizard should begin.

Create->Queries->Query Design-> Find Duplicates Query Wizard

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Find Duplicates