Access VBA Training Course

Course Outline

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

Leave a Reply

Your email address will not be published. Required fields are marked *