Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 117 - CoreGPT(Podar)_Flipbook_C8
P. 117

    The parameters of the design grid in the bottom part of the Query window are:

                                   Field: It is the first row of the design grid that displays the selected field names from
                                  the table.
                                  Alias: It allows us to give a secondary name to a table.
                                  Table: It displays the name of the existing tables in the relationship window.

                                  Sort: It displays the data in either descending or ascending order during the run time.
                                   Visible: It means that the field with the check mark will be displayed in the result
                                  and the fields with an uncheck mark will not be displayed when the query runs.

                                  Function: It allows to use built-in functions of LibreOffice Base.
                                   Criterion: It displays the condition on the basis of which the records will be filtered
                                  and displayed in the query output.
                                  Or: It is used to set multiple conditions in a query.

                     Step 5  Click on the Save (     ) button on the Query Design
                              toolbar. The Save As dialog box opens.

                     Step 6  Type the name of the query in the Query name text                  Saving a Query
                              box.

                     Step 7  Click on the OK button.
                     After creating the query, we need to run the query by clicking on the Run option from the Edit
                     menu. The related records of the query will be displayed in the Datasheet view.

                                        Running a query                                     Query result

                              Tech Funda

                           To run a query: F5

                                                                         Working with Queries, Forms and Reports        115

| 112 113 114 115 116 117 118 119 120 121 122 |