Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Level 16: The Director's Cut Box Office Receipts Click Here to Get Started Samples Administrator Objectives: Overview Page 2 New Query Based on Many Tables Page 3 Table Joins in a Query Page 4 Data Fields in a Query Page 5 Concatenate the Data Fields Page 6 Create a Rental Report Page 7 Use the Date Field DateDiff() Page 10 The Left() Function Page 11 Calculate with IIF() Page 12 Design the Overdue Video Report Page 14 The Parameter Query Page 16 New Record Source for old Report Page 17 Using the Like Operator Page 18 Using the Parameter Page 19 Activity: Microsoft Access Reports Query parameters and code
Click Here to Get Started
Samples
Administrator Objectives:
Overview Page 2
New Query Based on Many Tables Page 3
Table Joins in a Query Page 4
Data Fields in a Query Page 5
Concatenate the Data Fields Page 6
Create a Rental Report Page 7
Use the Date Field DateDiff() Page 10
The Left() Function Page 11
Calculate with IIF() Page 12
Design the Overdue Video Report Page 14
The Parameter Query Page 16
New Record Source for old Report Page 17
Using the Like Operator Page 18
Using the Parameter Page 19
Activity: Microsoft Access Reports
Query parameters and code