Training Course

VBA Essentials using Access

Download Course PDF

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Duration

3 Days

VBA Essentials using Access Course Overview

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

Course 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.

Course 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

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support

VBA Essentials using Access 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

 

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • VBA Essentials using Access Course Options
    Public Scheduled
    Public Scheduled
    Fixed course 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 course content, flexible training date(s), flexible location(s), variable course 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

Which part of the course did you find particularly valuable Learning about the way the connections work with databases with ado etc..

M. William Smith, VBA Essentials using Access

All aspects of the course were valuable

J.C. William Smith, VBA Essentials using Access

I found all the information useful and was able to follow all instructions given to me.

E.M. Newcastle GP Services, Sage Accounts Level 1

Following this training what are you going to do differently Tidy up the current spreadsheets that I use using the new features that I have learnt. Will help me with my KPIs.

C.G. Vehicle Lease and Service Ltd, Excel Level 2

Any other comments or recommendations Very valuable training. Highly recommend! Trainer is insightful and patient.

V.B. Aura North East Ltd, Adobe InDesign Level 1

Was good that the trainer recognised how I felt and took that on board and was great with it

R.S. Newcastle City Council, Train the Trainer Training Skills for the Workplace

Very competent and thorough course

S.W. Land Digital Agency, Train the Trainer Training Skills for the Workplace

Are there any aspects of the course which you feel require improvement No, I feel that the pace was good and the way that the training was setup with a ';lecture'; period followed by a ';practical'; period is a good way of learning.

D.W. Deepocean, Microsoft Project Essentials

+ View More Training Reviews

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your VBA Essentials using Access course, we have many solutions available to ensure you receive the best training possible.
Your VBA for Access course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible VBA Essentials using Access course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master VBA for Access, please contact us to book a place or request a quote for your VBA Essentials using Access course.

General Information

Microsoft Access and Visual Basic for Applications are registered trademarks of the Microsoft Corporation <a href=';/gateshead/microsoft-access-training-courses.asp';>Access Training Courses in Gateshead.</a>VBA using Access training courses in North East England, Durham, Washington, Visual Basic for Applications (VBA) using Access training courses in Newcastle, North East. <a href=';/microsoft-access-training-newcastle/microsoft-access-training-newcastle.asp';>Access Training Newcastle.</a>
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:9/14/2024 4:57:38 AM