Create tables for a new database

Create the tables for a new database Learn how to build the tables for a new database. Tables are the essential component of any database. Without them, you don’t have a database. If you're feeling intimidated, relax. We assume you're a beginner, and we’ll show you how to create tables step by step. 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.

Start course button

About this course

This course includes:

  • One self-paced lesson.

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

  • A Quick Reference Card you can print at the end of 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 in Design view, and set the primary key and data types 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 tables

  2. Create a table in Datasheet view

  3. Go faster with Quick Start fields

  4. Create a table in Design view

  5. Add and save data

  6. Use the record navigation buttons

  7. Add a lookup field to a table

  8. Practice

  9. Quick reference card

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.