Page 232 - IT_V1.0_Class10
P. 232

The Student table opens in the Table Data View window.

              Step 2:  Click on the Sort button from the Table Data toolbar. The Sort Order window opens.
              Step 3:  Apply multiple sort criteria by selecting the field and its order one by one in Field name and Order
                       box, respectively. The records of the table will be sorted accordingly.


              Step 4:  Click the OK button.


















                       The records of the table will be sorted accordingly.

                  Recap Zone


                   LibreOffice Base is a database management software that allows you to create and manage databases.

                   Database stores different types of data; like characters, date, number, symbol, OLE (Object Linking
                    and Embedding) objects, etc.
                   Data  types  in  LibreOffice  Base  are  broadly  classified  into  five  main  categories,  which  are:  Text,
                    Numeric, Date and Time, Binary, and Boolean.
                   To create a table, click on the Tables object from the Database pane.
                   LibreOffice Base allows to modify the structure of the table even after creating and saving a table.
                    The user can add new fields, remove existing fields or change the properties of the existing fields.

                   The pointing arrow preceding the field name is the record pointer, which helps navigate through
                    records in a table.
                   Entering data is the most important part after the creation of a table.
                   Sorting means to arrange the data of a table in a particular order like in ascending or descending
                    order.




                                                          Exercise



                                                 Section A (Objective Type Questions)
              A.  Multiple choice questions.
                  1.  Which of the following data types would be used to store true/false values in LibreOffice Base?
                    i.  Numeric            ii.  Boolean              iii.  Date and Time          iv.  Text
                  2.  Identify the property which helps to set the number of characters in text/varchar type field of a table in DBMS.
                                                                                               [CBSE Sample Paper 2023]
                    i.  Entry Required     ii.  Size                 iii.  Default Value          iv.  Length




                230     Information Technology Play (Ver 1.0)-X
   227   228   229   230   231   232   233   234   235   236   237