From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

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

Change connections

Change connections

From the course: Access 2019: Building Dashboards for Excel

Start my 1-month free trial

Change connections

“

- There are several reasons why databases move. Sometimes we build in a test lab, copy, and then we move it to production. Sometimes, we change server locations. Either way, you need to know how to change connections when your database moves. Also, if you didn't start at the beginning of this course, and you jumped in the middle, you may find you need change the connections that are currently pointing to my machine to your machine. So, let's take a look at how to change connections. Okay, so we're on the data tab, and we're in that base query, and on the far right-hand side, do you see where it says query? Go ahead and choose that query tab. Then I want you to choose the edit option. This is actually opening up power query, and power query is controlling the data that we see. You notice it's not loaded on the sheet unless we want to load it onto the sheet. But it is loaded in the background. And here, this is where we…

Contents