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

onsider about the following points while creating a table:

          In a table  each field should have a uni ue name. No two fields in a table can have the identical name.

           ach field should be predefined with data type that identifies the type of data to be entered in  that
           field.

            special field which uni uely identifies a record in a table is called primary key. In primary key column  no
           two records can be identical, for example, in your class, two students cannot have the same roll number
           even if their names are same.
         o set the   rimary key  for the table:

        Step 1:   osition the mouse pointer on the field which is to be set as primary key.

        Step 2:   ight click the mouse button and select the option   rimary  ey .
        Step 3:  Select  rimary  ey.

        Step 4:   rimary key defined.










                                                                              4














                    3








        Step 5:   lick on the  Save  icon from the standard toolbar.  Save  s  dialog box appears on the screen.

        Step 6:  Type the name of table.

        Step 7:   lick on the  O   button.   table with the given name is created.
                                                                       6








                                 7





         250       Touchpad Information Technology-X
   247   248   249   250   251   252   253   254   255   256   257