|
A new
Query will calculate the total for each Receipt. So, Queries get
their data from Tables. Please add them.
2.
Try it: Create a Query Go to
Create ->Queries ->Query Design. You will be
prompted by the Show Table. Select a
Table: tblMovieRented. Click
Add. Select a
Table: tblCustomers. Click
Add. Select a
Table: tblMovies. Click
Add. Select a
Table: tblRentalPrices. Click
Add. Close
the Show Table Window. Keep
going...
Create ->Queries->Query Design
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.2. Manage source tables and
relationships: Use the Show Table Options
|
|
| |
