Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 Create tables for a new Access 2007 database 
 
  Overview  
 Show/Hide lesson sections Create your tables
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Bookmark and ShareShare
Overview
Learn to build tables  

Learn how to build the tables for a new database. Tables are the backbone of a database, so building them well is a critical step. This course, the second in a series, explains how to use Access 2007 by creating a database from scratch.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 30–35 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Create a table in Datasheet view.
  • Set data types for the fields in the table.
  • Create a table by using a table template.
  • Create a table in Design view, and set the primary key for the table.
  • Create a lookup field — a field that provides a list of choices.
  • Use Design view to change the values in an existing lookup field.
  
ABOUT THIS COURSE

This course includes:

  • One self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.
AUDIO TEXT

The first course in this series explained how to plan the tables, fields, and primary keys for an asset-tracking database. You're creating the database because the spreadsheet you've been using is too big to manage.

This course explains how to build the tables for your new database. Why tables? Because they're the central component of your database. Without them, you can't store data.

If you're feeling intimidated, relax. We assume you're a beginner. Just make sure you've taken the first course in this series or that you're familiar with basic database concepts such as fields and primary keys.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

  
BEFORE YOU BEGIN
  Go to previous page (disabled)    Next Go to next page
advertisement