Course
VBA Essentials using Access
Course Duration
3 Days
This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.
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.
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
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
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 their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create
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 Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data mani
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 modify Excel to be better suited to their environment, by creating their own functions and procedures.
VBA using Word This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value
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:4/26/2024 2:28:46 PM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/26/2024 2:28:46 PM