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
   261   262   263   264   265   266   267   268   269   270   271