Page 316 - TP_IT_V1.0_C10_flipbpookl
P. 316

Field Properties
              Field properties provide extra functionality to the fields created in a table. You can set the field properties using the
              given different methods:

              At the time of designing  the structure  of the table in  the design  view you  can side by side change  the field
              properties.
              OR

              Perform the following steps to modify the field property:
              Step 1:  Select the table.
              Step 2:  Right-click on table and select the Edit option from the context menu.

              The table opens in the Table Design window. You can edit the structure along with the field properties.

              The list of the field properties available for Numeric data types are:
              •  AutoValue: It auto increment numeric unique value that is automatically inserted in the field when a new record is
                added into a table. In most of the cases it’s the primary key of the table. The user cannot enter data in the field that
                is assigned as AutoValue. It has the drop-down that contains “Yes”.
              •  Length: It defines the maximum length a field can have to hold a value. This option is not allowed to modify when
                the Auto Value property is set to “Yes”. For example, the field “Section” should be only single alphabet, the Length
                of the field can be “1”.

              •  Default Value: It’s the default value that can be assigned in the field. While data entry user can make a change in it.
                For example, the field “Marks”, can be assigned a default value 30. This option will not be available, when the Auto
                Value property is “Yes”.
              •  Decimal Places: It specifies the number of decimal places in a numeric field. For example, if you fix decimal places
                as 2 for salary then you are allowed to enter salary as 3456.78.
              •  Format Example: It allows the user to change how the data in a field will be displayed in the Table Data View.
              The list of the field properties available for Character Data types are:

              •  Entry Required: The field with Entry Required as “Yes” means that the field cannot be left blank. The user needs to
                enter data in this field. It contains a drop-down “Yes”/ “No”. The default value for this property is “NO” which means
                the field if left blank will contain a NULL(nothing) value.
              •  Length: It defines the maximum length a field can have to hold a value. For example, the field “Section” should be
                only single alphabet, the Length of the field can be “1”.
              •  Default Value: It’s the default value that can be assigned in the field. This value gets automatically added in a field at
                the time of adding a record in a table. The user, if wants can make a change in it. For example, the field “Title”, can
                be assigned a default value “Ms.”.
              •  Format Example: It allows the user to change how the data in a field will be displayed in the Table Data View.





                314   Trackpad Information Technology (Ver. 1.0)-X
   311   312   313   314   315   316   317   318   319   320   321