ACCESS TRAINING COURSES ABERDARE
About Enable Technology Aberdare Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another option is we can organise a local training site in Aberdare. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Keele University, Homeserve PLC, Shell UK Oil Products Ltd, West Bromwich Building Society, Wolverhampton City Council, Royal Air Force, Norwich Union PLC and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Aberdare
- 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 ... Working with the Application Object
- See Training Course Details...
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the For Each...Next Structure
Controlling Program Execution
Using Intrinsic Constants
Working with Inline Error Handling
Understanding Constants
Handling Errors
Understanding VBA's Error Trapping Options
Understanding Expressions and Statements
Understanding Collections
Understanding the Development Environment
Using Intrinsic Functions
Using the Object Browser
Understanding Recordset Cursor Properties - Optional
Understanding Error Handling
Guidelines for use of Branching Structures
Microsoft Access
- 2 day course
- Location: Aberdare
- 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 ... Data Validation
- See Training Course Details...
Working With Records
Creating Queries
Navigation Pane Protection
An Introduction to VBA
Formatting Tables
Database Wellness
Using a Navigation Form
Adding Records to a Table
Creating a Relational Database
Querying Techniques
Modifying Table Structures
Action Queries
Macro Techniques
Adding Transactional Records
Creating and Using Macros
Creating and Using Forms
Setting Table Relationships
DIY Forms
Relational Database Design
Multi Table Queries
Email us about this courses
Other Aberdare Enable Technology Training Courses
Power BI Aberdare Training Courses
Report Builder Aberdare Training Courses
PL/SQL - Aberdare SQL Training Courses
Excel Power Pivot - Aberdare Excel Training Courses
Power Query - Aberdare Excel Training Courses
Excel 365 Advanced Aberdare Training Courses