Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 101 - CoreGPT(Podar)_Flipbook_C8
P. 101

    Working with Tables
                              8                                   in Base

                          Goal Glimpse

                             Field Types
                             Types of Table Views in LibreOffice Base

                             Rules for Writing a Field Name in LibreOffice Base

                             Creating a Table
                             Closing a Database and Exiting LibreOffice Base

                           FIELD TYPES

                     Field types determine the kind of data stored in fields. Once a field type is defined, only that type
                     of data can be entered and stored in it. If a different type of data is entered, an error message
                     will appear. In LibreOffice Base, there are four types of field types:

                     1.  Numeric types
                     2.  Character or String types
                     3.  Date and Time types
                     4.  Special field types
                     Numeric Types

                     Numeric types are used to store numbers and integers in a database. These are divided into two
                     categories:
                     1.   Whole Number Field Types: Used to store whole number data, including integers. Below are
                        the types in this category:

                              Field Type                                      Description

                         Tiny Integer            Stores small whole numbers or integers. Default length: 3 digits.
                         <TINYINT>
                         Small Integer           Stores small integers or whole numbers. Default length: 5 digits.
                         <SMALLINT>

                         Integer <INTEGER>       Accepts only integers. Default length: 10 digits.

                                                                                       Working with Tables in Base       99

| 96 97 98 99 100 101 102 103 104 105 106 |