From the course: Access 2019: Building Dashboards for Excel
Join today to access over 24,400 courses taught by industry experts.
Link data to Access
From the course: Access 2019: Building Dashboards for Excel
Link data to Access
- [Instructor] In a perfect world, all the data we ever needed would already be located in one place and availible for us to start reporting, but in reality datasets exist everywhere and oftentimes we spend time consolidating them together so that we can report from them. Let's look at a couple of ways to bring data into Access through linking and importing. Okay, so we have two files that we need to incorporate into our database. One is the list of the managers and departments. You might remember it when you see it, wee worked with it earlier with a VLOOKUP. We also have some videos that are required for the managers to watch and those are actually maintained in a different database. So, we're going to do two scenarios, an import and a link. Okay, so we're going to start by going to the External Data tab, we'll go to the New Data Source, we'll choose From File, and in this example we're using Excel, so we'll choose Excel and…
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.
