Microsoft Access

Course Outline
Microsoft Access (VBA & Developer)

|   Home     |     Training     |     TNAs  |    Courseware    |   Course Outlines   |   About   |    Contact    |    Index    |
    Application:  Microsoft Access
Level:  VBA & Developer
Duration:  2 Days
Target:  Participants should have at least an intermediate knowledge of building Access databases.
Objectives:  This intensive 2-day course is designed to introduce new Access programmers to the Visual Basic for Applications
 programming language and help them create robust and powerful database applications by taking a structured look
 at Access VBA. It will help new database developers plan their applications systematically and promote good design 
 and development techniques.
1. Introducing Access VBA
    Converting Macros to VBA
    The VBA programming environment
    The Visual Basic Editor
    Event driven programming
    Regular and Class modules
    Building Procedures
    Building Custom Functions

2. VBA Programming Basics
    Good practice in VBA coding
    Using Variables
    Array Variables
    Writing conditional code
    Code loops
    Compiling and debugging code
    Dealing with errors

3. Error Handling in VBA
    Ignoring Errors
    Trapping Errors
    Writing Error Handlers
    Logging Errors

     4. Working with Forms
    Form properties and events
    Control properties and events
    Working with Event Procedures
    Using VBA to validate data
    Automating form navigation
    Building tools for finding records
    Working with command buttons
    Working with combo boxes
    Working with list boxes
    Working with option groups
    Creating dialog boxes
    Creating switchboards
    Building a splash screen
    Manipulating a form's Recordset

5. Working with Reports
    Opening reports programmatically
    Manipulating reports with VBA
    Creating dynamic reports

     6. Manipulating Data with ADO and SQL
    ActiveX Data Objects (ADO)
    Connecting to data sources
    Database and Recordset Objects
    Manipulating Data with VBA
    Finding Records in a Recordset
    Editing Data in a Recordset
    Transaction Processing
    Using Recordsets to import data
    Manupulating Queries from VBA
    Changing Database Definitions through VBA
    Using SQL to Manipulate Databases
    SQL Data Modification Statements
    Methods of Running SQL from VBA Code
    Data Access Objects (DAO)

7. Working with Other Programs
    About VBA Automation
    Exporting data programmatically
    Writing data to other programs
    Retrieving data from other programs

Download a printable copy of this course outline as a PDF file [32KB].
  2006 Martin Green. All rights reserved. Contact: