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

