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

Find Duplicates Results 8. Try it: Review the Query Results The Find duplicates for tblMoviesSQ  Query found two copies of one movie, "The Hunger Games."    What Else Did You Notice? This Query does not allow you to expand the Rows to see both movies. If you could see both you would delete one.   So, how do you handle duplicates? If the duplicate is a new Record that hasn't been used in any Receipts, you can go to tblMovies and delete it.   If the duplicate was already used in a Receipt, you need to edit the Receipt to use the correct movie before you delete the duplicate movie.   Still, this little Query searched through the Movie Field and found two that matched. How did it do that?   Let's see for ourselves. Create->Queries->Query Design-> Find Duplicates Query Wizard