Add tables

Build tables and set data types

Your browser does not support video.

Try it!

Because they store your data, tables are the backbone of your database. Each table contains information about a specific subject. For example, a supplier table might store supplier names, e-mail addresses, and telephone numbers.

Note: Before you build tables, it’s helpful to understand Access database objects.

When you open a new, blank database, Access automatically creates an empty table. To customize that table, start defining your fields and add data.

Rename a table in a desktop database

Table1 is the default name of the first table in a new desktop database. It’s a good idea to name the table something more meaningful.

  1. On the Quick Access Toolbar, select Save Save

  2. In the Table name box, enter a descriptive name.

Add a table to a desktop database

Add more tables to a database, if you need them, even if you started with a template.

  1. On the Create tab, select Table.
    Access adds a new table with the name Table<#>, where <#> is the next sequential, unused number.

  2. Rename the table using the procedure in Rename a table in a desktop database, earlier in this module.

Save a table

Before you close your database, to avoid losing the work you’ve done and the data you’ve entered, be sure to save your table. When you try to close the database, if you haven’t saved your work on a table, Access prompts you to save it. Or, at any time, select Save .

Add a field by entering data

  1. In Datasheet view, enter data in the Click to Add column of the datasheet.
    Access creates a new field.

    Screen snippet of ID in Supplier table

  2. In the column heading, type a new name for the field.

    Screen snippet of Supplier table showing two rows with ID

Change the data type of a field

When you add a field by typing data into it, Access sets the field’s data type based on its contents. View the data type on the Fields tab, under Data Type.

Screen snippet showing data type field

To change the data type:

  1. Select the field.

  2. On the Fields tab, open the Data Type list and select a data type.

Add a field for a specific data type

Access validates data as it’s entered to ensure that it matches the field’s data type. If you need a specific data format in a field, specify its data type when you create it.

  1. With the table open in Datasheet view, select Click to Add and then select a data type

    screen snippet of Click to add data type drop down

  2. Type a descriptive name for the field, such as Last Name.

    Screen snippet of field to add a descriptive name for a column

Because you specified a data type, Access validates the data you enter in the new field. For example, text isn’t accepted in a Date field. Specifying the data type also helps to minimize your database size.

Want more?

Data types for Access apps

Data types for Access desktop databases

Excel training

Outlook training

Need more help?

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.

×