From the course: Access 2016: Advanced Tips and Tricks
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build the report
- [Voiceover] The final step in creating our reporting tool is to construct the actual report that will format our query results for the printed page. Once again, though, it's gonna make our job a little bit easier if we have some values populated into this main menu form. So I'm gonna go ahead and make a few selections here. Let's go ahead and compare February 2016 in the mid-Atlantic region to February 2016 in the New England region. I'll go ahead and type in all those values here, and we'll just leave them here on the main menu. Then, we'll go up to the Create tab, and we'll start creating our new report in Define View. And whenever you're creating a report, the first thing we need to do is connect it to a data source. We can do that by opening up the Property sheet, and on the Data tab we'll find the record source property here. Using the drop down list, we can choose from all the different tables or queries in our database, and I'm going to choose the Sales by Sub-Region query…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.