Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.2 Modify a Query: Rename Queries

Copy to a New Table The Update Query, ArchiveMovieUQ, will also work as another type of Action Query: A Make Table Query. The Make Table Query selects the Records that match the Criteria and copies those Records into a new Table.   4. Try it: Create a Make Table Query The ArchiveMovieUQ Query is still open. Go to Query Tools ->Design->Query Type. Select a Query Type: Make Table.   What Do You See? You will be prompted to name the new Table. Enter the Table Name: tblArchiveMovies. Click OK to Run the Make Table Query.   Do This, Now: Save the Make Table Query Go to File->Save Object As. Enter the name: ArchiveMovieMT, where MT means this is a Make Table Query.   Keep going...   Memo to Self: By default, this new Table will be made in the Current Database. Query Tools ->Design->Query Type-> Make Table