# How to Create Delete Query MS Access

> To create a delete query in MS Access, open your table, go to Create, and click Query Design. Add your table, select Delete under Query Type, and choose the asterisk in the Field row. Click Run, close the Navigation Pane, confirm the action, and click Yes to permanently delete all records.

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

## Steps

1. Open MS Access and go to the table you want to delete records from.
2. Go to the 'Create' tab in the Ribbon.
3. Click on 'Query Design'.
4. Add the table from which you want to delete data by clicking 'Add Selected Tables'.
5. Select 'Delete' from the 'Query Type' group. This changes the query into a DELETE query.
6. In the 'Query Design grid', under the 'Field' row, select the asterisk icon.
7. Click 'Run', the red exclamation mark on the Ribbon.
8. Go to the 'Navigation Pane' and click 'Close'.
9. Confirm the action when prompted, as it will delete the data permanently.
10. Click 'Yes' to delete all records in the table.
11. That's it! By using any of these methods it will permanently delete the data in the table.