Page 45 - Touchpad_Plus_V3.2_Class 8
P. 45

Step 4  Add the field's name to the query window and specify the criteria.





















                                                         Defining query criteria
                          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
                          box.
                                                                                              Saving a Query
                 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


                                                                                      More on LibreOffice Base       43
   40   41   42   43   44   45   46   47   48   49   50