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 Address Field you're…less likely to find identical records, and if you picked too many fields just…