|
Action Queries
can change the data in the Tables. For example, we created an Update
Query to find any movie released before the year 2000 and set the
rental price (RentalPriceID). The other Action Queries include Append (add more
Records), Delete (subtract Records), and Make Table (Copy the Records
from a Query into a new Table.)
This lesson
will use Action Queries to import new movies into the movie Table
and check for duplicates. Our Mighty
Access database needs a strategy for archiving the Records. There are
several Action Queries that can simplify that task. Let's look at a
plan. |
|
| |
