ACCESS TRAINING COURSES WOLVERHAMPTON
About Enable Technology Wolverhampton Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. The Access course could also be scheduled at a socially distanced site near you in Wolverhampton. We are happy to discuss customising the course content should you have particular Access training 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Nationwide Building Society Limited, Boots UK Limited, Queen's Medical Centre Nottingham, Nuclear Engineering Services, Halfords Group PLC, Barclays Bank PLC, Aston University and Birmingham City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wolverhampton
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Handling Errors
Understanding Constants
Understanding the DoCmd Object
Understanding the Err Object
Using Input Boxes
Using the For Each...Next Structure
Working with Inline Error Handling
Guidelines for use of Branching Structures
Specifying a Recordset Cursor Location - Optional
Stepping through Code
Creating a Standard Module
Understanding Data Types
Why Program in Access?
Using the CacheSize Property - Optional
Working with Methods
Understanding the Form Object
Setting Break Expressions
Microsoft Access
- 2 day course
- Location: Wolverhampton
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Multi Table Queries
- See Training Course Details...
Action Queries
Working With Records
Data Validation
Adding Records to a Table
Relational Database Design
Setting Table Relationships
An Introduction to VBA
Getting to Know Access
Modifying Forms
Macros on Forms
Aggregation Queries
Understanding VBA
Using a Navigation Form
Creating Queries
Creating and Using Forms
Modifying Table Structures
Importing and Exporting Records
Database Security
Creating a Relational Database
Creating and Using Macros
Email us about this courses
Other Wolverhampton Enable Technology Training Courses
SSAS Wolverhampton Training Courses
JavaScript - Wolverhampton JavaScript Training Courses
JQuery Mobile Wolverhampton Training Courses
TSQL - Wolverhampton SQL Training Courses
SSAS Tabular - Wolverhampton SQL Server Analysis Services Training Courses
VBA Wolverhampton Training Courses