Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 114 - CoreGPT(Podar)_Flipbook_C8
P. 114

    9             Working with queries, forms

                                                            and reports

                           Goal Glimpse

                               Creating Relationship between Tables          Queries in LibreOffice Base
                               Forms in LibreOffice Base                     Reports in LibreOffice Base

                      In LibreOffice Base, Forms, Queries and Reports streamline database management by simplifying
                      data  entry,  retrieval  and  presentation.  Forms  allow  easy  data  input  with  interactive  controls,
                      Queries filter and extract specific information from tables and Reports present this data in a
                      polished, shareable format. Together, they enhance efficiency and usability across all aspects of

                      database work.

                            CREATING RELATIONSHIP BETWEEN TABLES

                      A relationship is a link that associates a field in one table with the same field in another table. It
                      works by matching a field with the same name in both the tables. The matching fields are the
                      Primary Key from one table that uniquely identifies each record in a table.
                      A Foreign Key is a column in one table that must match the Primary Key of another table.

                      To create a relationship, create two tables:

                           Table named Student that holds general information about the students such as their Roll No,
                         Student Name, Father’s Name, Mother’s Name, Date of Birth, etc.

                          Table named Fee that holds information about Reg No, Roll No, Fee, etc.

                                                        Using tables for defining relationship
                      To define relationship between the two tables, follow these steps:
                      Step 1  Click on the Relationships option from the Tools menu. The Add Tables dialog box
                               will open.

                    112     Premium Edition-VIII

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