Join Adam Wilbert for an in-depth discussion in this video Understanding the reporting tool, part of Access 2013: Tips & Tricks.
…Business manager's love looking at comparative data.…Whether it's different areas over the same time period,…or a year over year comparison of the same location,…comparing data points can quickly give some powerful insight…into the health of an organization and the overall trends.…In this chapter, we're going to construct a…reporting tool that compares various data points and allows…the end user to define the parameters of…the report by hooking several of access's objects together.…We can create a dynamic tool for generating an infinite…number of reports based on the needs of an individual user.…Let's take a quick look at how the completed system will work.…
From the Main Menu, I'm going to go into the Reports screen,…and from here, I have a new button called Sales by Division.…I'll go ahead and choose that, and that'll…give me the opportunity to input some criteria.…Let's take a look at a year over year analysis of one of our divisions.…I'm going to take a look at the South Atlantic states in…2013, and compare them to the South Atlantic states in 2012.…
- 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.