Follow the steps below to learn how to find duplicate records in your MS Access database:
- Click the Create tab.
- Click Query Wizard.
- Click Find Duplicates Query Wizard.
- Click OK.
- Click the table in which you want to find duplicate information.
- Click Next.
- Click the field that might contain duplicate information.
- Click Add.
- Repeate steps 7 and 8 to add any other fields you wish to the query.
- Click Next.
- Click any other field to display in the query results.
- Click Add.
- Repeat steps 11 and 12 as necessary.
- Click Next.
- Key in a name for the query.
- Click Finish.
There you have it!