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

dding  olumns fields

             o add a new column field after the last column field:

            Step 1:  Select the table in which column field is to be inserted.

            Step 2:   lick on the   dit  button from the standard toolbar to open the table in   esign Mode .
            Step 3:   ype the name of the field  its data type and set the properties.

            Step 4:   lick on the  Save  button.
                ‘Edit’
               button.




                                                                               4

              Selected
               table.













                                                   3



             eleting  olumns fields

             xisting columns fields from a table can be deleted.  o delete a column field from the table:

            Step 1:  Select the  able from the   able  indow  pane in which column field is to be deleted.
            Step 2:   lick on the   dit  button from the standard toolbar to open the table in   esign Mode .

































                                                                                  Database Management          257
   254   255   256   257   258   259   260   261   262   263   264