Microsoft Access VBA Introduction for the Complete VBA Newb (Udemy.com)
Learn Access VBA to Automate Access by Building a Solid Foundation with Access VBA
Created by: Kyle Pew
Last updated November 2016
What you will learn
- Automate routine Microsoft Access process with Access VBA
- Develop intuitive, accessible Access Applications
- Writing VBA Code from Scratch
- Build a Solid Foundation with Access VBA
Course Description
Working with Access and VBA
Microsoft Access has a lot of moving parts. Tables to store your data, Queries to retrieve data, Forms to work with data and Reports to report on your data. Each of these Access Objects are important all by themselves, but, the real power of Microsoft Access comes when you bring all these objects together.
Automate with Access VBA
Join me in this course on Microsoft Access VBA and learn how to create an intuitive, accessible Access application by automating yours and your users experience working with data in Access.
Access VBA, or Visual Basic for Applications, will provide the means to streamline your efforts in working with Access. Through VBA you will learn to automate routine Access tasks as well as tasks that would normally take a large portion of your day to complete.
Course Structure
I have structures this course for those that are brand new to developing within VBA. Starting with the basics of working within the VBE (Visual Basic Editor) Window, your coding development environment, all the way through more advanced topics such as working with VBA variables and creating loops to repeat tasks, blocks of code.
Enroll Now
Enroll now and participate in the course by taking advantage of not only the step by step video demonstrations, test your understanding with section quizzes, but also download the exercise file that I will be using throughout the videos and follow along.
Allow me to be your guide on the amazing journey of learning to program with the Microsoft Access with VBA.
Instructor Details
- 4.6 Rating
317 Reviews
Kyle Pew
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 2 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into advanced topics like VBA and SharePoint.
With a background in media arts and animation from the San Francisco Art Institute and industry experience as a game designer at Electronic Arts, I bring a unique perspective to my training. My clients have included major corporations like Chevron, Facebook, Walmart, and many more, delivering training to both large-scale audiences and individuals, adapting each lesson to address real-world applications. My courses are built around the principle that the best way to learn is by tackling real-life challenges—allowing you to build confidence and problem-solving skills.
Join me on Udemy and let’s take your skills to the next level. When I’m not teaching, I’m enjoying time with my six children or cheering on my favorite hockey team, the San Jose Sharks.
More courses by Kyle Pew
Microsoft Excel - Excel from Beginner to Advanced 2026
4.7 (543,696 Reviews)
Provider: Udemy
Time: 22.3h
$139.99
Master Microsoft Excel Macros and Excel VBA (2025)
4.6 (33,954 Reviews)
Provider: Udemy
Time: 5.4h
$15.99
Master Microsoft Word Beginner to Advanced (2019)
4.7 (32,671 Reviews)
Provider: Udemy
Time: 7h
$18.99
Microsoft PowerPoint From Beginner to Advanced (2019)
4.6 (24,824 Reviews)
Provider: Udemy
Time: 6.8h
$14.99
Microsoft Excel Data Analysis and Dashboard Reporting (2018)
4.6 (13,525 Reviews)
Provider: Udemy
Time: 3.6h
$15.99
More Office Productivity courses
AI-Powered Social Media Management: From Beginner to Pro (2025)
5.0 (211 Reviews)
Provider: Udemy
Time: 1.1h
$19.99
SUPERHUMAN 10X Productivity with AI: 75 Time Management Tips (2026)
4.9 (4,994 Reviews)
Provider: Udemy
Time: 13.7h
$94.99
Microsoft Word 2019 (MO 100) Study Guide to 1000 points
4.9 (451 Reviews)
Provider: Udemy
Time: 2.1h
$79.99
Microsoft Excel + AI: Go From Data Analysis to Visualization (2026)
4.9 (276 Reviews)
Provider: Udemy
Time: 3.8h
$10.99
Workshop 5: Access VBA, Design and Advanced Methods (2024)
4.9 (182 Reviews)
Provider: Udemy
Time: 2.2h
$64.99
Reviews
By Dave Goodmanson on 12/27/2023
I've forgotten the name of the presenter, he was great! This course has helped me dust off my Access knowledge from years ago, but better. I have new insights into how Access VBA Programming hangs together. Really first rate! This has been a significant step forward in my journey back to using and developing Access databases. Thank you and thanks to the instructor.
By Lucky Salomi on 12/25/2020
I gave the tutor a 5-star rating in his course: Microsoft Access - Beginner to Advanced, but while this course contents were good, they offer few snippets on manipulating the database through VBA codes. Simply, the course is not loaded enough to deserve a 5-star rating. The take-aways for me were just: Error Handling, Recordset and Re-usable codes. More practical examples on events coding are required in the future.
By Christopher McKinnon on 5/3/2020
This seems like it was lifted whole from the full Access course. The info was good but except for the Button VBA, most of what he showed did not seem to have a practice use for creating functionality for most users in VBA. I liked what I learned, but I would have liked to see how it could be applied in a more practical manner. I have some ideas for that but they stem from other experiences I have had as opposed to information the course offered.
By Jim Christianson on 2/18/2020
So far the course is excellent plus ! The instructor is exceptionally captivating. His tone is great and he is very thorough. I'm enjoying this a lot to this point. Have taken several Udemy courses but Kyle is definitely, in my opinion, the best instructor so far. The material covered in this course requires many reviews and going over several times. Kyle's instructing methods and techniques are very engaging. I've finished the course and have to remark that Kyle is a natural born instructor. He's very focused and teaches with enthusiasm. I've enjoyed this course so much that I'm going to repeat it.
By Glynda Finister on 1/13/2019
I had read 2 books and was confused. I got a job and needed to learn Access VBA fast and this course was brilliant and excellent for newbies like me. The Instructor had a great speaking voice and I was not bored at any point in time. I loved they way he explained things. I'm not one who picks up on things quickly, but I did here. I absolutely loved this course and plan on taking more of his courses.
By Terese King on 3/12/2018
Just as the course is described, this is a bare bones basic introduction to VBA and programming in general. If a student has a past basic history of any type of programming, this course will be a simple review of those basic concepts with Access used as the base. Based on the idea of basic concepts, as the NEWB indicates :), the content was easy to understand and the course, while maybe a touch slow, did a good job with the explanation and examples. As Kyle indicates, repetitive practice is key.
By John Davy on 1/29/2018
Wonderful! I love it. The instructor is great and very knowledgeable of Access. He is having fun with Access and so am I. It gets better all the time. He is an excellent instructor. Love it and I want more on VBA. Congratulations on a great, great course! Question: In the SImpleMath function - I have an option box for the user to choose the Operation such as + - * / . I want to pass the sign + - * / depending on the Option the user chooses. How do I do that? Love the Course! John
By David Hansen on 12/1/2017
The instructor was fun. This is a vary basic course if you have VBA experience in other application you will be speeding up your video often. It did give me a insight into how Access VBA differs from excel VBA. This course will give you a grounding to understand other courses and the basics of VBA programing. It will help you read and understand web searches you might have on Access VBA searches. It will give you background when you study more books and videos. you will not be a Access developer when you are done but it will give you a foundation to study. It teaches principles like objects passing parameters referencing forms
By Scott A on 5/20/2017
Excellent staring point for learning VBA for Access. Definitely learned a thing or two that I didn't know previously. This is kind of a review for me - just getting back into it. The only criticism I have is that Kyle assumes that you know some of the vernacular that a NewB might not know. Better definitions and explanation of the meaning of those words up front would have made this a 5.0 star. All in all - A great course to get you started and well worth your time if you follow along with the examples.
By Robert C on 11/5/2016
I have now covered 50% of the material in this course. This course has great content and the instructor, Kyle Pew, presents the information in a clear and concise way. VBA has been an enigma to me and I am really enjoying this course. The course is organized well and it is easy to go back to review. It is also easy to increase the speed of the presentation. The material is presented in a manner that keeps your interest. The instructor's voice is engaging; not flat and boring like many online presentations. I am extremely pleased with this course. The instructor has made himself available to answer questions. Taking this course was a great decision! Thank you Kyle.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












