Review the Data

Did all of the Records get copied to the new Table when we ran the Make Table Query?

 

5. Try it: Review the Data

Go to All Access Objects->Tables.

Open a Table: tblArchivedMovies.

 

What Do You See? There should be 73 Records in tblArchivedMovies.

Close tblArchivedMovies.

OK. Save and Close ArchiveMovieMT.

 

Little Summary: There are two Queries that can be modified and reused for archiving.

 

ArchiveMovieUQ: This Query uses a Criteria to Filter the Records by Year. It is an Update Query that will change the Archived Field to "Yes" for all of the selected Records.

 

ArchiveMovieMT: This Query uses the same Criteria to Filter the Records by Year. The Records that match the Criteria are copied into a Table named tblArchivedMovies.

Query Tools ->Design->Query Type-> Make Table

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create an Action Query Make Table