When you start to create a table, you must know the important properties of table field. Those properties include field size, format, input mask, default value, validation text, validation rule, require, and indexed.
The field size is used to set the size of a field. The field size property is applied to text and number data type fields. Text data type field is stored text value; the field size specifies the number of characters that can be entered in to the field. For a number data type field is stored numerical value; the value of the field size can be Byte, Integer, Long Integer, Single, Double, etc. For instance, set field size on employee name; this field can enter only 70 characters. To do so, you have to set number in front of field size as figure:
Validation Rule Property allows you to limit or control what you want users to enter on a table field. In order to avoid errors, you should use this property. It can help you to save the time for problem solving. For instance, you want to set condition on income field, only positive number is possible. In case, you enter negative number the message will display to inform you to enter the correct value. To define validation rule follow the figure below:
Through example above, you maybe wonder what data type can you use with validation rule? The answer is all data type of field. In addition, you can set other conditions besides example above such as “Male or Female”, “>100 and <1000”, “<=150” and so on.
This property is used with validation rule property. The validation text display when the user enters data that violate the validation rule. The figures below show how to set validation text and the alerted message.
This property requires data to enter in a field. It has two values for you to choose “Yes” and “No”.
Yes: Need to input data
No: Not require data entry
This property allows your data searching and shorting faster but it is slow for data updating. There are two values for you to select when you use Indexed property. First Yes (Duplicates Ok) and last one Yes (No Duplicates).
Yes (Duplicates Ok): Redundancy data was not allowed
Yes (No Duplicates): Redundancy data was allowed
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: