MS access commands and functions list

MS access commands and functions list

Microsoft Access commands and functions

.AddMenu Add a custom menu bar/shortcut bar.
.ApplyFilter Apply a filter clause to a table, form, or report.
Asc The Ascii code of a character.
Avg (SQL) Average.
b
.BrowseTo(DoCmd) Navigate between objects.
c
Call Call a procedure.
.CancelUpdate Cancel recordset changes.
CBool Convert to boolean.
CCur Convert to currency (number)
CVDate Convert to Date.
CDec Convert to Decimal (number)
ChDir Change the current directory or folder.
Chr Return a character based on an ASCII code.
.Close (DoCmd) Close a form/report/window.
CInt Convert to Integer (number)
Command Return command line option string.
.CopyObject (DoCmd) Copy an Access database object.
Cos Display Cosine of an angle.
CSng Convert to Single (number.)
CurDir Return the current path.
CurrentUser Return the current user.
Date The current date.
DateDiff The time difference between two dates.
DateSerial Return a date given a year, month, and day.
DAvg Average from a set of records.
DCount Count the number of records in a table/query.
.DeleteObject (DoCmd) Delete an object.
DoMenuItem (DoCmd) Display a menu or toolbar command.
Dir List the files in a folder.
DLookup Get the value of a particular field.
DMin Return the minimum value from a set of records.
DSum Return the sum of values from a set of records.
DVar Estimate variance for domain (subset of records)
DVarP Estimate variance for population (subset of records)
e
Environ Return the value of an OS environment variable.
EOF End of file input.
Error Return the error message for an error No.
Execute(SQL/VBA) Execute a procedure or run SQL.
FileDateTime Filename last modified date/time.
.FindFirst/Last/Next/Previous Record.
First (SQL) Return the first value from a query.
For Loop.
From Specify the table(s) to be used in an SQL query.
FV Future Value of an annuity.
g
GetAttr Get file/folder attributes.
GetObject Return a reference to an ActiveX object
.GoToRecord (DoCmd)Move to a specific record in a dataset.
h
Hour Return the hour of the day.
If Then Else If-Then-Else
InputBox Prompt for user input.
InStr Return the position of one string within another.
Int Return the integer portion of a number.
IPmt Interest payment for an annuity
IsDate Test if an expression is a date.
IsError Test if an expression is returning an error.
IsNull Test for a NULL expression.
IsObject Test if an expression is an Object.
L
LCase Convert a string to lower-case.
Len Return the length of a string.
LoadPicture Load a picture into an ActiveX control.
Loc The current position within an open file.
Log Return the natural logarithm of a number.
Max (SQL) Return the maximum value from a query.
Mid Extract a substring from a string.
.Minimize (DoCmd) Minimise a window.
MkDir Create directory.
MonthName Return a string representing the month.
.MoveFirst/Last/Next/Previous Record
MsgBox Display a message in a dialogue box.
n
Now Return the current date and time.
Oct Convert an integer to Octal.
.OpenForm (DoCmd) Open a form.
.OpenRecordset Create a new Recordset.
.OutputTo (DoCmd) Export to a Text/CSV/Spreadsheet file.
p
Quit Quit Microsoft Access
r
.Rename (DoCmd) Rename an object.
.RepaintObject (DoCmd) Complete any pending screen updates.
.Requery Requery the data in a form or a control.
RGB Convert an RGB color to a number.
Rnd Generate a random number.
RTrim Remove trailing spaces from a string.
.RunMacro (DoCmd) Run a macro.
.RunSavedImportExport (DoCmd) Run a saved import or export specification.
.Save (DoCmd) Save a database object.
.SearchForRecord(DoCmd) Search for a specific record.
Select (SQL) Retrieve data from one or more tables or queries.
Select-Subquery (SQL) SubQuery.
.SelectObject (DoCmd) Select a specific database object.
SendKeys Send keystrokes to the active window.
.SetFilter (DoCmd) Apply a filter to the records being displayed.
.SetOrderBy (DoCmd) Apply a sort to the active datasheet, form or report.
.SetWarnings (DoCmd) Turn system messages on or off.
.ShowAllRecords(DoCmd) Remove any applied filter.
Shell Run an executable program.
Sin Display Sine of an angle.
SLN Straight Line Depreciation.
Sqr Return the square root of a number.
StDev (SQL) Estimate the standard deviation for a population.
StrComp Compare two strings.
Sum (SQL) Add up the values in a query result set.
Time Return the current system time.
Timer Return a number (single) of seconds since midnight.
TimeValue Convert a string to a Time.
.TransferSharePointList(DoCmd) Import or link data from a SharePoint Foundation site.
.TransferSQLDatabase (DoCmd) Copy an entire SQL Server database.
Transform (SQL) Create a crosstab query.
UCase Convert a string to upper-case.
Union (SQL) Combine the results of two SQL queries.
.Update Save a recordset.
v
Weekday Return the weekday (1-7) from a date.
Year Return the year for a given date.