Page 293 - Trackpad 402_Class-X_Final
P. 293
Step 2: Set the criteria in different fields. In this case, we have set the criteria in two fields.
When you execute the preceding query, you will get the result as shown below:
Using Wildcards
Wildcard characters are used to retrieve a particular record from a table that contains a 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 ACCESSORIES table used in the preceding topic.
Step 2: Use the * wildcard character to retrieve Name of the products that starts with the letter ‘M’.
Database Management System 293

