How to Delete Records in MS Access Using SQL Query

‍

‍

To delete records in Microsoft Access using an SQL query, you can use the DELETE statement. Here’s how to do it:

‍

1. Open your desired database.
2. Go to the 'Create' tab.
3. Click on 'Query Design'.
4. Switch to 'SQL View' by clicking 'SQL View' on the Navigation Pane.
5. Enter your 'DELETE SQL' query and the name of the table from which you want to delete records.
6. Click 'Run' to execute the query.