Page 29 - Touchpad_Plus_V3.2_Class 8
P. 29
DATA TYPES IN LIBREOFFICE BASE
The data types are used to declare the type of the fields in the database. LibreOffice Base provides
the following data types:
Data Type Description
Integer It is used to store numbers, both positive and negative, without decimal points
Decimal It is used to store numbers with a decimal point.
Number It is used to enter numerical values and perform numerical calculations.
Text It is used to store text or a combination of text and number. This type cannot
be used for numeric calculations and is suitable for names, descriptions,
and identifiers.
Image It is used to store image file references in tables, enabling visual data
representation.
Yes/No It is used in places where the fields can have boolean value. It can be either
True (T) or False (F).
Date It is used to store dates like date of birth, date of joining, etc.
Time It is used to store time related data like time of arrival, time of departure, etc.
Others It is used for detailed and descriptive fields.
TYPES OF TABLE VIEWS IN LIBREOFFICE BASE
There are two types of table views in LibreOffice Base—Table Data View and Table Design View.
Let’s learn about these.
Table Data View
Table Data View is the default view of the table. It shows all the fields and the records as entered
by the user. In this view, you can edit records of the table.
Table Data view
Table Design View
The Table Design View allows users to define and modify the structure of a table, including field
types, properties, etc. The Table Design view is divided into two parts:
Field Grid Pane: It is used to define the field names and their data types.
Field Properties Pane: It is used to set the properties for the fields defined in the table.
Introduction to LibreOffice Base 27

