Realdolmen Education

Details

Access Programming

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

Request Course

Duration

4 day(s)

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

Participants should have taken the Access Introduction course or they should have acquired knowledge of the same level through a daily experience with Access as a tool. Creating tables, queries, forms, reports and relations should not be a problem. Thorough knowledge of controls and their properties is strongly recommended.Additional knowledge about macros or any experience in programming is a plus, but not required.

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

Class training with enough room for individual guidance because: -Each student disposes of a work station -The student can put the subject matter into practice by means of exercises -There is time to ask questions.

Description

Using a database with only a few tables, the students will build up a completely automated database with the help of their teacher. This concrete application, with which they work during the course, contains all the elements required to automate a database.

This does not only mean working with macros and the Visual Basic code, but also the actual creation of forms and reports, where the properties of the various objects are discussed in detail.

By means of some simple macros, the various possibilities to automate a database without programming, are explained.

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

Finally, there is also attention to the finish of the database application and its security.

Contents

  • Introduction
  • Macros
    • Create a macro
      • Independent macros
      • Embedded macros
      • Add actions
    • Run a macro
    • Program flow in macros
      • Add comment
      • Conditions in macros
      • Submacros
      • Group macro actions
    • Data macros
    • Create a macro using the Command Button Wizard
    • Debug a macro
    • Add error handling to a macro
    • 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
  • DAO and ADO
  • Other
    • User Defined Functions
    • Automation
    • Startup options
    • Security