Starting with LibreOffice Base
Complete exam-oriented revision notes for CBSE Class 10 Information Technology (402), based on the Domestic Data Entry Operator — Class X textbook.
✍️ Read • Revise • RecallSource check: Chapter 9 starts on printed page 157. The chapter introduces LibreOffice Base, database creation, data types, tables, primary keys, data entry, editing, sorting and record management.
What is LibreOffice Base?
LibreOffice Base is the database management component of LibreOffice. It is used to create and manage databases and provides tools for working with database objects such as tables, queries, forms and reports.
Why is Base Used?
A database helps in storing and managing large amounts of related information in an organised manner. LibreOffice Base provides an interface through which users can create databases and work with their stored data.
📌 Exam Point
LibreOffice Base is the database component of the LibreOffice suite used for creating and managing databases.
Database
A database is an organised collection of related data that can be stored, managed and retrieved efficiently.
Table
A table stores data in the form of rows and columns.
Field
A field represents a particular category or attribute of information in a table. For example, in a student table, Name, Class and Roll Number can be fields.
Record
A record is a complete set of related field values for one entry. In a table, a record is generally represented by a row.
| Term | Meaning |
|---|---|
| Database | Organised collection of related data. |
| Table | Stores data in rows and columns. |
| Field | Represents a category or attribute of data. |
| Record | Complete set of values representing one entry. |
Field = Column | Record = Row
When designing a database table, the data type of each field must be selected according to the kind of information that will be stored in it.
| Data Type | Used For |
|---|---|
| Text | Stores textual information such as names and addresses. |
| Numeric | Stores numerical values. |
| Currency | Stores monetary values. |
| Date | Stores dates. |
| Boolean | Stores logical values such as Yes/No or True/False. |
| Binary | Stores binary data. |
Always choose a field's data type according to the type of information that the field will contain.
Text → words • Numeric → numbers • Currency → money • Date → dates • Boolean → logical values • Binary → binary data
Opening LibreOffice Base
LibreOffice Base can be started from the LibreOffice Start Center. The Database option is selected to work with databases.
Database Wizard
When a new database is created, the Database Wizard helps the user create and save the database.
New Database
To create a new database, the option for creating a new database is selected in the Database Wizard. After completing the required steps, the database is saved.
Existing Database
An existing database can also be opened through the Database Wizard when the user wants to work with a previously created database.
Important Options
The Database Wizard provides options for creating a new database or opening an existing database.
Registering the Database
The wizard provides an option to register the database. Registration makes the database available for use through LibreOffice's database environment.
Opening the Database for Editing
The wizard also provides the option to open the database for editing after creation.
📌 Remember
When creating a new database, carefully complete the Database Wizard options and save the database file.
Database File
A LibreOffice Base database is saved as an .odb file.
LibreOffice Base database file extension → .odb
After opening a database, the LibreOffice Base interface provides access to the database objects and commands required for database management.
Database Objects
The main database objects that can be accessed through Base include:
- Tables — store data.
- Queries — retrieve selected information from data.
- Forms — provide an interface for entering or viewing data.
- Reports — present information in a formatted manner.
| Object | Main Purpose |
|---|---|
| Table | Stores data. |
| Query | Retrieves required information from stored data. |
| Form | Provides a user-friendly interface for entering or viewing data. |
| Report | Presents database information in a formatted form. |
Table = Store → Query = Retrieve → Form = Enter/View → Report = Present
What is a Table?
A table is the database object in which related information is stored in rows and columns. Before entering records, the structure of the table must be defined.
Ways to Create a Table
LibreOffice Base provides different ways to create a table. The important methods covered in this chapter are:
- Table Wizard
- Design View
Table Wizard
The Table Wizard assists the user in creating a table by providing predefined fields and guided steps. It is useful when a user wants to create a table quickly using available field structures.
Design View
In Design View, the user can define the table structure by specifying field names, data types and other field properties.
Table Wizard → guided method for creating a table.
Design View → allows the user to define the table
structure manually.
Field Name
A field name identifies the type of information stored in a field. For example:
- Student_ID
- Name
- Class
- Address
- Date_of_Birth
Field Type
The data type determines what kind of data can be stored in the field. Therefore, the field name and its data type should be selected carefully while designing a table.
📌 Important
A well-designed table should have meaningful field names and appropriate data types.
What is a Primary Key?
A Primary Key is a field or combination of fields that uniquely identifies each record in a table.
Why is Primary Key Important?
- It uniquely identifies records.
- It helps avoid duplicate identification of records.
- It provides a unique way to identify each record in a table.
Example
Suppose a Student table contains:
| Student_ID | Name | Class |
|---|---|---|
| 101 | Rahul | X |
| 102 | Priya | X |
| 103 | Aman | X |
Here, Student_ID can be used as the Primary Key because each student has a unique ID.
Primary Key = uniquely identifies each record in a table.
Primary Key → Unique Identity
Data Entry
After creating the table structure, records can be entered into the table. Data is entered into the appropriate fields of a record.
Navigation During Data Entry
The user can move between fields and records while entering data. Correct data entry is important because incorrect or incomplete data can affect the usefulness of the database.
📌 Exam Tip
Always enter data according to the defined field type. For example, a Date field should contain date information and a Numeric field should contain numerical information.
Editing a Record
If incorrect information has been entered into a table, the existing record can be edited. The required field is selected and its value is modified.
Why Edit Data?
- To correct incorrect information.
- To update existing information.
- To maintain accurate records.
Editing changes the value of an existing record; it does not mean creating an entirely new table.
Delete a Record
An unwanted record can be removed from a table using the appropriate delete command.
⚠️ Remember
Deleting a record removes that record from the table. Therefore, the correct record should be selected before performing the delete operation.
| Operation | Purpose |
|---|---|
| Insert / Enter | Add a new record. |
| Edit | Modify existing information. |
| Delete | Remove an existing record. |
What is Sorting?
Sorting means arranging records in a particular order based on the values of a selected field.
Ascending Order
Ascending order arranges values from smaller to larger or alphabetically from A to Z, depending on the type of data.
Descending Order
Descending order arranges values from larger to smaller or alphabetically from Z to A, depending on the type of data.
| Order | Meaning |
|---|---|
| Ascending | Small → Large / A → Z |
| Descending | Large → Small / Z → A |
Sorting by Multiple Fields
Records can also be sorted using more than one field. This is useful when records need to be arranged first according to one field and then according to another field.
Ascending: A → Z
Descending: Z → A
Sorting is used to arrange records in a meaningful order.
Before Closing
Before closing the database, make sure that required changes have been saved.
Closing the Database
The database can be closed using the appropriate close command or by closing the LibreOffice Base window.
📌 Best Practice
Save your changes before closing the database. This helps prevent loss of recently entered or modified data.
- LibreOffice Base is used for creating and managing databases.
- A database stores related information in an organised manner.
- A table stores data in rows and columns.
- A field represents a category of information.
- A record represents one complete entry.
- The data type determines the type of information stored in a field.
- Tables can be created using Table Wizard or Design View.
- A Primary Key uniquely identifies each record.
- Records can be entered, edited and deleted.
- Data can be sorted in ascending or descending order.
- A LibreOffice Base database is saved with the .odb extension.
- What is LibreOffice Base?
- What is a database?
- What is a table?
- What is a field?
- What is a record?
- What are the different data types used in a database?
- What is the use of the Database Wizard?
- What is the difference between Table Wizard and Design View?
- What is a Primary Key?
- Why is a Primary Key important?
- How can a new table be created in LibreOffice Base?
- How can records be entered into a table?
- How can an existing record be edited?
- How can a record be deleted?
- What is sorting?
- Differentiate between ascending and descending order.
- What is the file extension of a LibreOffice Base database?
- What are tables, queries, forms and reports used for?
Prepare definitions, differences, data types, Primary Key, Table Wizard vs Design View, record operations and sorting especially well.
⚡ CHAPTER 9 — RAPID REVISION
- LibreOffice Base: Database management component of LibreOffice.
- Database: Organised collection of related data.
- Table: Stores data in rows and columns.
- Field: Represents a category/attribute of information.
- Record: Complete set of field values for one entry.
- Data Types: Text, Numeric, Currency, Date, Boolean and Binary.
- Database Wizard: Helps create or open a database.
- Database Extension: .odb
- Table Creation: Table Wizard or Design View.
- Primary Key: Uniquely identifies each record.
- Data Entry: Used to add records to a table.
- Editing: Used to modify existing information.
- Deleting: Removes an existing record.
- Sorting: Arranges records according to selected field values.
- Ascending: A → Z / smaller → larger.
- Descending: Z → A / larger → smaller.
- Table: Stores data.
- Query: Retrieves required information.
- Form: Provides an interface for entering/viewing data.
- Report: Presents database information in formatted form.