From the course: Access Basics for Excel Users
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Source your data - Microsoft Access Tutorial
From the course: Access Basics for Excel Users
Source your data
- [Instructor] To start with, make sure you have the database file 0102 My First DB open. Now look, before we start exploring Access's database features in too much detail, it kind of goes without saying that we need data. We could always do this manually by heading over to the Create menu, and selecting Table. This creates a table for us that we could always start typing in columns and data if we really wanted to, but it's much easier to import data from somewhere else that's already been created. So let's go ahead and do it. At the menu, select External Data, New Data Source, From File, and then select Excel. And now let's find the Excel exercise file that has been included with this video, double-click on it, and then select Okay. This step here is really important. We need to make sure that the check box, next to First Row Contains Column Headings, has been selected. Now let's go ahead and click on Next, and there…
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.