Access 2016 Intermediate

Access 2016

Lesson 3 – Using Operators in Queries

Wildcard

Used for

Example

*

One or more letters or numbers

M* finds all records that start with M; 8/*/2012 finds all dates in August, 2012; and *ball* finds all records that have the text ball anywhere in the field

NOTE Wildcards are not case-sensitive (for example, *ill finds Bill and bill). When you use wildcard characters ( ? and * ), Access automatically inserts the word Like before the criteria and quotation marks ( " " ) around text.



Procedures

1. Open the desired query in Design view. 2. Select the desired field’s Criteria row. 3. Type the desired criteria, using wildcards as appropriate. 4. Press [Enter] .



Step-by-Step

Use a wildcard character in a query.

If necessary, open the CSales Query query in Design view and delete any previous criteria.

Steps

Practice Data

1. Select the desired field’s Criteria row. The insertion point appears in the corresponding Criteria row .

Click in the Store Name field Criteria row

2. Type the desired criteria, using wildcards as appropriate.

Type sport*

The text appears in the Criteria row.

OFFICEPRO, Inc.

Page 65