Page 266 - IT 402 v2.0 class 10
P. 266
Lab Assignment ‘n Activity S ub j e ct E nr ich me nt
Complete the following activities and tick on the circle.
reate a able Salesman with the following structure:
Field Name ata ype
SM I Number N M I
SM Name ext 5 haracters
ddress ext haracters
ddress ext haracters
ity ext 5 haracters
State ext 5 haracters
in ode Number
Sell mt Number
omm Number
hone Number
a Insert a new field ender . se default value of ender field as Male .
b Insert at least 5 records in the able.
c Save and lose the able.
d Open the able Salesman again and elete ecord numbers and .
e Modify the width of the ddress and ddress field as ext 5 haracters .
f Sort the records of the table in ascending order of SM N M field.
g Sort the records of the table in descending order of SM N M field.
264 Touchpad Information Technology-X

