Level 16: The Director's Cut

1. Lessons

Click each one of the links.

Read the lessons and try the examples.

 

Editing the Screen Play Page 11

Intermediate Guide to Microsoft Access

Designing for Users Page 12
Use a Query for a Combo Page 21
Design a Subform Page 29
Multiple Item Forms Page 38
Split Forms Page 41
Bound/Unbound Controls Page 43
 

Meet the Stars Page 47

Intermediate Guide to Microsoft Access

Form Controls Page 48
Create a Switchboard Form Page 50
Add a Command Button Page 53
Embedded Macros Page 60
Introduction to VBA Code Page 62
 

Designing for Users Page 67

Intermediate Guide to Microsoft Access

Database Startup Options Page 69
Minimizing User Errors Page 72
Set the Database Properties Page 75
Save As PDF or XPS Page 77

Dress Rehearsal Page 81

Software Testing

 

Box Office Receipts  Page 89

Intermediate Guide to Microsoft Access

Query with Many Tables Page 91
Concatenate Data Fields Page 94
Use Date Field DateDiff() Page 98
The Left() Function Page 99
Calculate with IIF() Page 100
Using the Like Operator Page 106
Calculate with Queries Page 115
 

From the Director  Page 129

 

2. Downloads

FrontRowVideoIntermediateComplete.zip

Graphics: Popcorn1, Popcorn2

 

3. Assessment

Practice Activities

Complete the Online Quiz for Level 16.

 

Optional Skill Test: Download the instructions. You can use this practice to assess your progress.

Try it: Download these files.

1. Right-Click on the link.
2. Click SAVE TARGET AS,

do not click Open
3. Go to the Documents folder
4. Click on SAVE

 

Sample Access Databases
These samples are Zipped (compressed) to improve your download. However, you will need to Unzip them before you can begin programming.