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

