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 query
- [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…
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.