Microsoft Office Beginning Access Intermediate Access Advanced Access

Objectives

Exploring Strategies

A good database starts with the task and works backwards: what do your users really have to get done in a day? In this series, you will create a database for a video store. You need to list the movies, figure out who bought what, and print a receipt.

 

Questions: Forms, Tables, and Queries are all Visualization Strategies. What does the user see? Databases also make relationships, or Dependencies. How are the forms, queries and reports linked to the tables?

 

2. Downloads

Samples

 

3. Assessment

Access: Skills Test

 

Resources

Lesson Plans

Exercises

Beginning Guide to Microsoft® Access 2007

 

Now Playing Page 7

Microsoft Access Database Tables

 

Take Two: Quiet On The Set Page 31

Microsoft Access Database Forms

 

Take Control: The Plot Thickens! Page 59

Microsoft Access Database Queries

 

Tech Talk: Intermission Page 83

Database Maintenance

 

The Administrator: Daily Reporter Page 87

Microsoft Access Database Reports

 

The SandBox: Faded Glory Page 107

Databases Come and Databases Go