Access 2016 VB Programming Introduction
09:25 23 July
in
Length
1 Day
Experience Needed
N/A
Summary
This course is designed to give the advanced Access user the ability to design applications in Access 2016 using Visual Basic for Applications (VBA) – the underlying programming language for Microsoft Applications.
Course Content
Getting Started Quickly with Wizards
- Using Wizards for Application Development
- Creating a Database Using the Database Wizard
- Entering Information into the Database
- Using Existing Data with a New Database
- Adding an Object to Your Application
- Adding and Creating Command Buttons
Customizing and Application with Visual Basic
- Customizing a Command Button
- Viewing the Visual Basic Code Behind Your Application
- Modifying a Command Button Created Using the Wizard
- Making a Form Read-Only by Default
- Creating a Command Button Without a Wizard
- Creating Event Procedures for Forms Events
- Displaying a Message to the User
Finding and Filtering Records in a Form
- Creating a Combo Box to Find Records
- Filtering Data
- Responding to Filtering Events
- Using the If… Then Statements to Check a Condition
- Understanding Filtering Properties
- Using the Immediate Window to View and Set Properties
- Creating an Option Group to Filter Data
Responding to Errors and Unexpected Conditions
- Replacing Standard Error Messages
- Responding to the Error Event
- Displaying Your Own Message for a Specific Error
- Responding to a Combo Box Error
- Creating Error-Handling Routines
- Handling Errors that Occur when your application is Read-Only
- Anticipating Other problems that cause errors
Responding to Data Entry Events
- Understanding Form and Control EventsPerforming Actions as the User Moves in a Form and Changes Data
- Setting the Value of a Control “Auto-Magically”
- Responding to Keyboard Events
- Validating Data
- Asking the User a Question
Writing Your Own Functions
- Understanding Modules and Procedures
- Standard Modules and Form Modules
- Creating General Procedures in a Standard Module
- Using the Declarations Section
- Declaring Constant Values
- Creating a Sub Procedure
- Adding Arguments to a Procedure
- Creating a Function
- Using General Procedures on a Form
- Creating General Functions in a Form Module
Monitoring and Debugging Your Code
- Stepping Through Code Line by Line
- Setting a Breakpoint to Stop Running Code
- Stepping from Once Procedure to Another
- Monitoring Variables and Other Values
- Finding and Fixing Bugs in your Code
- Telling Visual Basic to Check Your Code