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

Requirements

  • Knowledge of any procedural programming language required (e.g. Basic, Pascal, C).
  • For people who want to learn the required skills, we recommend the course: Visual Basic for Applications (VBA) in Excel - introduction to programming.
  • Very good knowledge of Microsoft Access. It is recommended to complete the course: Access for advanced.
 21 Hours

Number of participants



Price per participant

Testimonials (1)

Related Courses

Excel Advanced with VBA

21 Hours

Visual Basic for Applications (VBA) in Excel (intermediate level)

14 Hours

Visual Basic for Applications (VBA) for Analysts

21 Hours

Excel and VBA Programming for Audit and Finance Professionals

28 Hours

Excel VBA Introduction

14 Hours

Excel VBA in One Day

7 Hours

VBA For Access & Excel

21 Hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

21 Hours

Visual Basic for Applications (VBA) in Excel - Advanced

14 Hours

Access Intermediate

14 Hours

Access Advanced

21 Hours

Microsoft Access - download the data

14 Hours

Access - podstawy

14 Hours

Access - Data Base Designing

21 Hours

SQL in Microsoft Access

14 Hours

Related Categories