graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.3 Utilize Calculated Fields and Grouping Within a Query (Find Duplicates)

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