Page 251 - IT_V1.0_Class10
P. 251

Setting Multiple Fields Criteria
                 Perform the following steps to use multiple field criteria:


                 Step 1:   Create a query in Query Design window based on the following table:
                 Step 2:   Set the criteria in different fields. In this case, we have set the criteria in two fields Price is <10000
                          and ID is S02.

                 Step 3:  Save the query with the name Acc_Query. When you execute Acc_Query, you will get the result as
                          shown below:



















                                                                                          2


                 Using Wildcards
                 Wildcard characters are used to retrieve a particular record from a table that contains a specified character.
                 LibreOffice Base provides two wildcard characters * and ?. The * wildcard represents one or more characters.
                 On the other hands, the ? wildcard represents only one character.

                 Perform the following steps to use the wildcard characters:

                 Step 1:  Create a query in Design view based on the ACCESSORIES table used in the preceding topic.
                 Step 2:  Use the wildcard character to retrieve name of the products that starts with the letter LIKE ‘M*’.

                 Step 3:  Save the query with the name Accessories_Query. When you run Accessories_Query, you will get
                          the following output:




















                                                                   2







                                                                                                  Queries in Base   249
   246   247   248   249   250   251   252   253   254   255   256