Realdolmen Education

Details

Access VBA Programming

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

3 day(s)

MS Access: Using VBA to automate databases

Duration

3 days

Audience

The course is intended for experienced Access users who wish to automate MS Access databases even more than is possible with macros to develop their own applications.

Prerequisites

Having followed the course " MS Access: Creating and using databases" or having the experience of using MS Access. Being able to create tables, relationships, queries, forms and reports. Having followed the course “MS Access: Module 4 – Automating databases without programming” or any experience in programming is a plus. A good knowledge of working in a Windows environment and file management is necessary.

Objectives

Getting acquainted with Visual Basic for Access to be able to build an application providing interaction with the user. After the course, participants will have an overall picture of the way in which they can completely automate an existing database. Moreover, each student will have gained a clear insight in the application possibilities of objects known, and in the interaction between them.

Methods

Instructor-led classroom training, where to automate an existing database with VBA code. Thanks to specific problems, the theory will be directly linked to practice.

Description

Using an existing database with tables, queries, forms and reports, the students build a fully automated database together with the teacher.

In addition to the general building blocks of the VBA language, such as variables, constants, conditional structures and loops, students also learn to automate specific Access objects via VBA.

Contents

  • Introduction
  • Convert macros to VBA
  • The VBE
    • Open the Visual Basic Editor
    • Description of the screen
    • Options
    • Switching between the VBE and Access
  • VBA general
    • The structure of a VBA project
    • Create a standard module
    • Create Sub procedures and Function procedures
    • Variables
    • Expressions
    • Constants
    • Conditional program structures
      • If Then
      • Select Case
    • Loops
      • For Next
      • Do Loop
    • Errors
      • Types of errors
      • Break Mode
      • Debug
      • Error handling for runtime errors
  • Working with Access objects
    • Collections, properties, methods and events
    • The Object Browser
    • Object variables
    • Program structures
      • With ... End With
      • For Each ... Next
    • DoCmd
    • Working with Forms
      • References to forms
      • Properties
      • Methods
      • Events
      • Sections in a form
      • Controls in a form
    • Working with Reports
      • Properties
      • Methods
      • Events
      • Sections in a report
      • Controls in a report
  • Other
    • DAO and ADO
    • User Defined Functions
    • Startup options