How to Create Delete Query MS Access

‍

In Microsoft Access, a DELETE query is used to remove records from a table that meet specific criteria. Here’s how you can create and run a DELETE query:

‍

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.