Access VBA: The Beginner's Blueprint to Programming Access

Don't Just Use Your Microsoft Access Databases... Program Them!
4.5 (35 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.
1,271 students enrolled
$19
$175
89% off
Take This Course
  • Lectures 140
  • Length 5.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

*UPDATED: Nov. 8, 2016*


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.

What are the requirements?

  • Access 2007, 2010, 2013, 2016
  • To get the most out of this course, you should have working knowledge of Microsoft Access databases

What am I going to get from this course?

  • 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

What is the target audience?

  • The Beginning Access VBA Programmer
  • Programmers of other languages that would like a good tutorial
  • Anyone who is responsible for working with Access databases
  • Anyone wanting to know more about Access VBA

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

01:48

Welcome to Access VBA: Beginner's Blueprint to Programming Access VBA.

IsaBel Harrison | Udemy.com

Section 1: Creating Macros in Microsoft Access
02:14

When programming your Access databases, you have a choice of Macros, or VBA.
Which should you choose?
Learn the difference with this lecture.

06:41

Learn how to create a simple macro in your Access database.

03:58

Learn how to take your macro and turn it into VBA code.

Section 2: Getting Familiar with the VBE (Visual Basic Editor)
01:13

There are multiple ways to access the Visual Basic Editor.

Take a few seconds to learn them now.

06:31

Get familiar with the different windows that you will be using when programming your Excel VBA code.

1 page

You will see Option Compare Database, and Option Explicit a lot throughout this course, but what do they mean?

01:22

You will need to create your own code modules, and it is as easy as a couple of mouse clicks. Learn how to here.

2 pages

Learn how to export, and import VBA code modules.

01:31

Keep your code modules organized by naming any module that you create.

5 pages

To be comfortable writing VBA, you need to be comfortable in the VBE.

Learn how to customize the VBE to meet your needs.

1 page

Browse through your project's available objects, and see their properties, methods, and events.

1 page

Learn how you can password protect your VBA code modules.

02:59

When programming VBA, knowing a few time savers can go a long way.

02:45

If you get an error while programming your VBA that stops your code from running, don't stress.

Reset your code, and edit your code if you can.

Article

Key Points for the Section: Getting Familiar with the VBE (Visual Basic Environment)

Section 3: Getting Started with Programming in VBA
02:08

Get a brief overview of OOP, and how it plays a major role in this VBA programming course.

01:38

Learn how VBA accesses an object's properties, and methods.

01:24

Procedures are the container that you will be storing your code in.

02:07

A quick lecture on how to structure your sub procedures.

03:03

Learn how the structure of a function differs from the structure of a sub procedure.

02:42

Being able to use procedures throughout your module has many benefits.

Learn how to call your procedures in your VBA code.

Article

How do you call one procedure with the same name as another?

02:37

A click of a mouse, or the loading of a form, these are both events that can trigger your code to run.

In this lecture, learn about, and how to create, event procedures.

Article

Collections are a group of similar object.

Using collections can save you time when programming in VBA.

03:27

You can use comments to make notes in your code. It is very helpful, and highly recommended.

Article

Key Points for the Section: Object Oriented Programming

Section 4: Getting to Know Variables, Data Types, and Operators
00:35

An introduction to topics covered in this section

03:57

Declaring a variable lets VBA know that you want to store a value in the computer's memory.

03:09

Data types are a key component to programming. In this lecture find out why.

1 page

A list of VBA's built-in data types.

1 page

You can also declare variable's data types with Identifier Type Characters

01:30

Learn how to speed up the programming of your code by using Me.

02:31

Constants are placeholders for information that do not change through the life of your code.

03:58

Learn how Object Variables can save you time when writing your VBA.

1 page

Arithmetic Operators

04:51

An exercise in using arithetic operators.

02:20

You type a number in a text box, but is it really seen as a numeric value?

Article

Bring multiple strings together with String Contatenation

02:32

An exercise on string concatenation.

Article

When you want to wrap your VBA code around to multiple lines, use the Line Continuation Operator

Article

Learn how to use the Colon operator in VBA

01:22

Use the Carriage Return Line Feed to display strings on multiple lines.

Article

Using the With statement is a real time saver, find out why.

12:20

Setting the scope of your variables determines where those variables can be used.

02:23

An explanation of Arrays used in VBA

02:07

Test the skills you learned in this section with this exercise.

Article

Key Points for the Sections: The Essentials to Programming in VBA

Section 5: Functions
00:18

An introduction to this section.

04:53

Learn to extract data with the Left, Right, and Mid functions.

00:40

Change the case of your strings with UCase, and LCase

04:02

Locate characters in a string with the InStr function.

01:06

The simple Date, and Now functions can be used as time stamps in your databases.

01:27

Learn how to extract the Day, Month, and Year from a date parameter.

02:18

Calculate the difference between two dates.

00:26

Learn the simple function to display the time of day.

00:57

Learn how to extract the second, minute, and hour, from a time parameter.

01:52

Learn how to format your numbers with these common functions.

3 pages

Learn to create your own custom number formatting.

2 pages

Learn how to create custom date and time formats.

1 page

Learn how to create custom string formats.

02:40

Learn how to use the FormatCurrency function.

Article

Learn how to use the FormatNumber function.

1 page

Learn how to use the FormatDateTime function.

Article

Learn how to use the FormatPercent function.

01:53

Test the skills you have learn in the Formatting section, and apply them to this exercise.

Section 6: Events Attached to Access Database Objects Explained
00:37

An overview of Object events

00:24

Learn about using click events to trigger your code to run.

00:47

Learn about using focus events to trigger your code to run.

00:28

Learn about using mouse events to trigger your code to run.

00:42

Learn about using keyboard events to trigger your code to run.

00:34

Learn about using text box events to trigger your code to run.

00:36

Combo box Events

2 pages

Learn about using form events to trigger your code to run.

1 page

Learn about using report events to trigger your code to run.

01:29

Test the skill you learned in this section to complete the exercise in this lecture.

Section 7: Introductions to DoCmd Methods
00:55

Learn how much easier the DoCmd object will make your programming.

06:46

Learn how to filter records with the ApplyFilter method.

05:30

Learn how to copy objects in your database with the CopyObject method.

04:33

Learn how to quickly open forms with the OpenForm method.

03:27

Learn how to quickly open reports with the OpenReport method.

00:24

Learn how to quickly open tables with the OpenTable method.

03:54

Learn how to turn objects into PDFs or other formats with the OutputTo method.

03:08

Learn how to access menu commands with the RunCommand option.

2 pages

An exercise on using a DoCmd method to create an Outlook contact.

03:47

Learn how to run SQL in your VBA code with the RunSQL method.

04:36

Learn how to e-mail objects with the SendObject method.

03:17

Learn to use the TransferDatabase method.

02:47

Use TransferSpreadsheet to import, export, or link Excel worksheets to Access.

Article

Key points for the Introductions to DoCmd Methods section.

Section 8: Decisions Structures
07:21

Learn how to branch your VBA code, by using If... then...else

2 pages

An exercise using If Then Else

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.


Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.


Ready to start learning?
Take This Course