microsoft access 2013 tutorial level 1 part 03 of 12

These can often beĪ problem with many date calculations.

Which ones are current, 30 days late, 60 days late, or more.Īddress date values that have times with them. Receivable where we can see all of our past due, unpaid orders, and Math and the IIF() Function to create an Aged Accounts Records in a specific list of dates, using the IN() functionĭate/Time Mathematics and the specifics of how to add, subtract, andĭeal with date and time values. We'llĭiscuss the '2030' two-digit year problem and how to fix it. We'll learn more about the Format() function's parameters. We'll see how to use these functions to create default values Learning more about the Date(), Time(), and Now()įunctions. We willīegin by learning some keyboard shortcut tricks to add automatic datesĪnd times to our database during data entry. Part 1 of 2 classes covering Date/Time functions. In a lot more detail, plus learn many new functions. This Comprehensive Guide to Access Functions we will cover those We have covered some of these functions in previous classes, however in Levels of the Expert series where I start to cover functions. Have at least completed the Beginner series and the first 3 or 4 However, if you're skipping around, you should

Access has not changed that much over the years.Ģ6 recommended, as you should watch all of myĬlasses in order. The material is valid for Access 2007 up to 2021.

Microsoft access 2013 tutorial level 1 part 03 of 12