Page 235 - IT_V1.0_Class10
P. 235

Deleting Columns/Fields

                 The steps to delete a column/field from the table are as follows:

                 Step 1:  Right-click the table from the Tables pane from which the column/field is to be deleted. In our case,
                          we have right-clicked the Student table.
                 Step 2:  Click on the Edit option from the context menu.
                          The Student table opens in the Table Design window.

                 Step 3:  Right-click on the field which has to be deleted. In
                          our case, we have right-clicked the ADDRESS field.  5
                 Step 4:  Click on the Delete option from the context menu.
                          The selected field will be deleted from the table.

                 Step 5:  Click on the Save button in the Standard toolbar.

                 Modifying Columns/Fields                                     3
                 The properties of any existing column/field of a table can be   4
                 modified. To change the name, data type and properties of
                 an existing column/field, you need to perform the following
                 steps:

                 Step 1:  Right-click the table from the Tables pane from which the column/field is to be modified. In our
                          case, we have right-clicked the Student table.

                 Step 2:  Click on the Edit option from the context
                          menu.
                                                                      4
                          The  Student  table opens  in the  Table
                          Design window.
                                                                      3
                 Step 3:  Make  the  required  changes  in  the  fields,
                          i.e., its Field Name, Field Type, etc. In our
                          case,  we  have  changed  the  field  name
                          from STUDID to STUD_ID.
                 Step 4:  Click on the Save button in the Standard
                          toolbar.

                 Renaming a Table

                 Renaming a table in LibreOffice Base allows you to modify the table’s name to better reflect its content or
                 purpose. To rename a table, perform the following steps:
                 Step 1:  Right-click the table from the Tables pane in which column/field is to be inserted. In our case, we
                          have right-clicked the Student table.

                 Step 2:  Select the Rename option from the context menu.
                                                                                                                       3
                          The Rename to dialog box opens.
                 Step 3:  Type the new name for the table in the Table Name
                          text box.
                                                                                                4
                 Step 4:  Click on the OK button to rename the table.


                                                                                      Working with Multiple Tables   233
   230   231   232   233   234   235   236   237   238   239   240