Goals and Objectives

The Beginning Guide to Microsoft Access 2010 introduced the database objects: Tables, Queries, Forms and Reports. These lessons showed a one-to-one relationship. The Movies Form has one Record Source: the Movie Table, tblMovies.

 

The Intermediate Guide to Microsoft Access 2010 demonstrates several methods of representing one-to-many relationships. For example, there are many movies with the same rating, say "PG,"

 

What Is The Best Approach? These lessons will create several Forms and Reports that look up important information. These lessons will also focus on the User Interface. Simple programming can make a Form much easier to use.

Example of a Form with a Combo Button