|
5. Try
This: Create an Update Query Go to
Query Tools ->Design->Query Type. Select a
Type: Update. What Do
You See? You should see a new Row in the
QBE grid at the bottom of the Query. Update
to What? The data has to MATCH the Field it is changing.
RentalPriceID is a Number that refers to a specific price and
description. Try
This, Too: Edit the Update Value Enter the
RentalPriceID: 1
RentalPriceID 1 is $4.50 with a 1-Day Rental.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Update
Queries
Query Tools ->Design->Query Type->Update |
|
| |
