ACCESS TRAINING COURSES MAESTEG
About Enable Technology Maesteg Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Maesteg. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Total Telecommunications Limited, Loughborough University, DHL Express, Aston University, West Bromwich Building Society, TalkTalk Direct Limited, Norwich Union PLC and Wolverhampton City Council.
Microsoft Access
- 2 day course
- Location: Maesteg
- 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 ... Data Validation
- See Training Course Details...
Formatting Tables
Sorting and Filtering
Creating a Lookup Database
Using a Navigation Form
Macros on Forms
Adding Records to a Table
Modifying Table Structures
Designing a Lookup Database
Action Queries
Database Wellness
Creating and Using Forms
Macro Techniques
Multi Table Queries
Aggregation Queries
Getting to Know Access
Parameter Queries
Navigation Pane Protection
Working With Records
Modifying Forms
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Maesteg
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Setting Break Expressions
- See Training Course Details...
Understanding Error Handling
Creating a Standard Module
Understanding Classes and Objects
Working with the Application Object
Introduction to Programming in Access
Working with Boolean Expressions
Understanding Recordset Cursor Properties - Optional
Understanding the Err Object
Using the For Each...Next Structure
Trapping Errors with the On Error Statement
Understanding Modules
Specifying a Recordset Cursor Type
Using Break Mode during Run Mode
Determining the Value of Expressions
Understanding Data Types
Why Program in Access?
Working with Variable Scope
Declaring Variables
Understanding the Order of Events
Using Input Boxes
Email us about this courses
Other Maesteg Enable Technology Training Courses
Oracle SQL Maesteg Training Courses
JQuery Maesteg Training Courses
DAX - Maesteg Excel Training Courses
Report Builder Maesteg Training Courses
SSIS - Maesteg SQL Server Integration Services Training Courses
PL/SQL - Maesteg SQL Training Courses