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

o set the   ength  property:
            Step 1:   lick on the field on which   ength  property has to be set.

            Step 2:   osition the cursor at the field   ength  property width definition box and type the length re uired in
                    numeric form, say 10.
            So while entering data in the table  if the user types  Secunderabad  as  ity  error message comes as the user
            tries to save the record which crosses the limit of 10 characters.

            Default Value

             efault value property specifies the value that will automatically be inserted in a field whenever a new record
            is entered into the table. If the user leaves the field blank  the default value is saved in the record but if the
            user modifies the value  the modified value is saved. For example  if the  ity name of most of the employees
            of an organisation is  N.    I   then instead of writing  N.    I  again and again  it can be specified as default
            value for the field   ity .  o set the   efault  alue  property:
            Step 1:   lick on the field on which   efault value  property has to be set.

            Step 2:    lick on the   efault value  property definition box.
            Step 3:    ype the desired default value for the field.

            Step 4:   Save the  able.
             he maximum length for  efault  alue setting depends upon the length of the field.  efault value property is
            applied only when a new record is added. If the   efault value  property is changed  the change is not applied
            automatically to the existing records.




                     Default
                     value of
                     the  eld



















                                                                                  Database Management          267
   264   265   266   267   268   269   270   271   272   273   274