Question

Which is NOT an aggregation function in Access?

1) Count
2) Sum
3) Min
4) Multiply
5) These Are All Aggregation Functions

Answer 1

The 'Multiply' function is NOT an aggregation function in Microsoft Access. The aggregation functions in Access are Count, Sum, Min, and Max.

Aggregation functions in Access are used to perform calculations on a set of values and return a single value. The four aggregation functions in Access are Count, Sum, Min, and Max.

The Count function returns the number of records in a dataset, the Sum function calculates the total sum of a numeric field, the Min function returns the smallest value in a field, and the Max function returns the largest value in a field.