ACCESS TRAINING COURSES TREHARRIS
About Enable Technology Treharris Access Training Courses
Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a socially distanced venue near you in Treharris. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Wolverhampton City Council, Queen's Medical Centre Nottingham, DHL Express, Unipart Group, Vodafone Group Services and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Treharris
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Working with the Application Object
- See Training Course Details...
Navigating the Access Object Hierarchy
Declaring and Creating Object Variables
Locking Records for Updating
Handling Errors
Working with Variable Lifetime
Stepping through Code
Working with Methods
Understanding Errors
Working with Variable Scope
Creating a Standard Module
Using the For...Next Structure
Understanding Modules
Organizing Code and Procedures
Working with Recordsets
Using the For Each...Next Structure
Writing an Error-Handling Routine
Using the Do...Loop Structure
Setting Break Expressions
Microsoft Access
- 2 day course
- Location: Treharris
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Creating and Using Macros
- See Training Course Details...
Creating a Relational Database
Using a Navigation Form
DIY Forms
Understanding VBA
Sorting and Filtering
Modifying Table Structures
Navigation Pane Protection
Modifying Forms
Setting Table Relationships
Database Security
Creating and Using Forms
Creating and Using Reports
An Introduction to VBA
Relational Database Design
Designing a Lookup Database
Adding Transactional Records
Action Queries
Importing and Exporting Records
Database Wellness
Aggregation Queries
Email us about this courses
Other Treharris Enable Technology Training Courses
Report Builder - Treharris SQL Server Reporting Services Training Courses
SSIS - Treharris SQL Server Integration Services Training Courses
Oracle SQL Treharris Training Courses
JQuery Mobile Treharris Training Courses
SSRS Treharris Training Courses
JQuery - Treharris JavaScript Training Courses