ACCESS TRAINING COURSES LLANTRISANT
About Enable Technology Llantrisant Access Training Courses
We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Courses are instructor led and groups sizes small. 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. We are also more than happy to organise a local course at a training location in Llantrisant. The Access syllabus can be modified to accommodate your specific training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norwich Union PLC, Total Telecommunications Limited, Boots UK Limited, Queen's Medical Centre Nottingham, Yell Group PLC, Royal & Sun Alliance Group PLC, South Staffordshire Water PLC and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llantrisant
- 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 ... Setting Break Expressions
- See Training Course Details...
Working with Variable Lifetime
Understanding VBA's Error Trapping Options
Locking Records for Updating
Working with Events
Working with the Code Editor
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Using the Immediate Window to Call Procedures
Understanding Classes and Objects
Organizing Code and Procedures
Working with Variable Scope
Working with Inline Error Handling
Guidelines for use of Branching Structures
Creating a Function Procedure
Using the For Each...Next Structure
Introduction to Programming in Access
Microsoft Access
- 2 day course
- Location: Llantrisant
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating and Using Reports
- See Training Course Details...
Creating a Lookup Database
Sorting and Filtering
Data Validation
Getting to Know Access
Database Wellness
Setting Table Relationships
Modifying Table Structures
Formatting Tables
Adding Transactional Records
An Introduction to VBA
Designing a Lookup Database
Calculations in Queries
Database Security
Macros on Forms
Parameter Queries
Querying Techniques
Creating a Relational Database
Understanding VBA
Action Queries
Macro Techniques
Email us about this courses
Other Llantrisant Enable Technology Training Courses
Excel 365 Advanced - Llantrisant Excel Training Courses
Excel Power Pivot - Llantrisant Excel Training Courses
SSIS Llantrisant Training Courses
Power Query - Llantrisant Excel Training Courses
Oracle SQL - Llantrisant SQL Training Courses
SSRS Llantrisant Training Courses