Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 103 - CoreGPT(Podar)_Flipbook_C8
P. 103

    Special Field Types

                     These are used to store special data, such as Yes/No values, binary data, images, etc. Below are
                     some special field types:

                                Field Type                                      Description

                       Yes/No <BOOLEAN>               Stores Boolean values (Yes or No), i.e., 1 or 0.

                       Binary(fix) <BINARY>           Stores Boolean data, encrypted files or files with different
                                                      extensions. Can store up to 2GB of data.

                       Binary <VARBINARY>             Similar to the Binary(fix) type but allows variable field length.

                       Image <LONGVARBINARY> Stores images, sounds and other media, allowing up to 2GB
                                                      of data.

                       Other <OTHER>                  Stores any kind of data, including binary data, images, sound
                                                      clips and more.

                           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 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.

                                                               Table Design view
                     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.

                                                                                       Working with Tables in Base      101

| 98 99 100 101 102 103 104 105 106 107 108 |