Access 2016 VB Programming Introduction

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

Comprehensive training and customized learning programs for your organization