Access VBA Training Course

Last updated

Course Code

2370

Duration

21 hours (usually 3 days including breaks)

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

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

This site in other countries/regions