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

Step 3:   ight-click on the field which has to be deleted.

        Step 4:   lick on the   elete  option from the menu.  he selected field will be deleted from the table.

        Step 5:   lick on the  Save  button from the standard toolbar to make the effective changes.
        Modif ing  olumns fields

         he properties of any existing column field of a table can be modified.  o change the name  data type and
        properties of an existing column field:

          Select the table.
           lick on the   dit  button from the standard toolbar to open the table in   esign Mode .
           lick on the field to be modified.

          Make the re uired changes in the fields  i.e.  its name  type  etc.
           lick on the  Save  button.
                   N ot e s


                                                fields
                                                fields
                                                     of
                                                     of
                                                                            been
                                         modify
                                       or
                                       or
                                 delete
                                         modify
                                                                                 used
                                                                                 used
                                                                   fields
                                                               the
                                                               the
                                                                        have
                                                                        have
                                                                   fields
                                                              if
                                                         table
                                                       a
                                                       a
                                                              if
                                                                            been
                                                         table
                    he
                    he user cannot delete or modify fields of a table if the fields have been used in creating tables by using
                    he
                                                                                        creating
                                                                                        creating
                                                                                                tables
                                                                                                        using
                                                                                                        using
                                                                                                     by
                                                                                                tables
                                                                                                     by
                          canno
                          canno
                                                                                      in
                                t
                                 delete
                                                                                      in
                                t
                      user
                      user
                                                                             first
                                                                                                        been
                                                                                       the
                                                                                          table
                                                                                               which
                                                                                 delete
                                                                                                     has
                                                                          to
                                 i ard.

                                        o
                          iew....
                     reate
                     reate  iew....   i ard.  o delete or modify such fields  he has to first delete the table which has been
                     reate  iew....   i ard.  o delete or modify such fields  he has to first delete the table which has been
                                                              fields
                                                                    he
                                                                       has
                                                         such
                                          delete
                                                or
                                                   modify
                   created by using   reate  iew.....   i ard.
                   created by using   reate  iew.....   i ard.
           ENTERING DATA INTO A TABLE
         ntering data is the most important part after the creation of a table.  o enter data in the table:
        Step 1:  Open the table by double-clicking the table name from the Table Pane of database window.
                 Or
                 lick on the table name and then click on the  Open  atabase Ob ect  button from the standard
                toolbar.
         he table opens in the   able  ata  iew  window.
         258       Touchpad Information Technology-X
   255   256   257   258   259   260   261   262   263   264   265