ACCESS TRAINING COURSES DORCHESTER
About Enable Technology Dorchester Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Dorchester. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Vodafone Group Services, DHL Express, Shell UK Oil Products Ltd, Yell Group PLC, Barclays Bank PLC, Keele University, Aston University and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dorchester
- 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 Error Handling
- See Training Course Details...
Organizing Code and Procedures
Writing an Error-Handling Routine
Understanding the DoCmd Object
Using the Immediate Window to Call Procedures
Working with Methods
Naming Procedures
Using the If...End If Decision Structures
Understanding Collections
Understanding the Form Object
Handling Errors
Understanding Objects
Declaring and Creating Object Variables
Using the For...Next Structure
Using the For Each...Next Structure
Considering Variable Scope and Lifetime Together
Understanding the Err Object
Creating a Function Procedure
Using Message Boxes
Microsoft Access
- 2 day course
- Location: Dorchester
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Designing a Lookup Database
Importing and Exporting Records
Creating and Using Forms
Navigation Pane Protection
Macros on Forms
An Introduction to VBA
Calculations in Queries
Multi Table Queries
Sorting and Filtering
Creating and Using Macros
Understanding VBA
Modifying Forms
Querying Techniques
Database Security
Parameter Queries
Aggregation Queries
Using a Navigation Form
DIY Forms
Creating Queries
Working With Records
Email us about this courses
Other Dorchester Enable Technology Training Courses
Oracle SQL - Dorchester SQL Training Courses
TSQL Dorchester Training Courses
SSAS - Dorchester SQL Server Analysis Services Training Courses
JavaScript Dorchester Training Courses
VBA - Dorchester Excel Training Courses
SSAS Tabular Dorchester Training Courses