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
   225   226   227   228   229   230   231   232   233   234   235