Course VBA Essentials using Access
  • Attend Online Book Now
  • Request a Quote
  • Public Scheduled Price£750 +VAT
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Online training: This course can be attended virtually This VBA Essentials using Access course is available as a virtual online course, which means you can attend your training remotely. Click here to see how virtual training works
Overview
This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
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.
Objectives
    • 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
What's included
    • 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
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

 

Course Dates
  • Mon 31 May - Wed 02 June More Info Day 1: Mon 31 May, 9:30 - 16:30Day 2: Tue 01 June, 9:30 - 16:30Day 3: Wed 02 June, 9:30 - 16:30
    Book
    Attend Online
  • Tue 12 October - Thu 14 October in Durham More Info Day 1: Tue 12 October in Durham, 9:30 - 16:30Day 2: Wed 13 October in Durham, 9:30 - 16:30Day 3: Thu 14 October in Durham, 9:30 - 16:30
    Book
    Attend Online

Latest Course Reviews
"All aspects of the course were valuable"

J.C. William Smith, VBA Essentials using Access

 

Content Dates Reviews Related PDF

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:07/05/2021 01:27:06