How to Use the Wizard to Create a Find Duplicates Query in Microsoft Access

Video Transcript

"Hi my name is Dave Andrews and today I'm going to show you how to use the Wizard to create a fine duplicates query in Microsoft Access. Let's open up Access by going to our Start button and select all programs. Let's go to Microsoft Office and we are just going to launch access. I have a database already created and in this database I have a single table that has two fields so I open up tables and open up table 1 and I have two fields here. The first one is an ID field and the second one is a text field. As you can see I've got the text Dave repeated four times, Bill repeated twice and William is not repeated at all. So what I'm going to do is create a query that is going to show me these rows right here because they have duplicate values in them. So close out our table and let's select the queries area here under objects and then click on new. This pulls up the types of queries you can create. The one I want is a fine duplicates query. Select it and say o'kay. We are going to operate on table 1 so just say next and that is going to ask you which field do you want to search for duplicates? These aren't the fields you want to include in the query but the ones you want to search for duplicates. You want to search the text field for duplicates. The next screen asks you are there any other fields you want to include in your query? I do I want to include the ID field. This one will not be searched for duplicates. It will just be shown in the query. Say next and select view results and you can even name your query something else. As you can see let's pull up the results of my query, Bill is listed as well as the ID's of the rows that Bill appears in and Dave is listed as well as those ID's. As you can see William is left off because it is not duplicated anywhere. My name is Dave Andrews and I've just showed you how to use the Wizard to create a fine duplicates query in Microsoft Access."