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

