Delete Table Dialog Box
Allows you to specify the table from which to delete rows. This dialog box appears if more than one table is displayed in the Diagram pane when you change the type of a query to a Delete query. You can change the type of a query to a Delete Query only if that query defines a single-statement stored procedure.
Select the table to delete rows from, and then choose OK.
Note A Delete query removes entire rows from the table. If you want to clear values from individual data columns, use an Update query. If you want to delete columns from a table definition, or delete the table itself, use the Database Designer.