ACCESS TRAINING COURSES HALIFAX
About Enable Technology Halifax Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local venue in Halifax. 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Queen's Medical Centre Nottingham, Fujistu PLC, Shell UK Oil Products Ltd, GKN PLC, DHL Express, National Power PLC, Countrywide Homes Limited and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Halifax
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
Data Validation
Aggregation Queries
Getting to Know Access
Using a Navigation Form
Understanding VBA
Parameter Queries
An Introduction to VBA
Creating and Using Forms
Macros on Forms
Formatting Tables
Creating a Lookup Database
Creating and Using Reports
Modifying Table Structures
Multi Table Queries
Calculations in Queries
Importing and Exporting Records
Setting Table Relationships
Designing a Lookup Database
DIY Forms
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Halifax
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Understanding the Err Object
Using Message Boxes
Using Visual Basic Help
Working with Procedures and Functions
Using the CacheSize Property - Optional
Working with Variable Lifetime
Understanding Procedures
Understanding the Form Object
Stepping through Code
Using the If...End If Decision Structures
Understanding Error Handling
Understanding the DoCmd Object
Naming Procedures
Working with the Application Object
Introduction to Programming in Access
Understanding Expressions and Statements
Email us about this courses
Other Halifax Enable Technology Training Courses
SSIS Halifax Training Courses
SSAS Tabular - Halifax SQL Server Analysis Services Training Courses
JQuery Mobile Halifax Training Courses
JavaScript Halifax Training Courses
SSRS - Halifax SQL Server Reporting Services Training Courses
Data Warehouse Halifax Training Courses