812 Chapter 26 Create Databases and Simple Tables
- Click the State field. Then in the Field Properties area, click the Caption box, and
type State or Region.
The Field Name remains State, but in Datasheet view, the column heading will be
State or Region.
You have changed the Field Size and Caption properties of the State field.
- On the Design tab, in the Views group, click the View button to switch to
Datasheet view.
Access tells you that you must save the table before leaving Design view. - In the message box, click Yes to save the table.
Access saves the table and displays it in Datasheet view.
- With the table displayed in Datasheet view, click the LastName field name. Then
on the Fields contextual tab, in the Add & Delete group, click the Text button.
A new field called Field1 that has the Text data type is inserted to the right of the
LastName field.
Tip You can also create a new field with a specific data type by clicking the Click To Add
label to the right of the last field in the field name row. Then in the list that appears, you
can click the data type you want.