Criteria When you are creating a criteria in the Design View window, the data type of the field determines the way in which criteria are specified for that field. The selection criteria in Access work like the selection criteria in Excel. All of the fields entered on one line are AND conditions. The relational operators are common with Excel. There are two special functions are available in Access demonstrated by this screen capture.
Access understands two wild card symbols.
Wild card symbols are symbols used to represent any symbol. 1 Chapter 3 Page 130.