Access 2016 Intermediate

Lesson 4 – Designing Advanced Queries

Access 2016

Function

Description

Average

Calculates the average of the values in a field.

Count

Calculates the number of values in a field, not counting Null (blank) values.

Maximum

Calculates the highest value in a field.

Minimum

Calculates the lowest value in a field.

Standard Deviation

Calculates the standard deviation of the values in a field.

Variance

Calculates the variance of the values in a field.



Procedures

1. Open the desired query in Datasheet view. 2. Select the Home tab on the Ribbon , if necessary.

3. Select the Totals button

in the Records group.

4. In the totals row, select the field you want to total.

5. Select the arrow. 6. Select the desired function.



Step-by-Step

Display a totals row in a query.

Open the Region Totals query in datasheet view

Steps

Practice Data

1. Select the Home tab on the Ribbon , if necessary. The Home tab appears.

Click Home

2. Select the Totals button in the Records group.

Click

The Show Tables dialog box appears.

3. In the totals row, select the field you want to total. The arrow appears.

In the totals row, click in the Sales to Date field

Page 76

OFFICEPRO, Inc.