Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

The Director's Cut

Box Office Receipts

 

Click Here to Get Started

Sample Files

 

Administrator Objectives:

Lesson Objectives: Learn how to modify form controls with Visual Basic Programming. This lesson will demonstrate how to design queries based on many tables, modify relationships and how to create reports that display calculated fields. In this lesson you will:

Design a query based on many tables Page 3

Practice how to add Data Fields in a query Page 5

Learn how to concatenate the Data Fields Page 6

Practice with the DateDiff Function Page 10

Learn how to use the Left() Function Page 11

Learn how to use the  IIF() Function Page 12

Practice with a Parameter Query Page 16

Practice with the Like Operator Page 18

Learn how to calculate with Queries Page 27