Ch 9: Starting with LibreOffice Base
LibreOffice Base
Base is a free, open-source RDBMS. A database file is saved with the extension .odb.
Data Types
| Category | Use |
|---|---|
| Text (Memo/Char/Varchar) | Descriptive text; Char = fixed, Varchar = variable length. |
| Numeric | Numbers for calculations. |
| Currency | Monetary values. |
| Date/Time | Date, Time, Timestamp. |
| Boolean | Yes/No, True/False. |
| Binary | Digitised images and sounds. |
Creating a Table — Two Ways
1. Using a Wizard (ready-made sample tables). 2. Using Design View (choose your own fields).
Design View has three columns: Field Name, Field Type, Description. Set the primary key by right-clicking before the field name (a key icon appears). Save with Ctrl+S.
Working with Data
- Enter data by double-clicking the table;
Tabmoves to the next field. - Navigate, edit, delete (
Del) and sort (ascending/descending).
Summary
- Base is a free RDBMS; files are .odb.
- Tables are created by Wizard or Design View; primary key set by right-click.
- Data can be entered, edited, deleted and sorted.
LibreOffice Base
Base एक मुफ़्त, open-source RDBMS है। Database file .odb extension से save होती है।
Data Types
| Category | उपयोग |
|---|---|
| Text (Memo/Char/Varchar) | वर्णनात्मक text; Char = fixed, Varchar = variable length। |
| Numeric | गणना के लिए numbers। |
| Currency | मुद्रा के values। |
| Date/Time | Date, Time, Timestamp। |
| Boolean | Yes/No, True/False। |
| Binary | Digitised images और sounds। |
Table बनाना — दो तरीके
1. Wizard से (ready-made sample tables)। 2. Design View से (अपने fields चुनें)।
Design View में तीन columns: Field Name, Field Type, Description। Primary key सेट करें field name से पहले right-click करके (key icon दिखेगा)। Ctrl+S से save करें।
Data के साथ काम
- Table double-click करके data डालें;
Tabअगले field पर ले जाता है। - Navigate, edit, delete (
Del) और sort (ascending/descending)।
सारांश
- Base मुफ़्त RDBMS है; files .odb।
- Tables Wizard या Design View से बनते हैं; primary key right-click से।
- Data enter, edit, delete और sort किया जा सकता है।
Frequently Asked Questions
What is the file extension of a LibreOffice Base database?
A LibreOffice Base database is saved with the .odb extension.
Which data type stores digitised images?
The Binary data type stores digitised images and sounds.