Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 96 - CoreGPT(Podar)_Flipbook_C8
P. 96

    Title Bar: It is the topmost bar of LibreOffice Base window that displays the name of the
                         currently opened database.
                          Menu Bar: It is a long bar present below the Title bar. It contains various menus such as File,
                         Edit, View and Insert to perform different types of tasks like save a file, open a file, create
                         database objects, etc.
                          Toolbar: It is a long bar present below the Menu bar. It contains icons for various commands
                         under different menus. It acts as a shortcut to these commands.
                          Database Pane: It is present on the left side of the LibreOffice Base window. It displays the
                         names of the objects used in the database, namely, Tables, Queries, Forms and Reports.

                          Tasks Pane: This pane lists the various tasks that can be done related to the database object
                         selected in the Database pane.
                          Description Pane: It is a pane on right-side in the Tasks pane. It gives the details about the
                         selected task in the Tasks pane.
                          Tables/Queries/Forms/Reports  Pane:  This  pane  helps  to  manage  and  access  different

                         database elements. It is typically located below the Tasks pane and includes:
                             Tables: Displays all tables storing structured data in rows and columns.
                             Queries: Displays all queries that retrieve specific data from tables based on set criteria.
                             Forms: Displays all created forms for entering and displaying data.
                             Reports: Displays all created reports.
                          Status Bar: This bar is located at the bottom of the LibreOffice window that shows information

                         about the current state of the database, such as the number of records in a table and the
                         active view type.

                            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

                       Memo            To store lengthy text and numbers such as notes and long descriptions. Stores
                                       upto 65,536 characters.
                       OLE Object      To link some files/documents with the record. This data type requires more space.

                       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.

                       Currency        To store values involving money. Currency sign is automatically added to every
                                       entry in this field.

                       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.

                     94     Premium Edition-VIII

| 91 92 93 94 95 96 97 98 99 100 101 |