Microsoft Access Visual Basic for Applications (VBA) Training Course
This training 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 Aims to enable delegates to:
Work with objects, use the Object Browser, identify collection objects, and use the Controls collection. Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another. Use decision structures and loop structures. Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code.
|Visual Basic For Applications Overview
· The VBA Editor
Create powerful applications
· Objects, Properties and Methods
Learn basic programming structures
· Working with Modules
Work with conditional statements and loops
· The If Statement
Create custom message boxes
· Evaluating a Message box
|Create Custom functions
· Using Built-in Functions
Interact with Excel or Word
· Opening Other Applications
Write error-handling code
· Stepping Through Code
Validating User Input
· Checking for Null Values
Requirements before booking this course:
This is a generic course and is suitable for users of any version of Microsoft Access. 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.