One-to-Many Designs

The Intermediate Guide to Microsoft Access 2010 began with a simple Access database: two Tables, two Forms and Two Reports. In just ten lessons we have programmed:

 

A Combo Box to filter the Movies

(One Rating from Many in tblRating)

 

A Movie Search Form that uses two synchronized Combo Boxes to look up Movies. This Form has a Subform to represent the one-to-many relationship. (One Rating many Movies)

 

A Switchboard that uses Command Buttons to open Forms and Reports

 

Finally, many of the same options were designed into several Reports.

 

You done good. You get the cookie!

Please join me for the Advanced Guide to Microsoft Access 2010 where we get down to business: working with money.