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:
- Open MS Access and go to the table you want to delete records from.
- Go to the 'Create' tab in the Ribbon.
- Click on 'Query Design'.
- Add the table from which you want to delete data by clicking 'Add Selected Tables'.
- Select 'Delete' from the 'Query Type' group. This changes the query into a DELETE query.
- In the 'Query Design grid', under the 'Field' row, select the asterisk icon.
- Click 'Run', the red exclamation mark on the Ribbon.
- Go to the 'Navigation Pane' and click 'Close'.
- Confirm the action when prompted, as it will delete the data permanently.
- Click 'Yes' to delete all records in the table.
- That's it! By using any of these methods it will permanently delete the data in the table.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it