Introduction to Visual Basic for Access Course
Course Duration:
Three Days
Our introduction to Microsoft Access VBA training course is suitable for those Advanced users of Access
Any one responsible for managing very large and variable amounts of data, or teams, who want to learn how to program features and functions to improve the accessibility and usability of your data.
At the end of the training course you will have covered the fundamentals of VBA (Visual Basics Applications), including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. You will have mastered how to control program execution, working with forms and controls, working with the PivotTable object. Finally the course also includes modules on debugging code, handling errors to ensure minimal downtime while building and effecting the program.
Those who complete the Microsoft Access VBA course satisfactorily will receive a certificate at the end of the computer training course.
Read on for further information on the Introduction to Microsoft Access VBA computer training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page
Course Level:
Introduction
Course Requirements:
A high proficiency of Access is essential, or completion of our Microsoft Access Advanced course.
Course Content:
Introduction to VBA
• The history of VBA, its importance and relevance to today's solutions
• Consideration of compatibility issues.
Concepts in VBA
• Getting to grips with Objects and their Properties and Methods
• Understanding Procedures and Modules.
• An introduction to events and event handling
Objects
• Treatment of Objects in general.
• An introduction to naming conventions.
• How Properties and Methods are accessed and used. • Objects specific to Microsoft Access
Variables & Constants
• A general introduction to storage using Variables and Constants.
• When and how to declare, use and name them
Control Structures
• Determining the flow of a program.
• Writing self-contained, re-usable Procedures
Controls
• Control types commonly found in Microsoft applications.
• How to create and use them
Forms
• Enhancing forms with Procedures
Procedures & Functions
• Calling Procedures from other Procedures.
• Passing data between Procedures.
• Using standard Functions.
• Use of Named Arguments.
• An introduction to the creation and use of custom Functions.
• Automatic Procedures in Access
Menus & Toolbars
• Using the Menu Editor.
• Creating and customising Toolbars.
• Assigning Procedures.
• Manipulation within Procedures
Debugging & Error Handling
• Types of errors and how to handle them.
• Investigating problems using the Debug Window.
Useful For:
Availability:
Our Experience: