graphic1

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

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.

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

 

graphic2