Access 2016 Intermediate

Lesson 4 – Designing Advanced Queries

Access 2016

Open the Customer Addresses query in Design view.

Steps

Practice Data

1. Select the Criteria row in the desired field. The insertion point appears in the corresponding Criteria row. 2. Type an open bracket ( [ ), the desired prompt, a colon, and the close bracket ( ] ). The text appears in the Criteria row.

Scroll as necessary and click in the Criteria row of the Region field

Type [Enter the Region:]

3. Press [Enter] .

Press [Enter]

The parameter is added to the query.

Run the parameter query. At the prompt, type northeast and select OK . Notice that only records matching the criteria appear in the recordset.

Switch back to Design view and run the parameter query again. This time at the prompt, type southeast and select OK .

Close and save the query.

U SING M ULTIVALUED F IELDS



Discussion

When using a multivalued field in a query, you can choose whether to retrieve the entire multivalued field containing all the values separated by commas, or a separate row for each value.



Procedures

1. Open the desired table. 2. Select the Create tab on the Ribbon , if necessary.

Page 80

OFFICEPRO, Inc.