Page 338 - TP_IT_V1.0_C10_flipbpookl
P. 338

Step 6:  Save the query with the specified name.
                      When you execute the preceding query, you will get the result as shown below:















              Using Wildcards
              Wildcard characters are used to retrieve a set of records from a table that contains some specified character. 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 STUDENTS table.
              Step 2:   Use the “*” wildcard character to retrieve all the fields of the Book Issued table where Publisher name is
                      starts with the letter ‘O’.































                      When you run the preceding query, you will get the following output:





















                336   Trackpad Information Technology (Ver. 1.0)-X
   333   334   335   336   337   338   339   340   341   342   343