Find Duplicates Query Wizard

7. Try it: Select a Record Source

Table or Query: tblMovies.

Click Next.

 

Try This: Select the Field with Duplicates 
Select an Available Field: Movie.

Click Next.

 

Skip This: Select Another Field

 

Now, Do This: Name the Query

Enter a name: Find duplicates for tblMoviesSQ.

 

Click Finish.

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Find Duplicates

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