From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create tables
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create tables
- [Instructor] When creating new tables for our database, we can begin with a blank table, but if the data has already been created elsewhere, such as in an Excel file or in another database, we can simply import that information into our database to create those new tables. After watching this video, you will know how to import data into tables, append data to a table, link data from an Excel workbook and import tables from other databases. Let's jump right into our Create_Tables database. We have no tables, so we have a lot of work to do. First, we're going to import our information from the customer's Excel workbook. External Data, New Data Source shows us all of the file types that we can bring in. We know the information is the customer's Excel workbook. I'll browse back to the Chapter three folder on the desktop. Select Customers and click Open. We have two options, we can import the data into a new table, which…
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.