Page 32 - ModularV1.1 _c8_flipbook
P. 32

Step 3  Click on the type of field that you want to add in your table under the Add & Delete
                          group of the Fields tab. In this case, we have clicked the Text command to add a text

                          field. A new column with the name Field 1 will be added into the table.












                                     Adding a column                             New field in table

                  There  are  some other  commands like  Number, Currency,  Date &  Time  and  Yes/No also
                  available to add numerals, money, date/time and yes/no types of columns/fields in a table.

                   Tech


                     Funda
                                    Click on the More Fields command under the Add & Delete group of the
                                    Fields tab to get more types of fields.


                  Deleting a Column

                  Perform the following steps to delete a column from a table:
                  Step 1  Select the column that you want
                          to delete.
                  Step 2  Click on the  Delete command

                          under the Add & Delete group
                          of the Fields tab. The Microsoft
                          Access dialog box appears.
                                                                                  Deleting a column
                  Step 3  Click on the  Yes button.  The
                          selected column will be deleted from the table.







                                                        Microsoft Access dialog box

                  Hiding a Column

                  MS Access allows you to hide a column in a table. The column you hide will not be visible to the
                  user. However, it is present in the table. Perform the following steps to hide a column:
                  Step 1  Right-click on the selected column. A context menu appears.

                  Step 2  Select the Hide Fields option from the context menu. The selected column will be
                          hidden.

                  30      Modular (Ver. 1.1)-VIII
   27   28   29   30   31   32   33   34   35   36   37