Understanding report structure


show more Understanding report structure provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth show less
please wait ...

Understanding report structure

The structure that Access uses to assemble the reports on the page is kind of like building a layer cake or maybe even designing blueprints for a skyscraper. There are multiple sections that can design one time each, but 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. Now, we're back in the Two Trees database here and I've got a query set up here called OrdersByRegion. Let me double-click on that so we can see the data. The OrdersByRegion query is giving me a total count of all the orders that appeared in each region for each year. So, I can scroll through the list, I've got 2005 and 2006 and 07 and so on.

For each Region and Division I've got a count of the number of products that came from there. Okay, let's build a report off of this data. I'll close the query. In my Create tab I'll click on Report, and Access generates a basic report. Let's switch into Print Previe...

Understanding report structure
Video duration: 6m 12s 3h 7m Intermediate

Viewers:

Understanding report structure provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth

Subject:
Business
Software:
Access
Author:
please wait ...