Microsoft Access 2010 Bible

Part I: Access Building Blocks

42

FIGURE 2.12

The Create tab contains tools necessary for adding new objects to your Access database.

There are two main ways to add new tables to an Access database, both of which are invoked from

the Tables group on the Create tab:

l (^) Clicking on the Table button: Adds a complete new table to the database
l Clicking on the Table Design button: Adds a table in Design view to the database.
For this example, I’ll be using the Table Design button, but first, let’s take a look at the Table button.
Clicking the Table button adds a new table to the Access environment. The new table appears in
Datasheet view in the area to the right of the Navigation Pane. The new table is shown in Figure
2.13. Notice that the new table appears in Datasheet view, with an ID column already inserted, and
a Click to Add column to the right of the ID field.
FIGURE 2.13
The new table in Datasheet view
ID field New field