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

 
 
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.

Overview
Learn how to plan a database  

Learn how to design the tables for a database that meets your organization's data needs and is easier to use and maintain. You start with a plan because you can look at your data needs and make any mistakes on paper before you start building, and that saves time and money.

This is the first course in a series that explains how to use Access by creating a database from the ground up. We'll start by learning one way to design tables, because they're the essential building blocks of any database.

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

  • Length: 30–40 minutes
 


GOALS

After completing this course you will be able to:

  • Plan the table structure of a new database.
  • Plan the fields — the individual columns in each table.
  • Plan the primary key fields that enable the relationships among your tables.
 
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

Imagine you're responsible for tracking information about your company's assets — the costs, locations, and suppliers for furniture and other equipment. You've been using Excel to manage that data, but your spreadsheet is becoming so large that it's hard to use.

Access can make that information easier to manage, but where do you start? With a plan. Even if you just want to customize an Access 2007 database template, a plan is still a good idea because it can save you time, effort, and money.

You start by planning tables because they're the backbone of any database. Once you have them, it's easier to design and build the rest of your database. And don't worry: We assume you're a beginner, and this course is meant to be a comfortable entry into the design process and into Access 2007.

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.

  Go to previous page (disabled)    Next Go to next page
advertisement