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 fi 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.
1
Click the View button to return
to Design view.
View button
If necessary, click the Criteria row
below the Client Number fi eld to
produce an insertion point.
Use the DELETE or BACKSPACE key
as necessary to delete the current
entry.
Click the Criteria row below the
Client Name fi eld to produce an
insertion point.
wildcard
Type Be* as the criterion
(Figure 2–15).
criterion
for Client
Name fi eld
Figure 2–15
2
View the query results by clicking
the View button (Figure 2–16).
I
View button
Experiment
Vary the case of the letters in the
criteria and view the results to
determine whether case makes
a difference when entering a
wildcard.
query results
only clients whose
names begin with
Be are included
Figure 2–16
 
Search JabSto ::




Custom Search