ACCESS TRAINING COURSES MOUNTAIN ASH
About Enable Technology Mountain Ash Access Training Courses
Enable Technology specialise in succinct skills based Access training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Access training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local socially distanced training site in Mountain Ash. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Homeserve PLC, Canadian High Commission, GKN PLC, Countrywide Homes Limited, Norwich Union PLC, Fujistu PLC, Barclays Bank PLC and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Mountain Ash
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Navigation Pane Protection
Adding Transactional Records
Multi Table Queries
DIY Forms
Using a Navigation Form
Understanding VBA
Parameter Queries
Creating and Using Reports
Relational Database Design
Modifying Table Structures
Querying Techniques
Setting Table Relationships
Macro Techniques
Designing a Lookup Database
Getting to Know Access
Formatting Tables
Modifying Forms
Database Wellness
An Introduction to VBA
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mountain Ash
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Why Program in Access?
- See Training Course Details...
Working with Procedures and Functions
Specifying a Recordset Cursor Location - Optional
Working with Inline Error Handling
Writing an Error-Handling Routine
Locking Records for Updating
Understanding Errors
Using the CacheSize Property - Optional
Working with Recordsets
Understanding VBA's Error Trapping Options
Handling Errors
Working with Variable Scope
Creating a Function Procedure
Using the With Statement
Working with the Code Editor
Understanding the Order of Events
Understanding Control-of-Flow Structures
Using the Immediate Window to Call Procedures
Email us about this courses
Other Mountain Ash Enable Technology Training Courses
Excel 365 Advanced - Mountain Ash Excel Training Courses
Power Query - Mountain Ash Excel Training Courses
VBA Mountain Ash Training Courses
SQL - Mountain Ash SQL Training Courses
Excel 365 Basic Mountain Ash Training Courses
Data Warehouse Mountain Ash Training Courses