ACCESS TRAINING COURSES ASHTON-UNDER-LYNE
About Enable Technology Ashton-under-lyne Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Ashton-under-lyne. Every Access course can be modified to meet your bespoke requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Countrywide Homes Limited, Cadbury PLC, Nationwide Building Society Limited, South Staffordshire Water PLC, Royal Air Force and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ashton-under-lyne
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Debugging Code
- See Training Course Details...
Understanding the Form Object
Understanding Error Handling
Using the Select Case...End Select Structure
Understanding Expressions and Statements
Understanding the Development Environment
Working with the Application Object
Setting Break Expressions
Working with Events
Creating a Sub Procedure
Why Program in Access?
Understanding Classes and Objects
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Using the Immediate Window to Call Procedures
Understanding Control-of-Flow Structures
Setting Breakpoints
Working with Inline Error Handling
Understanding Errors
Using the Do...Loop Structure
Declaring Variables
Microsoft Access
- 2 day course
- Location: Ashton-under-lyne
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Importing and Exporting Records
- See Training Course Details...
DIY Forms
Creating Queries
Modifying Table Structures
Aggregation Queries
Designing a Lookup Database
Data Validation
Getting to Know Access
Relational Database Design
Modifying Forms
Multi Table Queries
Action Queries
Macro Techniques
Database Wellness
An Introduction to VBA
Creating and Using Macros
Creating a Relational Database
Macros on Forms
Working With Records
Adding Transactional Records
Querying Techniques
Email us about this courses
Other Ashton-under-lyne Enable Technology Training Courses
PL/SQL - Ashton-under-lyne SQL Training Courses
Power BI - Ashton-under-lyne Microsoft Power BI Training Courses
JavaScript Ashton-under-lyne Training Courses
Excel 365 Advanced Ashton-under-lyne Training Courses
SSAS Tabular Ashton-under-lyne Training Courses
Excel 365 Basic Ashton-under-lyne Training Courses