Microsoft Access VBA Introduction for the Complete VBA Newb
4.6 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
692 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access VBA Introduction for the Complete VBA Newb to your Wishlist.

Add to Wishlist

Microsoft Access VBA Introduction for the Complete VBA Newb

Learn Access VBA to Automate Access by Building a Solid Foundation with Access VBA
4.6 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
692 students enrolled
Created by Kyle Pew
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $60 Discount: 83% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 8 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • A copy of Microsoft Acces, installed, will be needed in order to follow along and practice the Access VBA concepts.
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.

Who is the target audience?
  • This course is intended for those that are familar with working with Microsoft Access, working with Access Table, Forms, Queries and Reports.
  • Access users that are looking to automate some of their workflow within Access with VBA
  • No prior programming experience neccessary.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
03:17:05
+
Getting Started with Microsoft Access VBA
4 Lectures 11:32
+
Working with Access VBA SUB Procedures and Functions
7 Lectures 30:01
Access VBA SUB Procedures and Functions - Section 2 Exercise File Download
00:21


Creating Access VBA SUB Procedures
06:08

Calling an Access VBA SUB Procedure
03:29

Using the Immediate Window
04:41

Creating Access VBA Custom Functions
07:22

Using an Access VBA Function
04:09

Access VBA Procedures and Functions - Quiz #2
5 questions
+
Understanding and Working with Access Objects with VBA
7 Lectures 44:45
Access VBA Objects - Section 3 Exercise File Download
00:20


Properties, Methods and Events of Access Objects
06:08

Communicating with Access Objects with VBA
11:53

Working with Object Collections
08:10

Using the VBA "With" Statement
05:34

Controlling Access Objects with the "DoCmd" Statement
07:40

Access VBA - Working with Access VBA Objects Quiz
5 questions
+
Foundational VBA Programming Concepts
7 Lectures 41:51
Access VBA Programming Concepts - Section 4 Exercise File Download
00:19


Declaring a Variables Data Type
04:31

Understanding the Scope of a VBA Variable
07:22

Creating Logic within VBA Code Using an IF Statement
06:34

Using a VBA Select Case Statement to Branch within Code
06:24

Repeating Blocks of VBA Code with Loops
09:47

Access VBA - Programming Concepts Quiz
4 questions
+
Working with the Access Recordset Object
3 Lectures 16:26
Access VBA Recordset Object - Section 5 Exercise File Download
00:20

Creating Object Variables
06:29

Iterating through an Access Recordset
09:37

Access VBA - Access VBA Recordset Object Quiz
3 questions
+
Debugging Access VBA Code
5 Lectures 25:06
Access VBA Debugging Tools - Section 6 Exercise File Download
00:19


Setting Breakpoints with a Procedure
04:32

Adding Error Handling to an Access VBA Procedure
06:30

Using the Access VBA "Err" Object
06:22

Access VBA - Access VBA Debugging Tools Quiz
3 questions
+
Access VBA - Project #1 Working with Access VBA SUB Procedures
8 Lectures 25:51

Project #1 - Exercise File Download
00:19

Project #1 - Setting up the Form
04:53

Project #1 - Where to Write Your Code
05:11

Project #1 - Creating a SUB Procedure to Open a Form
03:23

Project #1 - Working with the OnClick Event of a Command Button
04:47

Project #1 - Making Reuasable SUB Procedures
04:57

Project #1 - Quick Recap
01:12
+
Congratulations and Bonus
2 Lectures 01:38
Congratulations! You've Completed the Course
00:30

BONUS - Get Any of my Other Courses at a Discount
01:08
About the Instructor
Kyle Pew
4.6 Average rating
12,237 Reviews
63,743 Students
16 Courses
Microsoft Certified Trainer - 60,000+ Udemy Students

Qualifications:

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...


What Students have said about Kyle:

      • "Kyle was off the chart "GOOD""

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

      • "Kyle Pew is very knowledgeable and presented information with exceptional skill."


In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!