Page 230 - IT_V1.0_Class10
P. 230
Deleting Data
To delete a row/record from the table:
Step 1: Open the Student table by double-clicking on its name in the Tables pane.
The Student table opens in the Table Data View window.
Step 2: Select the record you want to delete.
Step 3: Click on Edit → Delete Record option from the Menu bar.
OR
Right-click the selected record and select the Delete Rows option from the context menu.
LibreOffice Base displays a Confirmation message dialog box asking the user whether they want to
delete the selected record or not.
Step 4: Click on the Yes button to delete the selected record else click on the No button to cancel the
operation. In our case, we have clicked on the No button.
2
4
3
Notes
To delete multiple rows from the table, you need to select multiple rows by holding down the Ctrl key
while clicking the row headers and then deleting the selected rows at once.
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
#Information Literacy
Skills
Complete the following activities and tick the circle.
Create a Table namely ‘Employee’ with the following fields:
Field Name Data Type Field Name Data Type
Emp_ID Numeric F_Name Text [VARCHAR]
Emp_Name Text [VARCHAR] Designation Text [VARCHAR]
DOB Date [DATE] Address1 Text [VARCHAR]
Set the field Emp_ID as Primary Key and save the Table by name `Empmast’.
Add a new field namely DOJ (Data type Date), Address2, Phone, City and State (Data
Type Text).
Delete the field City from the table.
Enter 10 records in the table.
Update the values of the fields DOB and DOJ as entered in the second and sixth records.
228 Information Technology Play (Ver 1.0)-X

