From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Understand report structure

Understand report structure

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

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 same blueprint over and over again as it needs them for each section of the report. Let's take a look at how this works with a query that I've created called Orders per Month. This takes all of our order data and summarizes it by the month and region. So, for instance, here are all the records that correspond to January 2020. I have a single row for each region and a count of the number of orders that were placed in that region for that month. Let me switch into Design View real quick for the query, just so you can see how it was built. We're using a Year function applied to the Date, a Month function for the Date, we're grouping by the Region, Month, and Year, and then…

Contents