Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 115 - CoreGPT(Podar)_Flipbook_C8
P. 115

    Tools menu

                     Step 2  Select the table  and click on the Add button.
                              The selected table will appear in the Relation
                              Design window. Repeat clicking Add button to
                              add more tables in the Relation Design window.
                              When all the required tables have been added,
                              click on the Close button.
                     Step 3  Press and hold the left mouse button on the
                              Primary Key field of one table.
                     Step 4  Drag the mouse pointer to the common field in
                              the other table and release the mouse button.                       Add table

                              This will create a line or relationship between
                              the related fields of the two tables.

                              Relationship established between Student table
                              and Fee table based on the field named ‘Roll
                              No’.

                           QUERIES IN LIBREOFFICE BASE

                     A query is one of the most powerful features in LibreOffice
                     Base, allowing you to retrieve specific information that
                     may not be easily visible in the tables directly. With a                Relationship Created
                     query, you can search or compile data from one or more
                     tables in a database by giving specific search conditions so that enables  to view the exact data

                     that you want. Queries in Base are primarily used to display and analyze data. Once created, a
                     query can be saved in the database and run multiple times for efficient data retrieval.
                     Types of Queries

                     The different types of queries in LibreOffice Base are:
                        Select Query: It retrieves specific data based on conditions, displaying chosen fields from one
                       or more tables.

                                                                         Working with Queries, Forms and Reports        113

| 110 111 112 113 114 115 116 117 118 119 120 |