How to Remove Duplicates in MS access

‍

‍

Here’s how to do it:

‍

1. Go to the 'Create' tab.
2. Select 'Query Wizard'.
3. Choose 'Find Duplicates Query Wizard' and click 'OK'.
4. Choose the table you want to check for duplicates and click 'Next'.
5. Select the fields that define a duplicate and click 'Next'.
6. Name the query and click 'Finish' to view the duplicate records.
7. Once you have identified the duplicated records, create a query in 'SQL View'.
8. Use a 'Delete Query' to remove duplicates while retaining one instance of each duplicate.
9. Save the query, and click the 'Run' button to execute it to delete duplicates.