Join Adam Wilbert for an in-depth discussion in this video Understanding report structure, part of Access 2007: Forms and Reports.
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 get designed one time each and then Access uses…that blueprint over and over again as it needs each piece for the reports.…Let's take a look at how this works.…We're back in the Two Trees database and I've got a query here…called OrdersByRegion.…We'll go ahead and run that query.…The OrdersByRegion query is summarizing and giving us an account of how many…orders have been placed within each region and division of the company.…
Let's go ahead and close this query and we'll use that data table as a basis for our report.…With the query still selected in the Navigation Pane, I'm going to go up to the Create…Tab and click on this Report button in the Report section.…That will create a basic report based off of that data.…Let's take a look at this in Print Preview Mode, and dissect the…different elements.…We'll switch it here to View > Print Preview.…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
1. Introduction to Forms
2. Form Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. The User Experience
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.