Database Reference
In-Depth Information
Now let's create another table and add a couple of Quick Start fields to it.
18
On the
Create
tab, in the
Tables
group, click the
Table
button to create a new table
containing an
ID
field and a
Click to Add
field placeholder.
19
With the
Click to Add
field active, on the
Fields
tool tab, in the
Add & Delete
group,
click the
More Fields
button to display a menu containing the
Fields
gallery. Then
scroll to the bottom of the gallery.
The Quick Start fields are at the bottom of the Fields gallery.
20
In the
Quick Start
area of the gallery, click
Name
to insert ready-made
LastName
and
FirstName
fields.
21
Click the field below
Click to Add
, and then repeat step 19, this time clicking
Address
in the
Quick Start
list to add ready-made
Address
,
City
,
State Province
,
ZIP Postal
,
and
Country Region
fields.
TIP
Notice that the Address Quick Start option includes a Country Region field. In
our practice databases, we use the field name Country. However, you might want to
use the more explicit Country Region field name if the tables you create will store in-
ternational addresses.
22
Close the table, saving it with the name
Shippers
when prompted.
CLEAN UP
Keep the MyTables database open for use in later exercises.