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?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!