Microsoft Office Beginning Access Intermediate Access Advanced Access

Objectives

Exploring Strategies

The purpose of a database is to simplify data entry: type it once, have it update in all of the places where it is used. When you define the Dependency, the computer will fill in the data for you. What are the benefits? Speed and accuracy.

 

Questions: A subform can inherit values from the parent form. A command button that opens another form also uses a dependency. How does this programming help your users?

Intermediate Guide to Microsoft® Access 2007

 

Editing the Screen Play Page 7

Better Form Design

 

Meet the Stars Page 35

Form Controls and Switchboards

 

Take Control: Designing for Users Page 55

Modifying Form Properties

 

Tech Talk: Dress Rehearsal Page 63

Software Testing

 

The Administrator: Box Office Receipts  Page 71

Sophisticated Queries

 

The SandBox: From the Director  Page 97

The Quest

 

2. Downloads

Samples

 

3. Assessment

Skills Test Instructions

 

Resources

Lesson Plans

Exercises