This VBA Essentials using Access tutor-led, live online course contains the same content as courses attended at our training venues.

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

Available Course Dates

• Tue 11 October - Thu 13 October in Virtual Classroom (Online) More Info Day 1: Tue 11 October in Virtual Classroom (Online), 9:30 - 16:30Day 2: Wed 12 October in Virtual Classroom (Online), 9:30 - 16:30Day 3: Thu 13 October in Virtual Classroom (Online), 9:30 - 16:30

  Attend Virtually

Objectives for this course

• • Explain the difference between sub and function procedures in VBA code
  • List 3 common events and in where they might use them in application design
  • Write professional VBA code segments with error checking to carry out tasks as defined by your tutor
  • Use the AccessObject object to create an intelligent report selection form
  • Build a browse form for quick navigation to a specific record
  • Create a flexible report such that people may choose its content at run-time
  • Describe how to debug VBA code

Prerequisites

• • Delegates should understand table, query, form, report and macro design and function, as well as data normalisation and table relationships.
    
  • Delegates should be currently working with an Access database application that they have built themselves.
  • Delegates should have attended Access Level 2 and/or Level 3 courses or have equivalent knowledge.

Included with this course

• • Laptops are available for training delivered at client's premises
  • Lunch and refreshments when training is delivered at our training venues
  • Comprehensive course materials and exercises
  • Telephone and Email Support

Virtual Course Content

• • Designing Applications
    What is an access application?
    The development process
    Macros or VBA?
  • Introduction to Event Driven Programming
    The VBA IDE
    Converting macros to VBA
    Completing the company contacts Form
  • Creating Code
    Procedures
    Modules
    Subroutines and functions
    Procedure declaration
    Built-in functions
    Variables
    Constants and intrinsic constants
    Variable scope and lifetime
    Naming conventions
  • Controlling the Program
    Programming structures
    Repetition
    Arrays
  • Using Access Objects
    Object-oriented programming
    Object models
    Access objects
    The AccessObject object
    Forms and reports
    Referring to objects
    Special objects
    The object browser
  • Using DAO
    Working with recordsets
    The DAO hierarchy
    DAO vs ADO
    
  • Reports
    Filters
    Format
    Error
    Close
    Deactivate
    Activate
    Open
    Events
    
  • Advanced Programming Techniques
    Custom DAO properties
    Dynamic-link libraries (DLLs)
    Arguments
    Arrays
    
  • Error Handling and Debugging
    Debugging your debugging code
    Error handling
    Debugging
    Types of errors
    Testing
    Compiling
    Planning for errors
    
  • Using Classes
    Forms as class modules
    Class modules and custom objects
    
  • Libraries and Add-Ins
    Add-ins
    Class libraries
    Library databases
    
  • Multi-User
    Compiling
    Security
    Record locking in access
    Multi-developer issues
    
  • The Internet (Optional as time permits)
    Publishing data to the internet
    The HyperLink data type
    The internet
    
  • Optimising Your Application
    Finishing touches
    Network considerations
    Increasing apparent speed
    Increasing execution speed
    Reducing memory overhead
    Efficiency