The Last Action Query A Delete Query does exactly what the name spells out: it deletes data. As mentioned earlier, deleting data is not the best practice for a database administrator. However, this option may be better than marking bad records as archived.   The following example will use a copy of the Movie Table to test the Delete Query.   1. Try it: Create a New Query Go to Create ->Queries ->Query Design. You will be prompted by the Show Table. Select a Table: Copy of tblMovies 8-8-2012. Click Add and Close the Show/Table Window. Try This, Too: Add Fields Add these Fields to the QBE Grid: MovieID, Movie, Year, Rating, Genre, Stars and RentalPriceID. And Try This: Add a Criteria Select a Field: Year. Enter a Criteria: <1990   Do This, Now: Run the Select Query Did this Query select 73 Records? Create->Queries->Query Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.1. Construct queries: Create a Delete Query