|
4. Try
This: Consider the Query Types Go to
Query Tools ->Design->Query Type. What Do
You See? We are programming a Select Query.
Select Queries grab certain Records in a
Table. There are several other Query Types we can consider. Action
Queries change the Records. There are three Action Queries:
Append, Update and Delete. An
Append Query adds more Records to a Table. An Update
Query changes the data in the Table. A Delete Query
deletes Records. So,
Here's the Plan: We will use an Update Query that changes the
RentalPriceID based on the Criteria for the Year.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Update
Queries
Query Tools ->Design->Query Type |
|
| |
