Well, after being out of town, and then being sick for a few weeks, September has pretty much just flown by. Needless to say, I'm WAY behind on my production schedule. The good news is that Access Expert 25 is finished and recorded. I just need to get the videos uploaded to the server and set it all up, which I will do tomorrow morning.
Expert 25 is Part 1 of my comprehensive Access Function Guide. There are a ton of functions in Access that I haven't covered yet, and I figured now is probably the best time to do so. There were even some functions in there that were added in Access 2007, 2010, and 2013 that I didn't even know existed, like the Switch function (thanks to David S. for bringing that one to my attention).
Anyhow, here's a sneak peek at what this course covers. It should be online (with a full outline) tomorrow:
00. Intro (5:44)
01. String Functions 1 (26:27)
Function Categories
Left()
Right()
Mid()
Separate Phone Number Parts
Area Code, Prefix, Suffix
InStr()
InStrRev()
Len()
Separate First and Last Names
Get Last Name even if Middle Name
UCase()
LCase()
StrConv()
Convert to Upper Case
Convert to Lower Case
Convert to Proper Case
Trim()
LTrim()
RTrim()
Remove Extra Spaces from String
Replace()
Replace One String with Another
String Concatenation &
02. String Functions 2 (14:51)
Str()
CStr()
Convert Number to String
StrComp()
String Comparison
Greater, Less, Equal, NULL
ASC()
CHR()
ASCII Code Table
Non-Standard Characters
Space()
Monospace Fonts
Kerning, Kerned Fonts
String()
Repeat a String X Times
03. Logical Functions 1 (14:23)
IsDate()
IsNull()
IsNumeric()
IsError()
NZ()
Replace NULL Value
VarType()
TypeName()
Determining Data Types
Data Type Names
AND, OR, NOT, XOR
Logical Operators
04. Logical Functions 2(26:33)
IIF()
Nested IIF()
Student Grades Pass/Fail
Student Letter Grades
Switch()
Choose()
Shipping Methods
Calculating Employee Overtime Pay
Separating First, Middle, Last Names
05. Review (5:44)
12 years ago
