Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

812 Chapter 26 Create Databases and Simple Tables



  1. 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.


  1. 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.

  2. In the message box, click Yes to save the table.


Access saves the table and displays it in Datasheet view.


  1. 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.

Free download pdf