An aggregate function is commonly known as a function used to calculate the number of entries as well as the sum or average of any entries given within a particular column

An aggregate function is commonly known as a function used to calculate the number of entries as well as the sum or average of any entries given within a particular column. Or the largest or smallest of the entries given within a particular column also commonly referred to as a function. Access as well as any other products that may support QBE have support within for the following functions known as aggregate function within when working in access. Avg which stands for average, CountSum,Max which refers to the largest value within the database,StDev which stands for standard deviation variance ,Min which refers the smallest value within the database, First and last. In order to use any of the aggregate functions mentioned above within a query, you must include them in the total row for the column in the design grid. The total row does not appear on its own within the design grid. You must click the total button in the show hide group on the query tools design tab. Once you have done this any changes you have made to you database using any of the six available aggregate to Access will be able to be seen by the user and anyone else using the databases.

x

Hi!
I'm Delia!

Would you like to get a custom essay? How about receiving a customized one?

Check it out