Microsoft Access Expert Level 25 is 1 hour, 33 minutes long. This is the first class in my Comprehensive Guide to Access Functions series. You will learn a bunch of NEW functions, and new tricks with some of the functions we've covered before. You will learn how to separate first, last, and middle names from a full name field, calculate overtime pay, and lots more. Topics include:
- String Functions
- Left, Right, Mid, InStr, InStrRev, Len
- LCase, UCase, Trim, RTrim, LTrim
- Replace, Str, CStr, StrComp, ASC, CHR
- Space, String
- Logical Functions
- IsDate, IsNull, IsNumeric, IsError
- NZ, VarType, TypeName
- And, Or, Not, Xor, IIF, Nested IIF
- Switch, Choose
Click here for more information on Access Expert Level 25, including a course outline, sample videos, and more. This course was recorded using Access 2013, but most of the functions covered are valid for all versions of Access. This class follows Expert Level 24. The next class in the series is Access Expert 26.