From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Understanding report structure
From the course: Access 2016: Forms and Reports
Understanding report structure
- [Voiceover] The structure that Access uses to assemble the reports on the page is kind of like building a layer cake or maybe even blueprints for a skyscraper. There are multiple sections that get designed one time each and then Access uses that blueprint over and over again as it needs them for each section of the report. Let's take a look at how this works. We're back in the H+ Sport database, and I have a new query here called Orders by Month. This is a summary calculation. It's just counting up the number of orders that occurred in each SubRegion, Region, Month, and Year within the company. Now all these records represent the year 2016 but if I was just interested in finding just January, that would be these records right here. And then if I added up all of these numbers, that would tell me exactly how many orders occurred in January. If I only wanted to focus on the Midwest Region in January, that would be these two records. And then within the Midwest Region, we have two…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
Organize records with group and sort5m 8s
-
Understanding report structure7m 31s
-
Build a report with the wizard6m 49s
-
Build a report from a query3m 55s
-
Format the report in Design view5m 27s
-
Apply conditional formatting rules7m 13s
-
Create calculation fields4m 44s
-
Add a report header5m 7s
-
Segment data into groups5m 43s
-
Challenge: Create an employee report23s
-
Solution: Create an employee report3m 50s
-
-
-
-
-