# How to Clear Table Data in MS Access

> To clear table data in MS Access, open your database, create a query in Query Design, add the table, select the Delete button, choose the asterisk icon in the grid, and run the query. Alternatively, close the design, select the query in the Navigation Pane, run it, and confirm the deletion.

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

## Steps

1. Open your Access database.
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. In the 'Design View', click on the 'Delete' button in the Ribbon.
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. Under 'Queries' select the Query you want to clear.
10. Click 'Run' to execute the query. You’ll be asked to confirm the deletion.
11. Click 'Yes' to delete all records in the table.
12. That's it! By using any of these methods it will permanently delete the data in the table.