When using a datasheet, explain what an aggregate function is and identify an aggregate function and explain what it does
What will be an ideal response?
An aggregate function performs calculations on an entire column of data returning a single value. The aggregate functions are:AVG -Calculates the average value for a column
COUNT - Counts the number of items in a column
MAXIMUM - Returns the item with the highest value
MINIMUM - Returns the item with the lowest value
SUM - Adds the items in a column
Computer Science & Information Technology
You might also like to view...
A ________ procedure in VBA performs an action but does not return a specific value
A) property B) sub C) private D) function
Computer Science & Information Technology
When using support libraries, your application’s Activity class should extend from what support library class?
a. ActivityCompat b. SupportActivity c. AppCompatActivity d. StyleActivity
Computer Science & Information Technology