Here’s how to do it:
- Go to the 'Create' tab.
- Select 'Query Wizard'.
- Choose 'Find Duplicates Query Wizard' and click 'OK'.
- Choose the table you want to check for duplicates and click 'Next'.
- Select the fields that define a duplicate and click 'Next'.
- Name the query and click 'Finish' to view the duplicate records.
- Once you have identified the duplicated records, create a query in 'SQL View'.
- Use a 'Delete Query' to remove duplicates while retaining one instance of each duplicate.
- Save the query, and click the 'Run' button to execute it to delete duplicates.