Microsoft Office Tutorials and References
In Depth Information
To Use a Wildcard
Microsoft Access supports wildcards. Wildcards are symbols that represent any character or combination of
characters. One common wildcard, the asterisk ), represents any collection of characters. Thus Be* represents *
the letters, Be, followed by any collection of characters. Another wildcard symbol is the question mark ), which ?
represents any individual character. Thus T?m represents the letter, T, followed by any single character followed by
the letter, m, such as Tim or Tom.
The following steps use a wildcard to ﬁ nd the number, name, and address of those clients whose names begin
with Be. Because you do not know how many characters will follow the Be, the asterisk is appropriate.
• Click the View button to return
to Design view.
• If necessary, click the Criteria row
below the Client Number ﬁ eld to
produce an insertion point.
• Use the DELETE or BACKSPACE key
as necessary to delete the current
• Click the Criteria row below the
Client Name ﬁ eld to produce an
• Type Be* as the criterion
Name ﬁ eld
• View the query results by clicking
the View button (Figure 2–16).
• Vary the case of the letters in the
criteria and view the results to
determine whether case makes
a difference when entering a
only clients whose
names begin with
Be are included