ACCESS TRAINING COURSES MOLD
About Enable Technology Mold Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training Access resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Mold. Every Access course can be modified to meet your bespoke requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Birmingham City University, Royal Air Force, Birmingham City Council, Countrywide Homes Limited, West Bromwich Building Society, Shell UK Oil Products Ltd, Cadbury PLC and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mold
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Objects
- See Training Course Details...
Understanding the Development Environment
Navigating the Access Object Hierarchy
Working with Variable Scope
Writing an Error-Handling Routine
Working with the Code Editor
Understanding Modules
Creating a Function Procedure
Working with the ADODB Recordset Object
Why Program in Access?
Understanding the DoCmd Object
Creating a Standard Module
Using Intrinsic Constants
Debugging Code
Using the Do...Loop Structure
Specifying a Recordset Cursor Type
Working with Recordsets
Introduction to Programming in Access
Using the If...End If Decision Structures
Understanding Error Handling
Understanding the Order of Events
Microsoft Access
- 2 day course
- Location: Mold
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Creating and Using Forms
Calculations in Queries
Database Security
Adding Transactional Records
Creating a Lookup Database
Working With Records
Action Queries
Parameter Queries
Navigation Pane Protection
Macro Techniques
Multi Table Queries
Data Validation
Using a Navigation Form
DIY Forms
Creating and Using Macros
Modifying Table Structures
An Introduction to VBA
Aggregation Queries
Relational Database Design
Database Wellness
Email us about this courses
Other Mold Enable Technology Training Courses
Power Query Mold Training Courses
VBA Mold Training Courses
Excel 365 Basic Mold Training Courses
Data Warehouse - Mold SQL Training Courses
SQL Mold Training Courses
DAX - Mold Excel Training Courses