How to Create Delete Query MS Access

Quick summary

A Delete Query in MS Access lets you permanently remove records from a table using the Query Design tool. This step-by-step walkthrough covers everything from opening Query Design to confirming the deletion in MS Access.

Steps

1. Open MS Access and navigate 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 to convert 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 permanently delete the data.
10. Click Yes to delete all records in the table.
11. Your Delete Query is complete — all selected data has been permanently removed from the table.