Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.1 Create a Query: Create Delete Queries

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 04-16-2014. 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