From the course: Access 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Linking to data in an Outlook database
From the course: Access 2016 Essential Training
Linking to data in an Outlook database
- You may not have realized it but the Microsoft Office Suite contains another great database program. Outlook maintains tables in its own databases of all your emails, contacts, tasks, and calendar events. We can dig into that database from Access in order to easily bring in information from Outlook. In order to get to your Outlook database, you're going to go up here to the External Data tab and in the Import and Link section, you're going to click the More button here and then at the very bottom you'll find a link to the Outlook folder. When I click that, the Get External Data Outlook Folder Wizard starts up. It asks us how we want to bring the data in here to Access. We can either import the source data into brand new tables in the current database, we can append a copy of some records into an existing table, if we have one, or we can create a link to the data source by creating a linked table if we make changes to our Outlook folder. For instance, we add a new contact or add a…
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.