Advanced Access VBA
CLASS DATE(s):
9/24/2020 - 9/25/2020

COURSE LENGTH: 2 Days

COURSE COST: $695.00

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

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This 2-day instructor led course is for advanced Access VBA students. Students will work with Data, Create Schema, Data Manipulation, Other Data files and Other Applications

With Microsoft Access VBA you will learn Visual Basic for Applications (VBA). VBA is a superset of the Visual Basic command syntax and a rich assortment of functions with the capability to control objects in your application.

With the information provided you will explore commands, functions, properties, and methods and how to use them.

You will learn the two main ways to get at data: Data Access Objects (DAO) and ActiveX Data Objects (ADO). You will learn object models as they apply to the Access Connectivity Engine (ACE), the database engine under the hood of Access. You will learn advanced topics of database analysis, such as retrieving a list of all relationships in your database or discovering all the computers that are connected to your database.

AUDIENCE AND PREREQUISITES

Access Database Users and Analysis. Students who took Access Programming with VBA Introduction.

  

Course is subject to minimum enrollment. Courseware is not included in the course cost. For more information on costs, please contact: learn@vtec.org

COURSE TOPICS:


Menus, Navigation, and Ribbon
Introduction to Menus
Creating Form-Based Menus
Managing the Navigation Pane
Using Custom Ribbons

Application Collections
Understanding application Collections
Retrieving Lists of Objects
Working with Object Properties
Programmatically Determining Dependencies
Case Study-Version Control

Working with Data / Object Models for Working with Data
What they Are and Why We Need Them
Data Access Objects
ActiveX Data Objects
ActiveX Data Objects Extensions for Data Definition
Object Model Selection

Creating Schema
Overview
Creating Databases Using DAO & ADOX Object Model
Creating Tables
Creating Fields
Creating Indexes
Creating Relationships
Creating Queries
Case Study - Updating an Existing Database Installation

Data Manipulation
Connecting to a Data Source
Opening a Recordset
Inserting Data
Finding Data
Updating Data
Deleting Data
Case Study / Backing Up Data

Advanced Data Operations
Creating Linked Tables
Data Definition Language
Schema Recordsets
Subqueries

Working with Other Data Files
Understanding File I/O
Opening Files
Reading from Files
Writing to Files
Printing to Files
Case Study - Using ini Files

Working with Other Applications
Understanding Automation
Setting Object References
Creating Objects
Working with Automation Servers
Case Study - Using Excel Charts

Working with XML Files
Understanding XML
Using Export XML
Using Import XML

Using the Windows API
Declaring API Calls
Using API Calls
API Calls You Can Use from Access
Knowing When to Use the Windows API
Case Study - Capturing a Filename to Use for Processing

A Review of Access SQL
Introduction to SQL
SQL Structure and Syntax
The Select Statement
The Insert Statement
The Update Statement
The Select Into Statement
The Delete Statement
Crosstabs