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.