Create tables for a new Access 2007 database

Learn to build tables in Access 2007

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.

Start course button

About this course

This course includes:

  • One self-paced lesson and 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:

  • 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.

Before you begin

Topics in this course

  1. Create your tables

  2. Create a table in Datasheet view

  3. Set data types

  4. Create a table using a table template

  5. Create a table in Design view

  6. Add a lookup field to a table

  7. Practice

  8. Quick reference card

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!