For easy reference, we have provided a list of all Microsoft Access functions. The list of Access functions is sorted into the type of function based on categories such as string, numeric/mathematical, date/time, advanced/logical, domain aggregate, data type conversion, group by, and file/directory functions.
It is important to note that there are 2 type of functions in Access - functions used in SQL/Queries and functions used in VBA code. Some functions can be used as both, but some can not.
Below is the list of MSAccess functions, sorted by category (ie: type of function).