Follow us:
access functions

MS Access: Functions - Listed by Category

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).

String Functions

Numeric / Mathematical Functions

Date / Time Functions

Advanced / Logical Functions

Information Functions

Domain Aggregate Functions

Data Type Conversion Functions

Group By Functions

File / Directory Functions

Miscellaneous Functions