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.

Goals

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

Applies To: Access 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

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

Thank you for your feedback!

Support resources

Change language