Page 333 - TP_IT_V1.0_C10_flipbpookl
P. 333
To run a query in the Query Design window, click on the Run Query button in the toolbar
or press the F5 key from the keyboard.
Creating a Query using Wizard
Wizard is an easy way that guides you through the step-by-step process of creating queries. Follow the given steps to
create a query using a wizard:
Step 1: Select the Queries database object in the Database pane
Step 2: Select the Use Wizard to Create Query option under the Tasks pane.
The Query Wizard dialog box appears with eight steps pane on the left and the query details area on the right.
Step 3: 1. Field selection: Select the Table on which you want to create a query and the Available fields of the table.
In this case, we have selected the Book Issued table. The field of the selected table displays in the Available
fields list box. Select the BookID option from the Available fields list box and click on the button to move the
selected field to the Fields in the Query list box.
Similarly, move the Publisher, Book Name fields from the Available fields list box to Fields in the Query
list box.
Note that once the fields are added they can be moved up and down in order by clicking and buttons
present on the extreme right of the wizard.
Click on the Next button to move to the next step of the wizard.
Step 4: 2. Sorting order: This step helps you select the sorting order field. The result of the query can be displayed in
ascending or descending order of any particular field you selected in this step.
Do the following changes:
Sort by: Book Issued.Publisher
Order by: Ascending
Click on the Next button to move to the next step of the wizard.
Database Management System using LibreOffice Base 331

