Microsoft Access VBA Introduction for the Complete VBA Newb

Name: Microsoft Access VBA Introduction for the Complete VBA Newb
Rating: 4.6 (314 reviews)

Learn Access VBA to Automate Access by Building a Solid Foundation with Access VBA

Created byKyle Pew • 2,000,000+ Students

Last updated 11/2016

English

What you'll 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 content

8 sections • 42 lectures • 3h 16m total length

Quick Introduction1:52
Access VBA Intro - Section 1 Exercise File Download0:19
Introduction to the Access VBE (Visual Basic Editor) Window3:46
Getting Help with Access VBA5:35
Learn to access built-in and online help in Access VBA using the Help menu, the VBA reference, and contextual F1 tips. Explore the object model to strengthen your foundation.
Getting Started with Access VBA - Quiz #1

Access VBA Objects - Section 3 Exercise File Download0:20
Understanding Access Objects5:00
Explore how Microsoft Access uses objects and how to talk to them with VBA. Identify tables, queries, forms, reports, macros, and modules as objects with defining characteristics.
Properties, Methods and Events of Access Objects6:08
Communicating with Access Objects with VBA11:53
Working with Object Collections8:10
Using the VBA "With" Statement5:34
Controlling Access Objects with the "DoCmd" Statement7:40
Master referencing access objects with dot notation and the do command to open forms, navigate controls, and invoke methods and events in VBA.
Access VBA - Working with Access VBA Objects Quiz

Access VBA Programming Concepts - Section 4 Exercise File Download0:19
Storing and Referencing Data with VBA Variables6:54
Declaring a Variables Data Type4:31
Understanding the Scope of a VBA Variable7:22
Explore VBA variable scope and lifetime, and extend access by declaring a public global variable outside a procedure to share user input across procedures.
Creating Logic within VBA Code Using an IF Statement6:34
Using a VBA Select Case Statement to Branch within Code6:24
Repeating Blocks of VBA Code with Loops9:47
Learn how to repeat code blocks in VBA using do loops, while loops, and for next loops. The tutorial demonstrates iterating through open forms in Access.
Access VBA - Programming Concepts Quiz

Access VBA Debugging Tools - Section 6 Exercise File Download0:19
Stepping Through Code a Line at a Time7:23
Setting Breakpoints with a Procedure4:32
Adding Error Handling to an Access VBA Procedure6:30
Using the Access VBA "Err" Object6:22
Improve error handling in Access VBA by using the error object to deliver specific messages, using on error goto and select case for divide by zero and data type mismatch.
Access VBA - Access VBA Debugging Tools Quiz

Project #1 - Introduction and Preview1:09
Project #1 - Exercise File Download0:19
Project #1 - Setting up the Form4:53
Project #1 - Where to Write Your Code5:11
Learn where to store your VBA in Access, choosing between a universal module and object-specific code on forms, with private scope and practical setup for a navigation board.
Project #1 - Creating a SUB Procedure to Open a Form3:23
Project #1 - Working with the OnClick Event of a Command Button4:47
Project #1 - Making Reuasable SUB Procedures4:57
Project #1 - Quick Recap1:12

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 this course is for:

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.

Microsoft Access VBA Introduction for the Complete VBA Newb

What you'll learn

Explore related topics

Course content

Getting Started with Microsoft Access VBA4 lectures • 12min

Working with Access VBA SUB Procedures and Functions7 lectures • 30min

Understanding and Working with Access Objects with VBA7 lectures • 45min

Foundational VBA Programming Concepts7 lectures • 42min

Working with the Access Recordset Object3 lectures • 16min

Debugging Access VBA Code5 lectures • 25min

Access VBA - Project #1 Working with Access VBA SUB Procedures8 lectures • 26min

Congratulations and Bonus1 lecture • 1min

Requirements

Description

Who this course is for: