From the course: Access 2016: Advanced Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Embed queries in reports
From the course: Access 2016: Advanced Tips and Tricks
Embed queries in reports
- [Voiceover] 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 Panes, 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 Pane. For instance, in this database I have a report called Customer Lifetime Sales. If I double click on it, I can run it to see the data. If I switch into Design view, and open up a Property Sheet, on the Data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.