ACCESS TRAINING COURSES MOUNTAIN ASH
About Enable Technology Mountain Ash Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Mountain Ash. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Some of our clients are EDF Energy PLC, Cadbury PLC, DHL Express, Loughborough University, University of Birmingham, Royal Air Force, Birmingham City Council and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mountain Ash
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Understanding the DoCmd Object
Working with Events
Using the CacheSize Property - Optional
Writing an Error-Handling Routine
Working with Methods
Understanding the Order of Events
Setting Break Expressions
Guidelines for use of Branching Structures
Using the Object Browser
Locking Records for Updating
Using the Do...Loop Structure
Using the Immediate Window to Call Procedures
Understanding Constants
Understanding Data Types
Using Intrinsic Constants
Understanding Procedures
Using Message Boxes
Working with Boolean Expressions
Microsoft Access
- 2 day course
- Location: Mountain Ash
- 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 ... Creating and Using Reports
- See Training Course Details...
Creating and Using Forms
Multi Table Queries
Querying Techniques
Adding Records to a Table
Navigation Pane Protection
Creating a Lookup Database
Macro Techniques
Setting Table Relationships
Designing a Lookup Database
Database Wellness
Database Security
Creating a Relational Database
Action Queries
Creating and Using Macros
Aggregation Queries
An Introduction to VBA
Understanding VBA
Importing and Exporting Records
Adding Transactional Records
Modifying Forms
Email us about this courses
Other Mountain Ash Enable Technology Training Courses
Power BI - Mountain Ash Microsoft Power BI Training Courses
VBA Mountain Ash Training Courses
TSQL - Mountain Ash SQL Training Courses
Excel Power Pivot Mountain Ash Training Courses
Power Query - Mountain Ash Excel Training Courses
SSIS Mountain Ash Training Courses