ACCESS TRAINING COURSES KEIGHLEY
About Enable Technology Keighley Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each Access training participant with learning resources which they can refer to post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. The Access course could also be scheduled at a socially distanced site near you in Keighley. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Loughborough University, Total Telecommunications Limited, Countrywide Homes Limited, Boots UK Limited, Dollond & Aitchison Limited, Homeserve PLC, DHL Express and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Keighley
- 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 ... Data Validation
- See Training Course Details...
Understanding VBA
Creating and Using Forms
An Introduction to VBA
Adding Records to a Table
Relational Database Design
Database Wellness
Multi Table Queries
Designing a Lookup Database
Modifying Forms
Calculations in Queries
Sorting and Filtering
Parameter Queries
Creating and Using Macros
Working With Records
Modifying Table Structures
Database Security
Macros on Forms
Navigation Pane Protection
Creating and Using Reports
Macro Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Keighley
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Stepping through Code
Understanding Control-of-Flow Structures
Specifying a Recordset Cursor Location - Optional
Understanding the Order of Events
Considering Variable Scope and Lifetime Together
Writing an Error-Handling Routine
Using the If...End If Decision Structures
Trapping Errors with the On Error Statement
Understanding the Form Object
Working with Boolean Expressions
Understanding Modules
Working with the Code Editor
Using Intrinsic Functions
Handling Errors
Understanding the Development Environment
Understanding Errors
Understanding Error Handling
Email us about this courses
Other Keighley Enable Technology Training Courses
Report Builder Keighley Training Courses
JQuery - Keighley JavaScript Training Courses
Excel 365 Intermediate Keighley Training Courses
SSAS Tabular Keighley Training Courses
Data Warehouse - Keighley SQL Training Courses
SSRS - Keighley SQL Server Reporting Services Training Courses