ACCESS TRAINING COURSES WARWICKSHIRE
About Enable Technology Warwickshire Access Training Courses
We have a twenty year history of providing skills based Access industry training. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a training location in Warwickshire. 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.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Nationwide Building Society Limited, Cadbury PLC, West Bromwich Building Society, Fujistu PLC, Boots UK Limited, Homeserve PLC, Norwich Union PLC and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Warwickshire
- 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 ... Designing a Lookup Database
- See Training Course Details...
Adding Records to a Table
Querying Techniques
Creating a Relational Database
Getting to Know Access
Working With Records
Creating Queries
Multi Table Queries
Adding Transactional Records
Creating and Using Forms
Data Validation
Formatting Tables
Relational Database Design
Macro Techniques
Understanding VBA
DIY Forms
Database Wellness
Calculations in Queries
Macros on Forms
Action Queries
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warwickshire
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Working with the Code Editor
Working with Variable Scope
Understanding Procedures
Using the For...Next Structure
Writing an Error-Handling Routine
Guidelines for use of Branching Structures
Understanding the Err Object
Using the CacheSize Property - Optional
Understanding Expressions and Statements
Trapping Errors with the On Error Statement
Naming Procedures
Working with Events
Navigating the Access Object Hierarchy
Working with Inline Error Handling
Understanding the DoCmd Object
Understanding Objects
Understanding Collections
Understanding the Order of Events
Understanding VBA's Error Trapping Options
Calling Procedures
Email us about this courses
Other Warwickshire Enable Technology Training Courses
VBA Warwickshire Training Courses
Data Warehouse Warwickshire Training Courses
JQuery Warwickshire Training Courses
Report Builder - Warwickshire SQL Server Reporting Services Training Courses
Power Query - Warwickshire Excel Training Courses
SSAS Tabular Warwickshire Training Courses