Access VBA: The Beginner's Blueprint to Programming Access
4.6 (75 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,496 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access VBA: The Beginner's Blueprint to Programming Access to your Wishlist.

Add to Wishlist

Access VBA: The Beginner's Blueprint to Programming Access

Don't Just Use Your Microsoft Access Databases... Program Them with the Tools Found in This Course!
4.6 (75 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,496 students enrolled
Created by Isá Harrison
Last updated 5/2017
English
Current price: $10 Original price: $195 Discount: 95% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 25 Articles
  • 60 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Access 2007, 2010, 2013, 2016
  • To get the most out of this course, you should have working knowledge of Microsoft Access databases
Description

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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
140 Lectures
05:18:04
+
Welcome!
1 Lecture 01:48

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

IsaBel Harrison | Udemy.com

Preview 01:48
+
Creating Macros in Microsoft Access
3 Lectures 12:53

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

Preview 02:14

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

Preview 06:41

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

Preview 03:58
+
Getting Familiar with the VBE (Visual Basic Editor)
12 Lectures 17:22

There are multiple ways to access the Visual Basic Editor.

Take a few seconds to learn them now.

Preview 01:13

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

Preview 06:31

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

Preview 1 page

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

Preview 01:22

Learn how to export, and import VBA code modules.

Preview 2 pages

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

Naming Modules
01:31

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

Learn how to customize the VBE to meet your needs.

Options for Customizing the Visual Basic Editor
5 pages

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

The Object Browser
1 page

Learn how you can password protect your VBA code modules.

Password Protecting Your VBA Code
1 page

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

A Few Time Savers When Writing VBA
02:59

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.

What to do When You Have Error in Your Code?
02:45

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

Section Summary
01:01
+
Getting Started with Programming in VBA
11 Lectures 20:16

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

Object Oriented Programming
02:08

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

How VBA Accesses an Object's Properties and Methods
01:38

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

Working with Procedures
01:24

A quick lecture on how to structure your sub procedures.

Structure of Sub Procedures
02:07

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

Structure of Functions
03:03

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

Learn how to call your procedures in your VBA code.

Calling a Sub Procedure or Function
02:42

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

Calling Procedures with the Same Name
00:24

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.

Event Procedures
02:37

Collections are a group of similar object.

Using collections can save you time when programming in VBA.

Collections
00:21

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

Comments
03:27

Key Points for the Section: Object Oriented Programming

Section Summary
00:24
+
Getting to Know Variables, Data Types, and Operators
21 Lectures 45:47

An introduction to topics covered in this section

Introduction
00:35

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

Variable Declaration
03:57

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

The Importance of Data Types
03:09

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

VBA's Built-in Data Types
1 page

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

Using Identifier Type Characers to Declare Data Types
1 page

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

About "Me"
01:30

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

Declaring Constants
02:31

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

Object Variables
03:58

Arithmetic Operators

Arithmetic Operators
1 page

An exercise in using arithetic operators.

Exercise: Arithmetic Operators
04:51

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

Text Box Values
02:20

Bring multiple strings together with String Contatenation

String Concatenation
00:03

An exercise on string concatenation.

Exercise: String Concatenation
02:32

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

The Line Continuation Operator
00:17

Learn how to use the Colon operator in VBA

The Colon Operator
00:06

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

Carriage Return-Line Feed
01:22

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

The With Statement
00:12

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

Controlling Access of Your Variables & Procedures with Scope
12:20

An explanation of Arrays used in VBA

Arrays
02:23

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

Test Your Skills
02:07

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

Section Summary
01:32
+
Functions
18 Lectures 22:45

An introduction to this section.

Introduction to Functions
00:18

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

String Functions: Left, Right, and Mid
04:53

Change the case of your strings with UCase, and LCase

String Functions: UCase, and LCase
00:40

Locate characters in a string with the InStr function.

String Functions: InStr
04:02

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

Date and Time Functions: Date, and Now
01:06

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

Date and Time Functions: Day, Month, and Year
01:27

Calculate the difference between two dates.

Date and Time Functions: DateDiff
02:18

Learn the simple function to display the time of day.

Date and Time Functions: Time
00:26

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

Date and Time Functions: Second, Minute, and Hour
00:57

Learn how to format your numbers with these common functions.

The Format Function: Using Named Format Expressions
01:52

Learn to create your own custom number formatting.

The Format Function: Creating Custom Number Formats
3 pages

Learn how to create custom date and time formats.

The Format Function: Creating Custom Date/Time Formatting
2 pages

Learn how to create custom string formats.

The Format Function: Creating Custom String Formats
1 page

Learn how to use the FormatCurrency function.

Using the FormatCurrency Function
02:40

Learn how to use the FormatNumber function.

The FormatNumber Function
00:05

Learn how to use the FormatDateTime function.

Using the FormatDateTime Function
1 page

Learn how to use the FormatPercent function.

The FormatPercent Function
00:07

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

Test Your Skills
01:53
+
Events Attached to Access Database Objects Explained
10 Lectures 05:37

An overview of Object events

Overview of Object Events
00:37

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

Click Events
00:24

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

Focus Events
00:47

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

Mouse Events
00:28

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

Keyboard Events
00:42

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

Text box Events
00:34

Combo box Events

Combo box Events
00:36

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

Form Events
2 pages

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

Report Events
1 page

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

Test Your Skills
01:29
+
Introductions to DoCmd Methods
14 Lectures 43:20

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

Introduction to DoCmd
00:55

Learn how to filter records with the ApplyFilter method.

DoCmd ApplyFilter
06:46

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

DoCmd CopyObject
05:30

Learn how to quickly open forms with the OpenForm method.

DoCmd OpenForm
04:33

Learn how to quickly open reports with the OpenReport method.

DoCmd OpenReport
03:27

Learn how to quickly open tables with the OpenTable method.

DoCmd OpenTable
00:24

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

DoCmd OutputTo
03:54

Learn how to access menu commands with the RunCommand option.

DoCmd RunCommand
03:08

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

Exercise: Creating an Outlook Contact
2 pages

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

DoCmd RunSQL
03:47

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

DoCmd SendObject
04:36

Learn to use the TransferDatabase method.

DoCmd TransferDatabase
03:17

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

DoCmd TransferSpreadsheet
02:47

Key points for the Introductions to DoCmd Methods section.

Section Summary
00:16
+
Decisions Structures
7 Lectures 16:51

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

The IF THEN Statement
07:21

An exercise using If Then Else

Exercise: The IF THEN Statement
2 pages

The Select Case statement is another way to branch your VBA code.

The Select Case Statement
05:09

An exercise using Select Case.

Exercise: Select Case
2 pages

Test your If..Then skills with this exercise.

Test Your Skills
01:51

Test your Select Case skills with this exercise.

Test Your Skills II
02:12

Key Points for the Section: Decisions Structures

Section Summary
00:18
+
Creating User Interactions with Message Boxes & Input Boxes
5 Lectures 15:07

How are you enjoying the course so far?

How Are You Enjoying the Course?
1 page

Learn the syntax for creating message boxes in VBA.

Message Boxes
07:57

Learn the syntax for creating Input Boxes in VBA

Input Boxes
03:57

An exercise using input boxes and message boxes.

Exercise: Input Boxes & Message Boxes
03:00

Key Points for the Section: Creating User Interactions with Message Boxes & Input Boxes

Section Summary
00:13
5 More Sections
About the Instructor
Isá Harrison
4.6 Average rating
874 Reviews
14,849 Students
15 Courses
Results & Convenience | 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.