Create a Delete Query

Prev Show Me Step-By-Step Next

Get Ready
Create a Select query that contains the tables from which you want to delete records. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.
Display this query in Design view. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.

Begin
Click the arrow next to the button and then click Delete Query on the list.
For each table containing records you want to delete, drag the * from the Field list into the grid.
If you want, enter criteria. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.
If you want, click the View button to preview the records that will be deleted. Click the View button again to return.
To run the query:
Click the button.