From the course: Building Solutions Using Excel and Access 2019 Together
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build parameter queries
From the course: Building Solutions Using Excel and Access 2019 Together
Build parameter queries
- [Instructor] Solutions are typically built and centered around reporting, so that means we have lots of reports and probably lots of queries. Let's get started with some of the different aspects of your access in Excel Solution with queries. We want to expand the capability of our reporting and we want to use parameter queries to do that. So, let's go create a query. So, I'll go to Create and I'll choose Query Design. I want to bring in my Customer and my Orders list. I'll go ahead and choose Close on my Show Table. So, what relates my customer to my orders is the Customer ID, so I'll drag Customer ID to Customer ID. Again, you can check out Learning Data Analytics course on LinkedIn Learning so that you can discover more about joins and how they impact your data. I'm going to bring in the Customer ID and the Customer Name, the Order ID. I actually want the Order Date and the Order Amount, so I'm going to go ahead and double-click Order Date and then Order Amount so that it lays…
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.