| Caption |
| This property is used to indicate how we choose to visualize the title of the field.
E.g, if a fields name is Fname and we indicate First Name as the value in the Caption property, we will see First Name in the header of the Fname field and in the labels in forms or reports.. |
| Default value |
| The default value is the value automatically stored in the field if no value is introduced. It is usually used when we know that a determined field is going to have the same value the majority of the time, it is used to indicate or specify what the value will be so that it can be automatically introduced at the time of data being introduced into the table.
Note: This property can be used with all types of data except OLE object and Autonumber.
|
| Validation rule |
| This property permits us to control the entry of data according to a specified criteria.The criteria must to be typed to ensure that any value introduced into the field is good.
E.g, if we decide that the values introduced should be between 100 and 2000, we type >=100 AND <=2000 in Validation Rule property, so when data is entered and not matches the condition, an error message will be displayed.
Note: This property can be use with all types of data except OLE object and Autonumerical.
To build the condition you can use the Expression Builder as we will explain to you in this video tutorial |
| Validation Text |
| In this property we will write the text which we wish to appear in the case of us trying to introduce a value into a field that does not comply with the validation rule specified before.
The message needs to be so that the person making the mistake will realize his error and be able to correct it.
This property can be used with all types of data except OLE object and Autonumerical. |
| Required |
| Set this property to Yes value, so the user must enter a correct value into the field. When this property is set to No, the field can remain empty.
This property can be used with all types of data except Autonumber. |
| indexed |
| This property is used to set a single-field index. An index speeds up queries on the indexed field as well as sorting or grouping sorting.
E.g, if you are looking for employees using the Surname field, you can create an index on the field to make the search faster.
This property has three available values:
No: without index it is the default value for this property.
Yes (uplicates OK): When an index is assigned to a field and furthermore allows duplicate values (two rows with the same value in the field).
Yes (No duplicates): When an index is assigned but no duplicate values are allowed. |
| |
|
