Join Adam Wilbert for an in-depth discussion in this video Building the report, part of Access 2013: Tips & Tricks.
…The final step in creating a reporting tool, is to construct the…actual report that will format our query results from the printed page.…Before we get started on the report though, let's go ahead…and make sure that our query is working with valid data.…I'm going to open up the form called Sales By Division.…In here, I'm just going to pick a division Mid-Atlantic and a year of 2011.…And I'm going to compare those to the states…in the Pacific division in the same year of 2011.…Now that those values are entered, let's go ahead and run the query.…I'll double-click on the query to run it.…And I should see Mid-Atlantic in 2011, and Pacific in 2011.…
Now that I know my query is running and has…valid data entered, we can go ahead and create the report.…And I'm going to choose to create a report using the wizard.…So I'll choose Report Wizard over here.…And it's going to ask me, what is going to be my data source.…And we just built this query for the data source.…So I'll make sure that in this tables and…queries section, I've chose then query Sales By Division.…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- 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.