Page 284 - IT 402 v2.0 class 10
P. 284

2



         hen you execute the preceding  uery  you will get the result as shown below:














        Using Wildcards

         ildcard characters are used to retrieve a particular record from a table that contains a specified character.
         ase provides two wildcard characters   and  .  he   wildcard represents one or more characters. On the other
        hands  the   wildcard represents only one character.

         erform 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:    se the   wildcard character to retrieve Name of the products that starts with the letter  M .


















                                                                                             2











         282       Touchpad Information Technology-X
   279   280   281   282   283   284   285   286   287   288   289