Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

Steps

Practice Data

1. Select the calculated field you want to format. The insertion point appears in the field. 2. Select the Property Sheet button on the Design tab. The Property Sheet pane opens. 3. Select the General page in the Field Properties box in the Property Sheet pane. The General page appears.

Scroll as necessary and click anywhere in the Commission:[ord tot]*[commission rate] field

Click

Click the General tab, if necessary

4. Select the Format box.

Click in the Format box

A drop-down arrow appears in the Format box.

5. Select the Format list.

Click Format

A list of available formats appears.

6. Select the desired format.

Scroll as necessary and click Currency

The format appears in the Format box.

If necessary, close the Property Sheet pane. Then, run the query. Notice that the Commission field is now formatted as currency.

Close the query, saving the changes.

D ISPLAYING A T OTALS R OW IN A Q UERY



Discussion

You can now perform calculations in a query using aggregate functions, such as displaying a totals row. Access queries support the aggregate functions shown in the following table:

Function

Description

None

No calculations.

Sum

Calculates the total of the values in a field.

OFFICEPRO, Inc.

Page 75