# How to Remove Duplicates in MS access

> To remove duplicates in Microsoft Access, navigate to the Create tab, use the Query Wizard to select Find Duplicates, choose your table and fields, and click Finish. Next, create a Delete Query in SQL View to remove duplicate records while keeping one instance, save it, and run the query.

Canonical: https://livedemo.ai/tutorials/how-to-remove-duplicates-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4bfeab56e05a00ff774a/preview?step=1

## Steps

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.