Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Find Duplicates In this archive process, you designed a MAKE TABLE query to create a new table for archived movies. You also developed a FIND UNMATCHED query to determine if all of the records were copied.   You can use another query to see if there are any duplicates.   Try it: Use a Query to Find Duplicates Go to Create->Query->Find Duplicates. Select Table: tblArchiveMovies. Select Fields to search: Movie. Additional Fields: ID, Year, Rating, Genre Query Name : ArchivedMoviesDuplicatesSQ Try it: There should be NO results.   Try it again with sample data Open tblArchivedMovies. Select, copy and paste any movie.   Run the query again. What do you see? Is the ID number of the copied movie the same as the pasted one? This image shows SAMPLE data: a movie was copied and pasted in tblArchiveMovies to test the query. Create -> Query Wizard -> Find Duplicates