MS Access Functions - Complete Tutorial

Here is a list of the most commonly used functions in Access. This is alphabetical listing of pointers to those articles which explain these functions in more detail.

Asc        Abs        Atn      Avg     Choose    Chr Cos  Count     CurDir             Date    DateAdd         DateDiff  DatePart          DateSerial       DateValue       Day         Exp      FileDateTime First     Fix       Format Hour    IIf        Int       IsDate             IsNull IsNumeric       Last             LCase Left     Len      Log      LTrim Max     Mid     Min      Minute             Month             MonthName             Now    Replace           Right   Rnd     Round             RTrim Second            Sgn      Sin       Space   Sqr       Str             StrConv           Sum     Switch             Tan      Time    TimeSerial       TimeValue       Trim     UCase    Val   Weekday    WeekdayName           Year        more...