Access VBA Training Course

Introduction to VBA

• Storing information
• Data types
• Variables
• Terminology, characteristics, scope, visibility of variables
• Control structures  if, select case, do, for
• Loops
• Built-in functions
• Types, finding and removing errors
• Comments

Object

• Definition
• Properties
• Methods
• Collections of objects
• Viewing
• Tables, queries, indexes
• Object-oriented data access
• Custom Class
• Object Error Handling

Databases

• Constructing queries with VBA
• Use of SQL syntax
• Transactions
• DAO and ADO
• Records
• Importing data from other systems

Applications

• Plan
• Interface
• Menus
• Reports
• Controls available from code
• Forms
• Integration and support for other applications
• Library functions

Best Practices

• Tips and trics