ANSWERS: 1
-
Microsoft Office Access is database software that allows users to track information. Access features built in wizards and applications that make it suitable for beginners to use. It has numerous Visual Basic and SQL functions to sort, input and filter information.
Date Function
If the user inputs Date(), Access will return the current date. The function can also be used in Visual Basic with an assigned name and in SQL with a query.
Time
Similar to the date function, the time function returns the current time. The user inputs Time().
Average
The Avg function gives the mean of a selected set of numbers. To use the average function, the user inputs Avg (expression).
Sum
The sum function gives the sum of a selected group of numbers. The syntax "sum (expression)" is used.
Expression
For both the avg and sum functions, "expression" refers to a numeric value, either a formula or a field.
Source:
Copyright 2023, Wired Ivy, LLC