Setting Up a Database

Add a Field:

  1. Open the table in Design View
  2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows Button image on the toolbar.

    To add the field to the end of the table, click in the first blank row.

  3. Click in the Field Name column and type a unique name for the field.
  4. In the Data Type column, keep the default (Text); or click in the Data Type column, click the arrow, and select the data type you want.
  5. In the Description column, type a description of the information this field will contain. This description is displayed on the status bar when adding data to the field and is included in the Object Definition of the table. The description is optional.

    Delete a Field:

    1. Open the table in Design View
    2. Select the field or fields you want to delete.

      To select one field, click that field's row selector.

      To select a group of fields, drag through the row selectors of those fields.

      A table in Design view

      Callout 1 Row selectors

    3. Click Delete Row Button image on the toolbar.

BACK TO STUDENT PAGE