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
   328   329   330   331   332   333   334   335   336   337   338