Welcome to Access Developer 32. Total running time is 1 hour, 23 minutes plus 98 minutes of FREE bonus material.

Lessons

•  00. Intro (6:27)
•  01. Export Report as HTML 1 (11:17) - Bonus
•  02. Export Report as HTML 2 (14:43) - Bonus
•  03. FTP File to Web Server (16:11)
•  04. Convert Currency Part 1 (15:14) - Bonus
•  05. Convert Currency Part 2 (16:59) - Bonus
•  06. Auto Update Rates from Web API (23:15)
•  07. Groups 1 (14:48) - Bonus
•  08. Groups 2 (25:06) - Bonus
•  09. Group Search (35:22)
•  10. What's Next (1:48)

Update

• Yes, I'm aware that my API key is visible in lesson 6. I've since deleted that one and gotten a new one. Thanks to everyone who emailed me.
• I have added a lot of additional functionality to the FindBetween function including the ability to not specify a start or end string, and optionally specifying two end strings. This will allow you to do things like get all of the text from a certain point to the end of the string, or have an string that may end with one or two different characters (like a JSON list). The updated code is in the Code Vault, which is available to Gold Members. 

Database Files

•  Databases For Lessons 1-3
•  Databases For Lessons 4-6
•  Databases For Lessons 7-8

Links

• Original Export HTML TechHelp Video
• UTC Daylight Saving Time Video
• Fixer.IO Web API for Currency Conversion Data

Resources

• Full Course Description Page
• Topic Outline
•  Handbook PDF - AI Generated
•  Video ZIP File  (549 MB)
• Skills Test Quiz - Under Construction
• Certificate of Completion
• Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.