VBA Essentials using Access training courses in and around Newcastle and the North East. VBA Essentials using Access courses in Durham, Washington, Sunderland, Darlington, Middlesbrough, Gateshead, Leeds and throughout North East England.

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

PDF

Course VBA Essentials using Access

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.
Latest Reviews

"All aspects of the course were valuable"

J.C. William Smith, VBA Essentials using Access

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

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

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 Dates Please contact us to discuss dates for this course, thank you

Latest Course Reviews

"All aspects of the course were valuable"

J.C. William Smith, VBA Essentials using Access

Related Courses

- VBA Essentials using Excel
  
  This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to mod
- VBA using Word
  
  This course is designed to help experienced Word users automate common tasks and create end user systems. The user does

Other Courses In This Series

- Access Advanced Database Design
  
  This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand
- Access Essentials - An Introduction to Database Design
  
  This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 23 Oct 19

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

Contact us online or call us on 0191 377 8377

Contact us