ACCESS TRAINING COURSES HUDDERSFIELD
About Enable Technology Huddersfield Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a socially distanced training location in Huddersfield. We will work with you prior to the course to tailor the Access syllabus to match your 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Royal Air Force, Birmingham City University, Yell Group PLC, West Bromwich Building Society, Queen's Medical Centre Nottingham, Loughborough University, Capita Group PLC and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Huddersfield
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Working With Records
- See Training Course Details...
Aggregation Queries
Sorting and Filtering
Understanding VBA
Parameter Queries
Multi Table Queries
Setting Table Relationships
Database Wellness
Creating and Using Forms
An Introduction to VBA
Creating a Relational Database
Creating and Using Reports
Modifying Table Structures
Getting to Know Access
Creating Queries
Macro Techniques
DIY Forms
Action Queries
Macros on Forms
Using a Navigation Form
Adding Records to a Table
Microsoft Access Programming Using VBA
- 3 day course
- Location: Huddersfield
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Variable Lifetime
- See Training Course Details...
Creating a Standard Module
Understanding Errors
Understanding the Development Environment
Understanding VBA's Error Trapping Options
Debugging Code
Using Expressions, Variables, and Intrinsic Functions
Understanding Recordset Cursor Properties - Optional
Working with the ADODB Recordset Object
Naming Procedures
Locking Records for Updating
Determining the Value of Expressions
Understanding Constants
Using the CacheSize Property - Optional
Working with Variable Scope
Introduction to Programming in Access
Calling Procedures
Email us about this courses
Other Huddersfield Enable Technology Training Courses
DAX Huddersfield Training Courses
JQuery Mobile Huddersfield Training Courses
Oracle SQL Huddersfield Training Courses
JQuery - Huddersfield JavaScript Training Courses
Data Warehouse - Huddersfield SQL Training Courses
Excel 365 Advanced - Huddersfield Excel Training Courses