Page 33 - Code & Click - 8

Some important and frequently used field properties:

Property Description
Field Size Lets you specify the maximum size for data stored in a field.

Lets you set whether the AutoNumber field incrementswith each new value

New Values
or uses random numbers.
Format Lets you specify the way values in a field appear when it is displayed or printed.
Decimal Places Lets you specify the number of decimal places.

Input Mask Lets you specify the way data is entered in a field.

Caption Lets you specify an alternative or more descriptive name for the field.
Default Value Lets you assign the specified value automatically to a field.

Validation Rule Lets the data entered into the field conforms to the specified rule.

Lets you specify an error message to display when the value entered in this
Validation Text
field violates the Validation Rule for the field.

Required Lets you specify whether you must enter a value into a field or not.

Allow Zero Length Lets you specify the length of text-based fields.

WORKING WITH TABLES IN THE DESIGN VIEW

To create a table in the Design view:
1. On the Create tab, click Table Design button in the Tables group.

1

A new table is inserted in the database and the table opens in Design view.
2. Enter the name for the field in the 3
Field Name column.
2
3. Select a data type for the field from
the Data Type drop-down list.

4. Type a short description about the field
in the Description column. (Optional)

5. Set the various properties for the field in
the Field Properties pane.

31