Are you struggling with getting your VBA code to work again and again?
Have you been assigned a VBA project at work and your VBA skills are not up to the task?
Are you in despair because your VBA code stopped to work after a "minor" change and you have no clue why?
If you answered any of these questions with yes, this course is for you!
In this course Philipp Stiefel teaches a deep, fundamental understanding of programming in the VBA programming language from the ground up.
After taking this course, you will be able to …
- Understand programming in VBA from the ground up.
- Reduce the time you need to implement a solution.
- Avoid common pitfalls.
- Quickly find, analyze, and fix problems in existing VBA code.
- Write code that can be easily maintained and enhanced in the future.
The core teaching medium of this course is high resolution video of practical coding in the VBA development environment, supported by presentations about the base theory of each topic. The course also includes supplemental course materials, such as homework assignments, homework reviews, downloadable cheat sheets, and quizzes.
The course is suitable for beginners in programming and VBA. Students with intermediate knowledge of VBA will also highly benefit from this course. – A basic knowledge of Microsoft Access and SQL is helpful but not strictly required.
This course is taught in Microsoft Access, but it is not a Microsoft Access course. The focus is firmly on VBA and the core content of every lecture in this course is all the same valid in other VBA enabled application such as Microsoft Excel or Microsoft Word. Access related topics are only covered to the extend they are relevant for the example application built in the course.
This is an opinionated course. Philipp draws from his long experience as a VBA application developer to cut through the noise and focus on the important aspects of VBA you will need in day-to-day programming. He also includes his philosophy of writing maintainable code right from the start.
Course content in numbers
- ~16 hours of video (includes ~2.5 hours optional/bonus material)
- 3 PDF “cheat sheets” summarizing important info on 1-2 pages.
- 7 Homework assignments, with a pre-recorded homework review, and sample solutions.
- 7 Quizzes
- 7 downloadable PDF files with all presentation slides
Not Included in the Course
To prevent misunderstandings, I like to clarify: The following major topics are *NOT* covered in this course.
- The design of databases tables and relationships
- The design of queries or the syntax of SQL
- The design of Access forms and reports
- Object Oriented Programming with custom class modules
Philipp is working professionally with Microsoft Access and Visual Basic for Applications since 1998 for corporate clients. He has established himself as an authority in the field by publishing articles on his website at codekabinett.com and videos on his codekabinett YouTube channel . He is a public speaker on topics related to Access and VBA and was invited to speak at the AEK, Access DevCon, and NADD conferences and at many international online Access user groups. He was also awarded the Microsoft MVP title for his community engagement from 2000 to 2006.
Frequently Asked Questions
30 Day Money-Back Guarantee!
Buying the course is risk-free for you. If you are not happy with the course within 30 days after purchase, we will refund the full price.
Early Bird Bonus – Consultation Webinars
Here is a bonus for early bird students. Between 15 March and 15 April 2022, I will offer 4 one-hour live group consultations open to all registered students. In these consultations I will be available to answer questions related to the course content.
There will be one session per week on different weekdays and at different times to allow students from different time-zones and backgrounds a variety of options to participate. These group consultations will be Microsoft Teams webinars. The times of these consultations and the registration links are inside the course curriculum.
If you have any further questions, you may ask them via email to [email protected].