The second step in creating the reporting tool is to construct the Query. The query will assemble the required records and summarize the total amount spent across each state for each month. Then, using the values selected on the form, the query will filter the results to only the requested information.
- [Voiceover] The next step in creating our reporting tool…is to construct the query.…The query will be easier to test out…if we have some values populated in these combo boxes…here on the Main Menu form,…so let's go ahead and make a few selections.…I want to take some values from 2016 in January…and the East North Central division…and I want to compare those to 2016 January…in the Mid Atlantic subregion.…Let's go ahead and make those choices here…at this Main Menu and we'll just leave them in place.…Then, we'll turn our attention here to the Create tab…and we'll start our new query in Design View.…
For our query we're going to need some information…out of the Orders table.…That'll give me links to the customer that placed the order,…the product that was ordered, as well as the date…that the order was placed.…Then, I'm going to pull information…out of the Customers table…which will tell me the state that the customer lives in…and we can get the related subregion from the States table.…So I'll go ahead and add that one in.…
Author
Released
7/20/2016- Creating an AutoExec macro
- Creating a kiosk experience
- Working with hidden objects: queries, tables, and more
- Splitting a database into back and front ends
- Creating a dynamic reporting tool
- Adding shortcuts and other aids to end users
- Writing custom VBA functions
- Packaging and distributing your Access application
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2016 Essential Training
with Adam Wilbert6h 45m Beginner -
Access 2016: Queries
with Adam Wilbert4h 10m Intermediate -
Access 2016: Forms and Reports
with Adam Wilbert4h 59m Intermediate
-
Introduction
-
Welcome57s
-
-
1. Create a Startup Experience
-
Explore startup options7m 4s
-
Launch a splash screen7m 8s
-
Hide the Ribbon5m 28s
-
Create a kiosk experience6m 14s
-
-
2. Work with Hidden Objects
-
Embed queries in reports4m 40s
-
Access the system tables4m 6s
-
-
3. Split a Database
-
Create a back end4m 11s
-
-
4. Create Cascading Combo Boxes
-
Build the combo boxes7m 47s
-
Cascade the results5m 15s
-
-
5. Create a Dynamic Reporting Tool
-
Build the form8m 37s
-
Build the query8m 6s
-
Build the report7m 18s
-
Finalize the reporting tool5m 12s
-
6. Aid Your End Users
-
Add customized shortcut keys4m 50s
-
Leverage split forms6m 30s
-
-
7. Write Custom Functions in Visual Basic
-
VBA function basics6m 9s
-
-
8. Distribute Your Application
-
Package your application3m 31s
-
Conclusion
-
Next steps38s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Build the query