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

