Setting up Tables and Fields

In Access database tables and database fields are integral elements to pulling together relevant information. Learn how to use them here.

Setting up tables

The new database opens with one table showing as a default. It also defaults to naming this table Table1 in both the navigation pane and the Table tab itself. You will want to name your tables based on your database design plan.

Table1 Default NameDefault Table Name

Naming a table

To give the table a unique name, you must first click on the Microsoft Office button in the upper-left corner of the application.

Naming Table1Naming Table1

Next, select Save from the menu. The Save As dialog box will appear to let you save the table whatever name you want.

Save As Dialog BoxSave As Dialog Box

The new table names appear in both the navigation pane and the Table tab itself, as you can see in the picture below.

Named TableNew Table Name

TIP: Give your tables logical, easy-to-understand names.