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:
- Open your desired database.
- Go to the 'Create' tab.
- Click on 'Query Design'.
- Switch to 'SQL View' by clicking 'SQL View' on the Navigation Pane.
- Enter your 'DELETE SQL' query and the name of the table from which you want to delete records.
- Click 'Run' to execute the query.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it