The following reference lists all the functions alphabetically.
Note Functions marked with an (*) should not be used within a data access page against a stored query.
A–C
| Abs (VBA) | Cos (VBA) |
| Array (VBA) | Count (DAO) |
| Asc (VBA) | Atn (VBA) |
| Avg (DAO) | CBool (VBA) |
| CreateObject (VBA) | CByte (VBA) |
| CCur (VBA) | CDate (VBA) |
| CSng (VBA) | CDbl (VBA) |
| CStr (VBA) | CDec (VBA) |
| CurDir (VBA) | Choose (VBA) |
| Chr (VBA) | CInt (VBA) |
| CVar (VBA) | CLng (VBA) |
| CVDate (VBA) | CVErr (VBA) |
| Command* |
D–H
| Date (VBA) | DVar |
| DateAdd (VBA) | DVarP |
| DateDiff (VBA) | Environ* (VBA) |
| DatePart (VBA) | EOF (VBA) |
| DateSerial (VBA) | Error (VBA) |
| DateValue (VBA) | EuroConvert |
| DAvg | Eval |
| Day (VBA) | Exp (VBA) |
| Dcount | FileAttr (VBA) |
| DDB (VBA) | FileDateTime* (VBA) |
| DDE | FileLen* (VBA) |
| DDEInitiate | First (DAO) |
| DDERequest | Fix (VBA) |
| DDESend | Format (VBA) |
| DFirst | FreeFile (VBA) |
| Dir* (VBA) | FV (VBA) |
| DLast | GetAllSettings (VBA) |
| DLookup | GetAttr* (VBA) |
| DMax | GetObject (VBA) |
| DMin | GetSetting* (VBA) |
| DoEvents (VBA) | GUIDFromString |
| DStDev | Hex (VBA) |
| DStDevP | Hour (VBA) |
| DSum | HyperlinkPart |
I–R
| IIf (VBA) | Log (VBA) |
| IMEStatus (VBA) | LTrim (VBA) |
| Input* (VBA) | Max (DAO) |
| InputBox (VBA) | Mid (VBA) |
| InStr (VBA) | Min (DAO) |
| Int (VBA) | Minute (VBA) |
| IPmt (VBA) | MIRR (VBA) |
| IRR (VBA) | Month (VBA) |
| IsArray (VBA) | MsgBox (VBA) |
| IsDate (VBA) | Now (VBA) |
| IsEmpty (VBA) | NPer (VBA) |
| IsError (VBA) | NPV (VBA) |
| IsMissing (VBA) | Nz |
| IsNull (VBA) | Oct (VBA) |
| IsNumeric (VBA) | Partition (VBA) |
| IsObject (VBA) | Pmt (VBA) |
| Last (DAO) | PPmt (VBA) |
| LBound (VBA) | PV (VBA) |
| LCase (VBA) | QBColor (VBA) |
| Left (VBA) | Rate (VBA) |
| Len (VBA) | RGB (VBA) |
| Right (VBA) | Loc (VBA) |
| Rnd (VBA) | LOF (VBA) |
| RTrim (VBA) |
S–Z
| Second (VBA) | SYD (VBA) |
| Seek (VBA) | Tab (VBA) |
| Sgn (VBA) | Tan (VBA) |
| Shell* (VBA) | Time (VBA) |
| Sin (VBA) | Timer (VBA) |
| SLN (VBA) | TimeSerial (VBA) |
| Space (VBA) | TimeValue (VBA) |
| Spc (VBA) | Trim (VBA) |
| Sqr (VBA) | TypeName (VBA) |
| StDev (DAO) | UBound (VBA) |
| StDevP (DAO) | UCase (VBA) |
| Str (VBA) | Val (VBA) |
| StrComp (VBA) | Var (DAO) |
| StrConv (VBA) | VarP (DAO) |
| String (VBA) | VarType (VBA) |
| StringFromGUID | Weekday (VBA) |
| Sum (DAO) | Year (VBA) |
| Switch (VBA) |