Learn to import data into a new table. Author Jen McBee reviews the options available when importing data and types of files that can be used. Importing data and appending the data to a table are skills that you may be asked to demonstrate on the Access 2
- View Offline
- Exercise Files
- [Instructor] Have you ever imported…data from an Excel workbook into an Access table?…Or have you ever imported data…from a text file into a table?…It's so easy to do, and in this video…I'm going to show you just how easy it is.…On the Access 2010 MOS exam, you may be asked to…import data from a text file as a new table, or,…you might be asked to import Excel data as a new table.…We'll go ahead and explore both processes,…so you'll be comfortable to tackle…either one on the exam.…
For this exercise, I'm just going to create a blank database.…I'll go to File,…double click on blank database,…and here it is.…Now I can go ahead and close this…blank table that Access very kindly created for me.…Because what I'm going to do is create…two new tables by importing the information in.…I'll go to my external data tab,…and on this tab I have an import group…and I have an export group.…
We're going to focus on the import group.…Let's go ahead and first import a text file.…Here is my command button.…This brings me into my great wizard.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
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.