One-to-Many in Reports, part 1

This course has been looking at ways to represent one-to-many relationships. In our business scenario, there are many movies in each Genre. Grouping is a very effective way to represent one-to-many relationships in a Report.  The first lesson will create a movie report that totals the movies in each Genre: how many Westerns, how many Comedies? The next lesson will apply some Report Formatting.

 

Working with Reports is like working with Forms in Design View: the Tools are very similar. Many of the steps may have a sense of déjà vu, particularly if you have been reading this all night! Very well, let's create a new Report.

 

Example of a Report in Microsoft Office Access 2010