From the course: Access 2019: Building Dashboards for Excel
Join today to access over 24,400 courses taught by industry experts.
Refresh data from other sources
From the course: Access 2019: Building Dashboards for Excel
Refresh data from other sources
- [Instructor] Now that you have live connections to your database, when your data updates, then you want your external connections to update, we do this through refresh and there are a ton of options. Let's go take a look. Okay, great. It's as simple as right-clicking your data and choosing refresh or from your queries and connections, clicking your refresh. Notice on the peak, you see the last time it was refreshed and that number might be different for everyone. You can also right-click and refresh. Alright, let's go to our query tab across the top. You have refresh options here. You can go to your table design and again, more refresh options. You can see how important it is. Also, alt and a five will allow you to refresh. But even that may not be enough for your solution. Let's go to the data tab and do you see the refresh all button here? Let's go and click the connection properties. This is just one way to get…
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.
