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
   24   25   26   27   28   29   30   31   32   33   34