We use cookies to provide you with the best possible experience. Please carry on browsing if you're happy with this or click here to find out more about how we use cookies and how to manage your preferences.

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields
Course VBA Essentials using Access
  • Public Scheduled Price£750 +VAT
  • Course Duration3 Days
  • 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.
Overview
This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
Prerequisites
    • Delegate should also understand table, query, form, report and macro design and function, as well as data normalization 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

 

 

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

 
IT Training Solutions Ltd - All rights reserved  |  Contact Us  |  Enquire Online |  Read our privacy policy