Page 249 - IT 402 v2.0 class 10
P. 249

Field Properties

             he field properties control the behaviour of the field.

             hey are related directly with the consistency in the data that is entered by the user. Following are the field
            properties that are generally set for different fields in OpenO ce  ase.
              Entry Required:  his property is applied if the field cannot be left blank  i.e.  it ensures that the user always
              enters some data in the field.
              Auto Value: It refers to the data or value that is automatically applied in the field.  he user has to choose
                es  if this field should contain  uto Increment values. One cannot enter any data in the fields of this type.
              An intrinsic value is assigned to each new record automatically that is an increment of the value of the
              previous record.

              Length:  his option specifies the length of the data that can be stored in a field.
              For Numeric Fields:  he default length of numeric data type in a field varies with respect to its type  i.e.

              Type of Number                               Max. Length (in character) of data
               a   Number  N M  I                 :
               b   Small Integer  SM   IN         :                     5

               c   Integer  IN                    :

               d   Float  F O                     :                     5
               e    eal                           :

               f    ouble   O                     :
              For Text [Varchar] Fields:  he default length of  ext   archar  is fifty  5   characters.

              For Yes/No [BOOLEAN] Fields:  he default length of  es No   OO   N  is one     character.
              Default Value:  his property is used to enter a default value  a string  in a field.  hen the user enters the
              data in the table  the default value is used in each of the new records for the respective fields selected.
               hen the user opens a table in datasheet view  the value in the field is available in the cell.
              Format: This property is used to determine the format of the output of the data. One can set the format
              by clicking on the  ...  button that lies beside the  Format example  text box in the  Field  roperties  window.
               ext alignment can also be defined in the   lignment  tab of  Field Format  window.





























                                                                                  Database Management          247
   244   245   246   247   248   249   250   251   252   253   254