ACCESS TRAINING COURSES WALES
About Enable Technology Wales Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite socially distanced training location in Wales. We will work with you prior to the course to tailor the Access syllabus to match your 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.
We have operated primarily in the West Midlands for twenty years. Our clients include: EDF Energy PLC, Lloyds TSB Bank PLC, Yell Group PLC, Norfolk Police Constabulary, University of Birmingham, Keele University, Countrywide Homes Limited and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wales
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Objects
- See Training Course Details...
Using the Immediate Window to Call Procedures
Controlling Program Execution
Working with Methods
Understanding Modules
Using the For...Next Structure
Understanding the Err Object
Understanding Error Handling
Understanding Data Types
Debugging Code
Creating a Sub Procedure
Working with Events
Introduction to Programming in Access
Setting Break Expressions
Considering Variable Scope and Lifetime Together
Locking Records for Updating
Using the If...End If Decision Structures
Creating a Function Procedure
Using the With Statement
Calling Procedures
Microsoft Access
- 2 day course
- Location: Wales
- 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 ... Formatting Tables
- See Training Course Details...
Macro Techniques
Aggregation Queries
Working With Records
Understanding VBA
Creating Queries
Adding Transactional Records
Data Validation
Database Wellness
Creating a Relational Database
DIY Forms
Creating and Using Forms
Using a Navigation Form
Setting Table Relationships
Adding Records to a Table
An Introduction to VBA
Querying Techniques
Getting to Know Access
Navigation Pane Protection
Macros on Forms
Modifying Forms
Email us about this courses
Other Wales Enable Technology Training Courses
Excel 365 Advanced - Wales Excel Training Courses
Power Query Wales Training Courses
SQL - Wales SQL Training Courses
Excel Power Pivot - Wales Excel Training Courses
JavaScript Wales Training Courses
SSAS Tabular Wales Training Courses