Learn how to create a new table to capture data in your database. Author Jen McBee demonstrates the steps to take to create new tables and gives tips on things to keep in mind when designing your database. She demonstrates how to import data, focusing on
- View Offline
- Exercise Files
- [Instructor] Unless you use one of the built-in templates,…you'll need to create all the tables in your database.…You can also import your data from Excel,…a text file or from another Access database.…On the Access 2010 MOS Exam,…you may be asked to create a new table and add fields,…or you may be asked to import data from…an Excel file or a text file.…In this video we'll go through the steps…of both importing data and inserting a few fields in it.…If you're ready, let's go ahead and create some tables.…
I have Access open, but no database yet.…I'm going to go ahead and create a blank database.…I'll go to my File tab and click on Blank database.…When you create a new blank database,…Access will always include…an initial table for you…so you can start entering your information.…I'd like to go into Design View…so I can talk about one of the properties…that you're going to want to pay close attention to.…So I'll right click on the tab…and go to Design View.…It's asking me to save the table,…so I'm going to call it Customer Information…
- 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.