iTrain Scotland IT Training Edinburgh image
 

Microsoft Access VBA

iTrain Scotland IT Training Edinburgh image

Dates & prices
(including virtual online classroom)
Home > Courses > Microsoft courses > Microsoft Access VBA

Microsoft Access VBA

This course teaches experienced Access users about the greater advantages to be gained by combining the built-in features of Access with the programming capabilities of Visual Basic for Applications (VBA). The course is designed to give delegates a thorough overview of programming within the Access environment, enabling them to improve the functionality of their Access databases, whilst providing a useful introduction to VB programming.

Course content

Prerequisites

This course is particularly beneficial for those with a sound knowledge of Access who are familiar with other features available such as tables, queries, forms, reports, macros and relationships.

Course goals

 

This course will enable a delegate to:
  • work with objects
  • use the Object Browser,
  • identify collection objects
  • use the Controls collection
  • manipulate data by declaring variables
  • combine data by using expressions
  • get user input
  • create Sub and Function procedures
  • call one procedure from another
  • Use decision structures and loop structures
  • identify compile-time, run-time, and logical errors
  • use the debugging tools
  • write error-handling code.

 

Topics

VISUAL BASIC FOR APPLICATIONS OVERVIEW
 
  • The VBA Editor
  • Program Structure
  • Customising The VBA environment

CREATE POWERFUL APPLICATIONS
  • Objects, Properties and Methods
  • Synchronising Forms
  • Storing Return Values

LEARN BASIC PROGRAMMING STRUCTURES
  • Working with Modules
  • Creating Sub Procedures
  • Calling Sub Procedures

WORK WITH CONDITIONAL STATEMENTS AND LOOPS
  • The If Statement
  • The Do Command
  • Looping
CREATE CUSTOM MESSAGE BOXES
 
  • Evaluating a Message box
  • Responding to User Selections

CREATE CUSTOM FUNCTIONS
  • Using Built-in Functions
  • Creating Custom Functions
  • Calling Function Procedures

INTERACT WITH EXCEL OR WORD
  • Opening Other Applications
  • Destroying Object Variables
  • Adding Data

WRITE ERROR-HANDLING CODE
  • Stepping Through Code
  • Using the Intermediate Window
  • Setting a Watch on a Variable

VALIDATING USER INPUT
  • Checking for Null Values
  • Offering Choices
Make An Enquiry

Related courses