Finding duplicate records


show more Finding duplicate records provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Finding duplicate records

Your database is only as good as the data that's entered into it, and unfortunately we are all human, and we do make mistakes. If you've designed your table structure well, you can eliminate a lot of incorrect data, but not everything. It's almost inevitable that you'll eventually find some records entered more than once, with just a few discrepancies between the fields. Access has a find duplicates query that will allow you to compare records and identify potential repeats. Let's say it's the end of the year and it's time to clean up my data. I can run this query in my Customers table to make sure that no one created two accounts for the same entity.

I'll go to the Create ribbon and then click on the Query Wizard. Click on the Find Duplicates Query Wizard and click OK. We are going to base our query on the Customers table, so click Next. Now we have to select the fields. This is the tricky part. If you pick one that's likely to have variations like the ...

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

Viewers:

Finding duplicate records provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

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