Access VBA: The Beginner's Blueprint to Programming Access

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

In This Course You Get:

  • Free Downloadable Databases - makes it easy to follow along & practice after class.

  • "Test Your Skills" - exercises to get you engaged & reinforce what you have learned.

  • Code - in the Resources section of the lectures where applicable.

  • Access VBA Glossary - talk the talk



Choose Access VBA when...

Simple tables, forms, or reports just won't do. ..
When Macros aren't quite enough. ..
And when creating your own applications from scratch is overkill.


Are you experienced with Access, but not with VBA programming?

This course introduces VBA programming concepts with easy to follow examples, and lessons.

-----------------------------------------------------------------------------------

First, you will learn the difference between Macros and VBA, and create a simple Macro.

Then you will get familiar with the Visual Basic Editor, your home for programming Access, and basic concepts of Visual Basic for Applications.

During this course you will learn VBA concepts that you can apply to your job, and add functionality to your Access databases:

  • Get comfortable with the Visual Basic Editor (VBE)

  • Learn the essentials of writing VBA code

  • Learn about the powerful DoCmd object

  • Create branching decision structures

  • Create user interactions forms, like message boxes, and input boxes

  • DAO recordsets

  • Debug your code, and handle errors

-----------------------------------------------------------------------------------

What to know before you enroll:

You will have unlimited, lifetime access to the course!

You will have instant, and free access to any updates I add to the course.

Don't forget, you are covered by a 30 day money back guarantee.

-----------------------------------------------------------------------------------

Get started programming VBA for your Access databases today.

Expected Outcomes

  1. UNDERSTAND why you would want to use VBA in Access Databases
  2. KNOW the differences between Macros and VBA
  3. CREATE a simple Macro in Access
  4. NAVIGATE comfortably in the Visual Basic Editor
  5. LEARN the essentials of writing Access VBA code
  6. PROGRAM command buttons
  7. CREATE decision structures
  8. CREATE user interaction dialog boxes, like message boxes and input boxes
  9. DEBUG your VBA code
  10. LEARN how to handle errors
  11. USE built in String, Date, and Format functions