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

