ACCESS TRAINING COURSES MIDLANDS
About Enable Technology Midlands 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. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in the Midlands. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Wolverhampton City Council, West Bromwich Building Society, Aston University, Keele University, Loughborough University, Lloyds TSB Bank PLC, Carillion PLC and University of Birmingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Midlands
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding Expressions and Statements
- See Training Course Details...
Understanding Objects
Working with Properties
Understanding the Err Object
Considering Variable Scope and Lifetime Together
Using Debugging Tools
Why Program in Access?
Handling Errors
Using the For...Next Structure
Using Input Boxes
Navigating the Access Object Hierarchy
Using the Do...Loop Structure
Working with Methods
Setting Break Expressions
Trapping Errors with the On Error Statement
Writing an Error-Handling Routine
Creating a Function Procedure
Using the With Statement
Working with Variable Scope
Using the Immediate Window to Call Procedures
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: Midlands
- 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 ... Designing a Lookup Database
- See Training Course Details...
Formatting Tables
Creating a Relational Database
Modifying Forms
Creating a Lookup Database
Navigation Pane Protection
Setting Table Relationships
Modifying Table Structures
Using a Navigation Form
Getting to Know Access
Adding Records to a Table
Querying Techniques
Macros on Forms
Creating and Using Macros
An Introduction to VBA
Parameter Queries
Creating Queries
DIY Forms
Data Validation
Sorting and Filtering
Action Queries
Email us about this courses
Other Midlands Enable Technology Training Courses
SSAS Tabular - Midlands SQL Server Analysis Services Training Courses
Data Warehouse - Midlands SQL Training Courses
Report Builder - Midlands SQL Server Reporting Services Training Courses
Excel 365 Advanced - Midlands Excel Training Courses
Excel 365 Intermediate Midlands Training Courses
TSQL Midlands Training Courses