From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Add data from connections

Add data from connections

From the course: Access 2019: Building Dashboards for Excel

Start my 1-month free trial

Add data from connections

- [Instructor] As you build, you may need to add more data to your file. Let's take a look at how to add more data to this dashboard. Okay, so we're on the Data tab, and we're going to be in that Get & Transform Data section. And you'll notice a button for recent sources. So if I click Recent Sources, it's going to show me my recent sources, and then I can pull that. Okay, I'll go ahead and grab that. And now I can go ahead and select multiple options and bring in my Sunburst and my two TreeMap queries. And, again, I'll choose Load. And you'll note they start loading into our queries and connections. Perfect, they loaded great. Now, if I know I'm going to do that regularly and this is a database I'm going to use all the time, I can actually pin that recent source. So let me go back to Recent Sources. And, again, you notice the little pushpin here. You can push that pin, and it will stay on the list so that any time you…

Contents