|
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 |
|
| |
