How to Delete Records in MS Access Using SQL Query

Quick summary

This tutorial shows how to delete records in MS Access using a DELETE SQL query inside the Query Design editor. Users open a database, switch to SQL View, write a DELETE statement targeting a specific table, and execute it with the Run command.

Steps

1. Open your desired database in Microsoft Access.
2. Navigate to the Create tab in the top ribbon.
3. Click on Query Design to open the query editor.
4. Switch to SQL View by clicking SQL View on the Navigation Pane.
5. Enter your DELETE SQL query and specify the name of the table from which you want to delete records.
6. Click Run to execute the query and remove the targeted records.