Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

Run the query. Widen the SumOfSales to Date column as necessary. Notice that the records are now grouped by region, and the sum of the sales to date for each region appears in the new SumOfSales to Date field.

Close and save the query.

C REATING A P ARAMETER Q UERY



Discussion

Create a query where you can add different criteria each time you run it; such a query is called a parameter query. A parameter query is designed to prompt the user for input each time it is run; Access then runs the query based on the criterion (parameter) entered. A parameter query allows you to quickly and easily change query criteria without having to redesign the query.

Creating a parameter query

NOTE Add multiple parameters to a query; when you run the query, a prompt will appear for each parameter in it.



Procedures

1. Open the desired query in Design view. 2. Select the Criteria row in the desired field. 3. Type an open bracket ( [ ), the desired prompt, a colon, and the close bracket ( ] ). 4. Press [Enter] .



Step-by-Step

Create a parameter query.

OFFICEPRO, Inc.

Page 79