Create a delete query

Dan Holme

October 30, 2007

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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.

  1. From the query design view, choose Query → Delete Query.

  2. 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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like