Finding duplicate records


show more Finding duplicate records provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Finding duplicate records

In the Query Wizard we've seen that there are options beyond the simple Select query. One of those is the Find Duplicates query. The Find Duplicates query is a specific query type that will locate duplicate records within your database. This can be used for cleaning up your data tables or reviewing records with multiple entries. We can create one by going to the Create tab and using the Query Wizard. I'll select the Find Duplicates Query Wizard and say OK. The first screen ask us which table or query do you want to search for duplicate fields.

We're going to look at our Orders table. The second screen asks which field might contain duplicate information. Let's identify all of our orders where we had the same customer placed two orders on the same day. We'll choose OrderDate and CustomerID. Let's go ahead and say Next. This window asks, do you want the query to show fields in addition to those with duplicate values? Let's add OrderID so we have a reference point in...

Finding duplicate records
Video duration: 2m 17s 3h 2m Intermediate

Viewers:

Finding duplicate records provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...