Design tables for a new Access 2007 database

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.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


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.

Topics in this course

  1. Start with a plan

  2. Decide on a purpose

  3. List the data you want to store

  4. Group your data by subject

  5. From groups, fields

  6. Plan your primary keys

  7. A quick look at relationships

  8. Practice

  9. Quick reference card

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!