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
Requirements
Access 2007, 2010, 2013, 2016 , 2019, 365
To get the most out of this course, you should have working knowledge of Microsoft Access databases
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 talkChoose 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 codeLearn about the powerful DoCmd objectCreate branching decision structuresCreate user interactions forms, like message boxes, and input boxesDAO recordsetsDebug 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.
Overview
Lecture 1 Welcome!
Section 1: Creating Macros in Microsoft Access
Lecture 2 Creating Macros vs. Programming in VBA
Lecture 3 Example of an Access Macro
Lecture 4 Converting Macros to VBA
Section 2: Getting Familiar with the VBE (Visual Basic Editor)
Lecture 5 Accessing the Visual Basic Editor
Lecture 6 VBA Windows & Toolbars
Lecture 7 Option Compare and Option Explicit
Lecture 8 Adding and Removing Modules
Lecture 9 Exporting and Importing Modules
Lecture 10 Naming Modules
Lecture 11 Options for Customizing the Visual Basic Editor
Lecture 12 The Object Browser
Lecture 13 Password Protecting Your VBA Code
Lecture 14 A Few Time Savers When Writing VBA
Lecture 15 What to do When You Have Error in Your Code?
Lecture 16 Section Summary
Section 3: Getting Started with Programming in VBA
Lecture 17 Object Oriented Programming
Lecture 18 How VBA Accesses an Object's Properties and Methods
Lecture 19 Working with Procedures
Lecture 20 Structure of Sub Procedures
Lecture 21 Structure of Functions
Lecture 22 Calling a Sub Procedure or Function
Lecture 23 Calling Procedures with the Same Name
Lecture 24 Event Procedures
Lecture 25 Collections
Lecture 26 Comments
Lecture 27 Section Summary
Section 4: Getting to Know Variables, Data Types, and Operators
Lecture 28 Introduction
Lecture 29 Variable Declaration
Lecture 30 The Importance of Data Types
Lecture 31 VBA's Built-in Data Types
Lecture 32 Using Identifier Type Characters to Declare Data Types
Lecture 33 About "Me"
Lecture 34 Declaring Constants
Lecture 35 Object Variables
Lecture 36 Arithmetic Operators
Lecture 37 Exercise: Arithmetic Operators
Lecture 38 Text Box Values
Lecture 39 String Concatenation
Lecture 40 Exercise: String Concatenation
Lecture 41 The Line Continuation Operator
Lecture 42 The Colon Operator
Lecture 43 Carriage Return-Line Feed
Lecture 44 The With Statement
Lecture 45 Controlling Access of Your Variables & Procedures with Scope
Lecture 46 Arrays
Lecture 47 Test Your Skills
Lecture 48 Section Summary
Section 5: Functions
Lecture 49 Introduction to Functions
Lecture 50 String Functions: Left, Right, and Mid
Lecture 51 String Functions: UCase, and LCase
Lecture 52 String Functions: InStr
Lecture 53 Date and Time Functions: Date, and Now
Lecture 54 Date and Time Functions: Day, Month, and Year
Lecture 55 Date and Time Functions: DateDiff
Lecture 56 Date and Time Functions: Time
Lecture 57 Date and Time Functions: Second, Minute, and Hour
Lecture 58 The Format Function: Using Named Format Expressions
Lecture 59 The Format Function: Creating Custom Number Formats
Lecture 60 The Format Function: Creating Custom Date/Time Formatting
Lecture 61 The Format Function: Creating Custom String Formats
Lecture 62 Using the FormatCurrency Function
Lecture 63 The FormatNumber Function
Lecture 64 Using the FormatDateTime Function
Lecture 65 The FormatPercent Function
Lecture 66 Test Your Skills
Section 6: Events Attached to Access Database Objects Explained
Lecture 67 Overview of Object Events
Lecture 68 Click Events
Lecture 69 Focus Events
Lecture 70 Mouse Events
Lecture 71 Keyboard Events
Lecture 72 Text box Events
Lecture 73 Combo box Events
Lecture 74 Form Events
Lecture 75 Report Events
Lecture 76 Test Your Skills
Section 7: Introductions to DoCmd Methods
Lecture 77 Introduction to DoCmd
Lecture 78 DoCmd ApplyFilter
Lecture 79 DoCmd CopyObject
Lecture 80 DoCmd OpenForm
Lecture 81 DoCmd OpenReport
Lecture 82 DoCmd OpenTable
Lecture 83 DoCmd OutputTo
Lecture 84 DoCmd RunCommand
Lecture 85 Exercise: Creating an Outlook Contact
Lecture 86 DoCmd RunSQL
Lecture 87 DoCmd SendObject
Lecture 88 DoCmd TransferDatabase
Lecture 89 DoCmd TransferSpreadsheet
Lecture 90 Section Summary
Section 8: Decisions Structures
Lecture 91 The IF THEN Statement
Lecture 92 Exercise: The IF THEN Statement
Lecture 93 The Select Case Statement
Lecture 94 Exercise: Select Case
Lecture 95 Test Your Skills
Lecture 96 Test Your Skills II
Lecture 97 Section Summary
Section 9: Creating User Interactions with Message Boxes & Input Boxes
Lecture 98 How Are You Enjoying the Course?
Lecture 99 Message Boxes
Lecture 100 Input Boxes
Lecture 101 Exercise: Input Boxes & Message Boxes
Lecture 102 Section Summary
Section 10: Loop Structures
Lecture 103 Introduction to Loops
Lecture 104 For Next Loop Introduction
Lecture 105 Stepping
Lecture 106 Exiting a For Loop
Lecture 107 For Next Loop
Lecture 108 For Each Next Loop Introduction
Lecture 109 For Each Loop
Lecture 110 Do While Loop Introduction
Lecture 111 Exiting a Do Loop
Lecture 112 Do While Loop
Lecture 113 Do Until Loop Introduction
Lecture 114 Exercise: Do Until
Lecture 115 Section Summary
Section 11: Introduction to Programming Recordsets (DAO)
Lecture 116 Opening and Closing a Recordset
Lecture 117 Adding New Records
Lecture 118 Finding Records
Lecture 119 Editing a Record
Lecture 120 Deleting a Record
Lecture 121 Exercise: Working with Table Records
Lecture 122 Counting Records
Lecture 123 Moving Around in a Recordset
Lecture 124 Exercise: Moving Around in a Recordset
Section 12: Debugging Your VBA & Error Handling
Lecture 125 Introduction to Debugging and Error Handling
Lecture 126 Types of Errors
Lecture 127 Debugging: Setting a Breakpoint & Stepping Through Code
Lecture 128 Debugging: The Watch Window
Lecture 129 Debugging: The Locals Window
Lecture 130 Debugging: The Immediate Window
Lecture 131 Error Handling: The On Error GoTo Statement
Lecture 132 Error Handling: The On Error Resume Next Statement
Lecture 133 Error Handling: The Err Object
Lecture 134 Section Summary
Section 13: Reference
Lecture 135 Glossary
Lecture 136 Suggested Naming Conventions for Controls
Lecture 137 Keyboard Shortcuts
Lecture 138 Reserved Keywords
Section 14: Wrap Up
Lecture 139 Thank You!
Section 15: Course Coupons
Lecture 140ONUS LECTURE How to Save Money While You Learn.
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


Homepage

https://www.udemy.com/course/access-vba/