Course
VBA Essentials using Access
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Course Duration
3 Days 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.
- Delegates should understand table, query, form, report and macro design and function, as well as data normalisation and table relationships.
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
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
Course Content
-
Designing ApplicationsWhat is an access application?
The development process
Macros or VBA? -
Introduction to Event Driven ProgrammingThe VBA IDE
Converting macros to VBA
Completing the company contacts Form -
Creating CodeProcedures
Modules
Subroutines and functions
Procedure declaration
Built-in functions
Variables
Constants and intrinsic constants
Variable scope and lifetime
Naming conventions -
Controlling the ProgramProgramming structures
Repetition
Arrays -
Using Access ObjectsObject-oriented programming
Object models
Access objects
The AccessObject object
Forms and reports
Referring to objects
Special objects
The object browser -
Using DAOWorking with recordsets
The DAO hierarchy
DAO vs ADO
-
ReportsFilters
Format
Error
Close
Deactivate
Activate
Open
Events
-
Advanced Programming TechniquesCustom DAO properties
Dynamic-link libraries (DLLs)
Arguments
Arrays
-
Error Handling and DebuggingDebugging your debugging code
Error handling
Debugging
Types of errors
Testing
Compiling
Planning for errors
-
Using ClassesForms as class modules
Class modules and custom objects
-
Libraries and Add-InsAdd-ins
Class libraries
Library databases
-
Multi-UserCompiling
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 ApplicationFinishing touches
Network considerations
Increasing apparent speed
Increasing execution speed
Reducing memory overhead
Efficiency
Latest Course Reviews
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
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 class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. 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.
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed 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!PrivatePrivateFlexible 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.BespokeBespokeBespoke 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.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/19/2024 4:36:29 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/19/2024 4:36:29 AM