Access® 2016 Programming with VBA

Course Content:
Lesson 1: Getting Started
 Topic A: Introduction to Programming in Access
 Topic B: Why Program in Access?
 Topic C: Understanding the Development Environment
 Topic D: Using Visual Basic Help

Lesson 2: Working with Procedures and Functions
 Topic A: Understanding Modules
 Topic B: Creating a Standard Module
 Topic C: Understanding Procedures
 Topic D: Creating a Sub Procedure
 Topic E: Calling Procedures
 Topic F: Using the Immediate Window to Call Procedures
 Topic G: Creating a Function Procedure
 Topic H: Naming Procedures
 Topic I: Organizing Code and Procedures
 Topic J: Working with the Code Editor

Lesson 3: Understanding Objects
 Topic A: Understanding Classes and Objects
 Topic B: Navigating the Access Object Hierarchy
 Topic C: Understanding Collections
 Topic D: Using the Object Browser
 Topic E: Working with the Application Object
 Topic F: Understanding the Form Object
 Topic G: Working with Properties
 Topic H: Using the with Statement
 Topic I: Working with Methods
 Topic J: Understanding the DoCmd Object
 Topic K: Working with Events
 Topic L: Understanding the Order of Events

Lesson 4: Using Expressions, Variables, And Intrinsic Functions
 Topic A: Understanding Expressions and Statements
 Topic B: Declaring Variables
 Topic C: Understanding Data Types
 Topic D: Working with Variable Scope
 Topic E: Working with Variable Lifetime
 Topic F: Considering Variable Scope and Lifetime Together
 Topic G: Using Intrinsic Functions
 Topic H: Understanding Constants
 Topic I: Using Intrinsic Constants
 Topic J: Using Message Boxes
 Topic K: Using Input Boxes

Lesson 5: Controlling Program Execution
 Topic A: Understanding Control-of-Flow Structures
 Topic B: Working with Boolean Expressions
 Topic C: Using the If...End If Decision Structures
 Topic D: Using the Select Case...End Select Structure
 Topic E: Using the For...Next Structure
 Topic F: Using the For Each...Next Structure
 Topic G: Using the Do...Loop Structure
 Topic H: Guidelines for use of Branching Structures

Lesson 6: Working with Recordsets
 Topic A: Declaring and Creating Object Variables
 Topic B: Working with the DAO Recordset Object

Lesson 7: Debugging Code
 Topic A: Understanding Errors
 Topic B: Using Debugging Tools
 Topic C: Setting Breakpoints
 Topic D: Setting Break Expressions
 Topic E: Using Break Mode during Run Mode
 Topic F: Stepping through Code
 Topic G: Determining the Value of Expressions

Lesson 8: Handling Errors
 Topic A: Understanding Error Handling
 Topic B: Understanding VBA's Error Trapping Options
 Topic C: Trapping Errors with the On Error Statement
 Topic D: Understanding the Err Object
 Topic E: Writing an Error-Handling Routine
 Topic F: Working with Inline Error Handling

Prerequisites:
To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following courses:

• Microsoft® Office Access® 2016 Introduction
• Microsoft® Office Access® 2016 Intermediate
• Microsoft® Office Access® 2016 Advanced

Student Responsibilities:
Assuring you have the pre-requisite knowlege for this class is very important.  Call UConn/CITI at (203) 251- 9516 to discuss your knowledge level with a counselor. UConn/CITI may suggest you do some self study before class, take the MS Office Access 2016 Advanced class, or work on some other tutorials.