There is no need to recreate database tables if the data already resides in another database or format. In this video, learn how to import data into tables, create linked tables from external sources, and import tables from other databases.
- [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 is what we're going to do …
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.