# How to Delete Duplicate Records in MS Access Using SQL Query

> To delete duplicate records in MS Access, go to the Create tab, select Query Design, and click View to choose SQL View. Next, enter your delete query, and finally click Run to see the results.

Canonical: https://livedemo.ai/tutorials/how-to-delete-duplicate-records-in-ms-access-using-sql-query/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3b63ab56e05a00fe2a6a/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Click 'view' and select 'SQL View'.
4. Enter your delete query.
5. Click 'Run' to see the results.