Related topics
Add tables
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Add tables

Build tables with Table Designer

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

When you create a table with Table Design, you can be more deliberate about designing your database, set field types, create a lookup list, and create a foreign key to pair with your primary key.

Create a table with Table Design

  1. Select Create > Table Design.

    Access ribbon command for Create > Table Design
  2. In the new table, for the first field, enter a field name and a data type.

    First field name and data type of a new Access table
  3. To set the primary key for the table, select the Field Name cell for the appropriate field and then select Primary Key.

    Selecting a primary key field in a new Access table

    The Primary Key indicator appears to the left of the field name. You can change the primary key at any time, but each table can have only one primary key.

  4. Select File > Save, and name the table.

There are many more options when you build and modify tables with Table Design.

Switch the Table Designer between Datasheet View and Design View
  • Switch between Design View and Datasheet View for any saved table.

  • Designate any field as the table‚Äôs primary key.

  • Use Builder to create an expression or input mask.

  • Test validation rules.

  • Insert and delete rows.

  • Create lookup lists.

  • Create, rename, and delete data macros.

  • Define relationships and object dependencies.

Want more?

Excel training

Outlook training

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!