Last updated 12/2021MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.09 GB | Duration: 5h 18m

 

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

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 able 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 errorsWhat to know before you enroll:You will have unlimited, life 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 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 Functions: Date, and Now

Lecture 54 Date and Functions: Day, Month, and Year

Lecture 55 Date and Functions: DateDiff

Lecture 56 Date and Functions:

Lecture 57 Date and 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/ 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 FormatDate 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 140[BONUS LECTURE] How to Save Money While You Learn.

The Bning 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: