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

Review the Data 3. Try it: Review the Data Go to All Access Objects->Tables. Open a Table:Copy of tblMovies 4-16-2014.   Try This, Too: Sort the Records Select a Field: Year. Go to Home ->Sort & Filter->Ascending.   What Do You See? There were 420 Records in Copy of tblMovies 4-16-2014. The Delete Query deleted 73 movies, leaving 347.   Well, for what it is worth, the movies were effectively deleted as promised. Close the Copy of the Movies Table.   Do This, Now: Save the Delete Query Go to File->Save. Enter a name: DeleteArchiveMoviesDQ. Close the Delete Query. Home ->Sort & Filter->Ascending