Before creating a delete query, create a select query with the * field (representing the entire table) in the first column, and any fields you need for deletion criteria in additional columns. Enter the criteria and run the query as a select query to ensure that Access is locating all desired records and only desired records.
- From the query design view, choose Query → Delete Query.
- Before you run the delete query, it would be wise to back up the database. Then run the query. Access will let you know how many records you are going to delete.