|
Administrator: Rave Reviews
This lesson will look at ways to filter and archive
old data. Here is a summary of the process,
Revise the table
This example will begin by making a COPY of the
Movies table for the design work. Three new fields will be added to
this table: a Yes/No field that indicates if the movie is archived,
and a Memo field and an Option list that shows the archive status:
damaged, lost, no sale.
Create a MakeTable Query
Select the archived movies and copy them to a new
table. You need to proof the new table and determine if all of the
records are there, and if there are any duplicates.
Create a Delete Query
Finally you will create another action query to
delete the archived movies from the tblMovieTitles.
|
|||
|
| |||
