From the course: Access 2019: Forms and Reports
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understand report structure
From the course: Access 2019: Forms and Reports
Understand report structure
- [Instructor] 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. I'm back in the H+ Sport database and I have a new query here called orders by month that I've created. Let's go ahead and open it up to take a look. It's just a summary query, it's counting up the number of orders that occurred in each month, region, and sub region within the company. For instance, if I wanted to take a look at all the orders that happened in January, that would be these records here with the record of month number one, and if I added up all these count of order IDs we'd see how many orders occurred in January. If I was only interested in the Midwest region in January, that would be these two records right…
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
-
-
-
-
-
-
-
(Locked)
Organize records with group and sort6m 48s
-
(Locked)
Understand report structure8m 13s
-
(Locked)
Build a report with the Wizard3m 32s
-
(Locked)
Explore the report wizard output4m 8s
-
(Locked)
Build a report from a query4m 54s
-
(Locked)
Format the report in Design view5m 42s
-
(Locked)
Apply conditional formatting rules3m
-
(Locked)
Advanced conditional formatting5m 10s
-
(Locked)
Create calculation fields5m 49s
-
(Locked)
Add a report header5m 5s
-
(Locked)
Segment dates into groups4m 31s
-
(Locked)
Format date header sections3m 42s
-
(Locked)
-
-