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

Step 8:   lick on  File  menu from the Menu bar and select the   lose  option to close the table.























                                    Created table.



                                              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 namely  S    N   using  esign  iew with the following fields:
                    Field Name          Field Type            Field Name                  Field Type

                    Stu I               Numeric               Marks  ng                   Numeric
                    Stu Name             ext                  Marks  indi                 Numeric
                     O                   ate                  Marks Maths                 Numeric
                     lass                ext                  Marks Science               Numeric
                    Sec                  ext                  Marks SS                    Numeric
                     oll No             Numeric                otal                       Numeric

                  a   Set Stu I  as  rimary  ey and with Numeric data type.
                  b   Set the field properties as:
                     i    idth of Stu Name as    characters.
                     ii    O  as  an        .
                     iii   Set re uired property as   es  for Stu Name.





               CREATE TABLE BY USING WIZARD

             i ards are the predefined format which already exist in the package.  his option provides the facility that
            enables the user to select a category  re uired fields from predefined tables and to set type  formats and
            primary key and create a table.

            Step 1:   lick on the option   se  i ard to  reate  able...  from  asks pane. It opens with two pre-existing
                    categories of databases  i.e.    usiness  and   ersonal .





                                                                                  Database Management          251
   248   249   250   251   252   253   254   255   256   257   258