Level 15: The Opening Scene

1. Lessons

Click each one of the links.

Read the lessons and try the examples.

 

Now Playing Page 11

Beginning Guide to Microsoft Access

Data Tables Page 17
The Primary Key Page 30
Modifying Field Values Page 33
Normalize a Database Page 42
 

Quiet On The Set Page 57

Beginning Guide to Microsoft Access

Create a New Form Page 59
Form Controls Page 64
The Property Sheet Page 72
Creating a Combo Box Page 78
 

The Plot Thickens! Page 85

Beginning Guide to Microsoft Access

Select Queries Page 87
Query Criteria Page 93
Concatenation Page 96
Action Queries Page 101
Update Query Page 102

Intermission Page 109

Beginning Guide to Microsoft Access

Database Maintenance Page 110

 

Daily Reporter Page 113

Beginning Guide to Microsoft Access

Use the Layout View page 118
Customize the Report page 120
Grouping and Sorting page 126
Count the Movies page 129
Conditional Formatting page 130
 

The SandBox: Faded Glory  Page 133

 

2. Downloads

1997-2003 Sample Movie spreadsheet

2007 Level 15 Database Complete

Graphics: Popcorn1, Popcorn2

 

3. Assessment

Practice Activities

Complete the Online Quiz for Level 15

 

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 on 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.