Access VBA: The Beginner’s Blueprint to Programming Access

Access VBA: The Beginner’s Blueprint to Programming Access

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 4.5 Hours | 1.11 GB

To Learn Visual Basic for Applications & Do More with Your Databases, Program Them with the Tools Found in This Course!

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 you’ll learn

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