ACCESS TRAINING COURSES HALIFAX
About Enable Technology Halifax Access Training Courses
We are a company that offers short, practical, Access hands on technology 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. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Halifax. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Fujistu PLC, Countrywide Homes Limited, Keele University, Nuclear Engineering Services, GKN PLC, Norwich Union PLC, Birmingham Heartlands Hospital and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Halifax
- 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 ... Creating and Using Macros
- See Training Course Details...
Adding Records to a Table
Sorting and Filtering
Parameter Queries
Understanding VBA
Modifying Table Structures
DIY Forms
Navigation Pane Protection
Aggregation Queries
Formatting Tables
Using a Navigation Form
Multi Table Queries
An Introduction to VBA
Modifying Forms
Designing a Lookup Database
Getting to Know Access
Working With Records
Creating and Using Reports
Querying Techniques
Action Queries
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Halifax
- 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 ... Understanding the Order of Events
- See Training Course Details...
Understanding Modules
Creating a Sub Procedure
Working with the Code Editor
Understanding Recordset Cursor Properties - Optional
Working with Variable Lifetime
Understanding Collections
Using the CacheSize Property - Optional
Working with Procedures and Functions
Understanding Procedures
Declaring and Creating Object Variables
Using the Do...Loop Structure
Specifying a Recordset Cursor Type
Using the With Statement
Understanding VBA's Error Trapping Options
Why Program in Access?
Working with the Application Object
Handling Errors
Introduction to Programming in Access
Determining the Value of Expressions
Working with Events
Email us about this courses
Other Halifax Enable Technology Training Courses
JQuery Mobile - Halifax JavaScript Training Courses
SSAS Tabular Halifax Training Courses
JQuery - Halifax JavaScript Training Courses
JavaScript Halifax Training Courses
Excel 365 Intermediate - Halifax Excel Training Courses
Excel 365 Basic - Halifax Excel Training Courses