Access Programming in VBA
CLASS DATE(s):
9/21/2020 - 9/23/2020

COURSE LENGTH: 3 Days

COURSE COST: $995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This instructor-led course looks at the critical aspects of application development using Microsoft Access. You'll dig deep into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). You'll learn how to programmatically display and manipulate data on forms and reports. What is Access VBA

VBA stands for Visual Basic for Applications. Visual Basic is, by far, the most widely used programming language in the world. It has been estimated that Visual Basic programmers outnumber every other programmer added together! VBA is no different from regular Visual Basic except that it can only be used to add features to Microsoft Office applications (such as Access, Excel, PowerPoint, Word, Project and Visio) rather than to write free-standing applications.

AUDIENCE AND PREREQUISITES

To get the most out of Programming in Microsoft Access, you should understand how to create and use all the interactive Access objects: Tables, queries, forms, and reports. You should have taken Access Level 1, Level 2 and Level 3 or the associated knowledge. Programming experience in any language is helpful, but not required. Access 2010 Level 1: Introduction to Microsoft Access Access 2010 Level 2: Intermediate Topics Access 2010 Level 3: Advanced Topics.
Much of what you learn in our VBA course will also be relevant to writing custom VBA extensions to other office applications too.

If you are an Expert-level Access user and still can't make Access do what you need then this course is definitely for you.

If you want to develop robust, professional and polished Access applications for re-sale this course will show you how.

Must have Expert Access skills.

PREREQUISITE COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course subject to minimum enrollment.

COURSE TOPICS:


Advantages of Access and VBA
Understanding Where Access fits in Office
Understanding Access Programming Choices
Macros
Using SQL
Using VBA

Using the Visual Basic Editor
First Look at the Visual Basic Editor
Explaining VBA Modules
Entering and Running Code, Debugging Code, Saving Code
Getting Help on Code, Coding Shortcuts
Good Coding habits
Using a naming Convention
Indenting
Documenting

Using Variables, Constants, and Data Types
Declaring Variables and Constants
VBA Data Types
Referencing Syntax
Case Study: Using Form References

Using Built-In Functions
What Are Functions?
Converting Data Types
Working with Date Functions
Using Mathematical Functions
Using Financial Functions
Manipulating Text String
Formating Values
Domain Aggregate Functions
Using the Is Fnctions
Interation
Case Study: Add Work Days

Building Procedures
Types of Procedures
Passing Arguments
Error Handling

Conditional and Looping Statements
Introduction Flow of control Statements
Using If ... Then...Else
Using Select Case
Using For...Net
Using Do Loops
Using GoTo
Case Study: Calculating Bonuses

Working with Arrays
Introduction Arrays
Declaring a Fixed-Size Array
Understanding an Array's Indexx
Working with Array Elements
Arrays with Multiple Dimensions
Expanding to Dynamic Arrays

Object and event-Driven Coding
Understanding Objects
Invoking Methods
Using Collections
Working with an Object Model
Creating Objects
Working with Events

Understanding Scope and Lifetime
Scope Explained
Procedure-Level Variables
Module-Level Variables and Constants
Public Variables and Constants
Measuring the Lifetime of a Variable or Constant
Using Static Variables
Case Study: Tracking the Current User

Working with Forms
Opening and Closing Forms
The Form Module
Form and Control Properties
Form Events
Case Study: Adding to a Combo Box

More on Event-Driven Coding
Responding to Events
The Event Sequence for Controls
Focus Evetns, Data Events, Control Specific Events
The Event Sequence for Forms
Navigation Events
Canceling Events
Case Study: Validating Data

Working with Selection Controls
Selection Controls
Populating a List Control
Adding to the List - Or Not
Updating a Table/Quer List
Working with Option Groups
Working with MultiSelect Controls
Case Study: Selecting Multiple Items

Working with Other Controls
Working with Text Boxes
Key Properties of Text Boxes
Tracking the Focus
Working with Check Boxes, Radio Buttons, or Toggle Buttons
Working with Subforms
Working with the Tag Property
Case Study: An Audit Trail

Working with Reports
An Introduction to the Report Module and Events
Opening and Closing Reports
Passing Argument Using OpenArgs
Populating the Report
Handling Report -Level Errors
Working with Subreports
Case-Study: Product Catalog