Page 46 - Computer - 8

Property Data Type Description

Short text, Long text,
Number, Date/Time, Lets you ensure that the data entered into the field conforms
Validation Rule
Currency, Yes/No, to the specified rule.
Hyperlink

Short text, Lets you specify the error message to display when the value
Long text, Number, entered in this field violates the Validation Rule for the field.
Validation Text
Date/Time, Currency * The Validation Text property is applicable only if the
Yes/No, Hyperlink Validation Rule property is set for the field.

Lets you specify whether you must enter a value into a field or
All data types except
Required not. It should be set to Yes, if you want a value to be entered
AutoNumber
in the field, and set to No, if the field can be left blank.

Lets you specify the length of text-based fields.
Short text,
Allow Zero * If the Required property for a field is set to Yes, this property
Length Long text, must be set to No. If both the properties are set to No, the
Hyperlink
field can be left empty in a record.

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.

3

2. Enter the name for the field in the 2
Field Name column.

3. Select a data type for the field from
the Data Type drop-down list.

44