Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Microsoft Access Expert 28
By Richard Rost     7 years ago

Access Expert 28 is Part 4 of our Comprehensive Guide to Access Functions. Today's class is part 2 of our focus on Date/Time Functions. You will learn about many new functions including WeekDay, DateAdd, DateDiff, DateSerial, DatePart, and more. Topics include:

- Date/Time Functions Part 2
- Break Apart Dates with Day, Month, Year
- Calculate Day of the Week with WeekDay
- DateAdd - What's 2 months from today?
- DateDiff - How long until loan paid?
- DatePart - Is order from last quarter?
- DateSerial - Find last day of next month
- Display Ordinals: 1st, 2nd, 3rd, etc.
- Calculate someone's exact age
- List of birthdays for next month

Click here for more information on Access Expert Level 28, 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 27. The next class in the series is Expert Level 29.

Comments for Microsoft Access Expert 28

 Age Subject From 9 months CodeSampleF Robert Taplin 2 years DateTime Concatenation Austin Ritner 6 years Microsoft Access Expert 28 Bola 6 years Thanks vicki Hudson 7 years Code Samples Clarice Barkhordarian 7 years Microsoft Access Expert 28 khadija

Start a NEW Conversation
 Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

 You may want to read these articles from the 599CD News:
 5/16/2022 Referential Integrity 5/15/2022 Invoicing Member Discussion 5/13/2022 Multivalued 5/12/2022 Number Field Size 5/11/2022 Create Word Document 5/11/2022 Export to Word 5/10/2022 On Click Event Timing 5/9/2022 Invalid Use of Null 5/7/2022 Event Handler 5/6/2022 Database Title & Icon

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Login My Account My Courses Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey