Join Adam Wilbert for an in-depth discussion in this video Embedding queries in reports, part of Access 2013: Tips & Tricks.
…For some database applications it simply isn't practical to completely lock the…system down, as we saw in the first chapter of this course.…Sometimes you just need to give your end users access to…the Navigation pane so that they can get their jobs done efficiently.…If that's the case, then it would be in your best interest to make…sure that the Navigation pane is as…tidy as possible, without any extraneous objects.…We can start by making sure that we embed…as many objects inside of other objects as possible.…For instance, most of the time our reports are built off of a query source.…
Those queries often have no other purpose than to serve up records to the report.…So it makes sense to place the query inside of…the report object and get it out of the Navigation page.…The process is pretty simple.…In this particular database, I've added in a new report called OrdersbyState.…We can get to it through the Reports menu.…I'll click here, and then click on Orders by State.…That'll open up this Orders by State report in Print Preview mode.…
- 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.