Access Expert 27 is Part 3 of our Comprehensive Guide to Access Functions. Today's class is part 1 of our focus on Date/Time Functions. You will learn some additional tricks with the Date, Time, Now, and Format functions. We will build an Aged Accounts Receivable, and we will learn more about date/time math operations. Topics include:
- Date/Time Functions Part 1 of 2
- More with Now, Date, Time Functions
- Query Data in a Variety of Date Ranges
- Date & Time Mathematics
- Two Digit Year "2030" Problem
- List of Upcoming Birthdays
- Aged Accounts Receivable Report
- Display Times as 8:30, 8.5, 8h 30m
- Timesheets Spanning Midnight
- Calculating Someone's Approximate Age
Click here for more information on Access Expert Level 27, 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 26. The next class in the series is Access Expert 28.
11 years ago
