Ch 9: Starting with LibreOffice Base
LibreOffice Base
.odb (default name NewDatabase.odb).Data Types
A field's data type decides what kind of value it can store and how much memory it uses.
| Category | Use / Examples |
|---|---|
| Text — Memo (LONGVARCHAR) | Descriptive data up to 64,000 characters. |
| Text — Char (fixed) | Fixed length, e.g. licence / passport number. |
| Text — Varchar | Variable length up to a limit; uses only the needed bytes. |
| Numeric | Numbers for calculations — Integer, Decimal, Float, etc. |
| Currency | Monetary values, e.g. $100, Rs. 25.50. |
| Date/Time | Date, Time, Timestamp. |
| Boolean | Two values — Yes/No, True/False, On/Off. |
| Binary | Digitised images and sounds. |
Creating a Database
- Open Base — the Database Wizard appears.
- Choose Create a new database and click Next.
- Choose No, do not register the database and click Finish.
- Save with a name (extension
.odb).
Creating a Table — Two Ways
Design View has three columns: Field Name, Field Type, Description. The Field Properties pane at the bottom controls and validates the data (length, format, auto-value).
- Type each Field Name and choose its Field Type; add a Description (optional).
- Set the primary key: right-click before the field name > Primary Key (a key icon appears). For a composite key, hold
Ctrland select multiple fields. - Save the table (
Ctrl+S) and give it a name.
Working with Data
- Enter data: double-click the table > type values >
Tabmoves to the next field. - Navigation box: shows the current record with First / Previous / Next / Last buttons.
- Edit: click the value and retype;
Esccancels. - Delete: select the record row >
Del> confirm Yes. - Sort: select a field > Sort Ascending / Descending; use the Sort icon for multiple fields.
Summary
- Base is a free RDBMS; files are
.odb. - The data type decides what a field stores and its memory size.
- Tables are created by Wizard or Design View; the primary key is set by right-click.
- Data can be entered, navigated, edited, deleted and sorted (ascending/descending).
Quick check: 3 MCQs (tap an option)
Q1. A LibreOffice Base database file has the extension:
Default name is NewDatabase.odb.
Q2. Which data type stores only two values like Yes/No?
Boolean = True/False, Yes/No, On/Off.
Q3. Design View of a table has which three columns?
Field Properties appear at the bottom.
LibreOffice Base
.odb extension से save होती है (default नाम NewDatabase.odb)।Data Types
Field का data type तय करता है कि उसमें किस तरह की value आएगी और कितनी memory लगेगी।
| Category | इस्तेमाल / उदाहरण |
|---|---|
| Text — Memo (LONGVARCHAR) | 64,000 characters तक descriptive data। |
| Text — Char (fixed) | Fixed length, जैसे licence / passport number। |
| Text — Varchar | एक limit तक variable length; सिर्फ़ ज़रूरी bytes लेता है। |
| Numeric | गणना के numbers — Integer, Decimal, Float आदि। |
| Currency | पैसे की values, जैसे $100, Rs. 25.50। |
| Date/Time | Date, Time, Timestamp। |
| Boolean | दो values — Yes/No, True/False, On/Off। |
| Binary | Digitised images और sounds। |
Database बनाना
- Base खोलिए — Database Wizard आता है।
- Create a new database चुनकर Next कीजिए।
- No, do not register the database चुनकर Finish कीजिए।
- नाम देकर save कीजिए (extension
.odb)।
Table बनाना — दो तरीके
Design View के तीन columns: Field Name, Field Type, Description। नीचे का Field Properties pane data को control और validate करता है (length, format, auto-value)।
- हर Field Name लिखिए और उसका Field Type चुनिए; Description (optional) जोड़िए।
- Primary key set करना: field name से पहले right-click > Primary Key (key icon दिखता है)। Composite key के लिए
Ctrlदबाकर कई fields चुनिए। - Table save कीजिए (
Ctrl+S) और नाम दीजिए।
Data के साथ काम
- Data enter: table double-click > values type कीजिए >
Tabअगले field पर ले जाता है। - Navigation box: मौजूदा record को First / Previous / Next / Last buttons के साथ दिखाता है।
- Edit: value पर click करके फिर से type कीजिए;
Esccancel करता है। - Delete: record row चुनिए >
Del> Yes confirm कीजिए। - Sort: field चुनिए > Sort Ascending / Descending; कई fields के लिए Sort icon।
सारांश
- Base मुफ़्त RDBMS है; files
.odbहोती हैं। - Data type तय करता है field क्या store करे और उसकी memory।
- Tables Wizard या Design View से बनती हैं; primary key right-click से set होती है।
- Data enter, navigate, edit, delete और sort (ascending/descending) किया जा सकता है।
झटपट जाँच: 3 MCQs (option पर tap करें)
Q1. LibreOffice Base database file का extension है:
Default नाम NewDatabase.odb है।
Q2. कौन सा data type सिर्फ़ Yes/No जैसी दो values रखता है?
Boolean = True/False, Yes/No, On/Off।
Q3. Table के Design View में कौन से तीन columns होते हैं?
Field Properties नीचे दिखती हैं।
Frequently Asked Questions
What is LibreOffice Base and what is its file extension?
LibreOffice Base is a free, open-source relational database management system (RDBMS). Its database files are saved with the .odb extension.
What are the two ways to create a table in Base?
A table can be created using a Wizard, which provides ready-made sample tables, or using Design View, where you choose your own fields for full flexibility.
How do you set a primary key in Design View?
Right-click just before the field name and choose Primary Key; a key icon appears. For a composite key, hold Ctrl and select more than one field.
Why is the data type of a field important?
The data type decides what kind of value a field can store (text, number, date, currency, boolean, etc.) and how much memory it uses, which keeps the data valid and efficient.
