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.
Modify database structure
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Modify database structure
- [Instructor] Importing data from other databases or files is an easy way to duplicate information. After watching this video, you'll know how to import objects or data, delete database objects and hide or display objects in the navigation pane. Let's jump right in. I have the 02_01 Structure: Database open. We have two tables, Benefits and EE Information. We have a form and a couple of reports. Let's go ahead and import information from a text file. When we do that, it will create a brand new table in our database. External Data, New Data Source and these are the different types of files that we can bring in. Excel, HTML, XML and Text Files and the text files are comma-separated files, CSV or tab delimited. You'll see that we can also bring information in from another database. Okay, let's go back to From File, Text File. We're going to browse back to our Chapter 2 folder on the Desktop. Let's bring in our…
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.