Using Wildcards
If you want to select records that contain certain patterns of characters or cannot remember an exact data entry, use the wildcards ( * and ?) in your search. The question mark ( ?) stands for any single character, while the asterisk ( *) stands for any number of characters in the same position. MS Access inserts the Like command before the entered expression.