|
The first
goal is to import the new movie titles into the movie Table with an
Append Query. The archive strategy has several steps as well. Import
New Records into Access Import a
spreadsheet into Access Append the
new Records to tblMovies. Revise
the Table: tblMovieTitles Add new
Fields: Archived, Status, Memo. Add the
Fields to the Movies Form.
Create a Update Query: ArchiveMovieUQ
Add tblMovies as the Record Source.
UPDATE the Archive Field to Yes.
Run a
Make Table Query: ArchiveMovieMT Save the
UPDATE Query as a MAKE TABLE. Create a
new Table: tblArchiveMovies. Use
Action Queries to Test the Data Create an
UNMATCHED Query. Create a
FIND DUPLICATES Query. Create a
DELETE Query. That's a
good plan.
|
|
| |
