ACCESS TRAINING COURSES CARLISLE
About Enable Technology Carlisle Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Carlisle. All Access courses can be customised to meet your particular requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham Heartlands Hospital, University of Birmingham, Nationwide Building Society Limited, Aston University, Countrywide Homes Limited, Canadian High Commission, Unipart Group and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Carlisle
- 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 ... Creating and Using Reports
- See Training Course Details...
Macros on Forms
Macro Techniques
Relational Database Design
Calculations in Queries
Creating a Relational Database
Creating a Lookup Database
Database Wellness
Modifying Forms
Creating and Using Forms
Modifying Table Structures
Querying Techniques
Adding Transactional Records
Multi Table Queries
Data Validation
Action Queries
Creating Queries
Formatting Tables
Creating and Using Macros
Navigation Pane Protection
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Carlisle
- 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 ... Determining the Value of Expressions
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Creating a Sub Procedure
Working with Properties
Considering Variable Scope and Lifetime Together
Understanding Constants
Using Message Boxes
Working with Variable Lifetime
Understanding Errors
Understanding the Form Object
Using the For...Next Structure
Understanding the Err Object
Introduction to Programming in Access
Controlling Program Execution
Using the Select Case...End Select Structure
Using the With Statement
Understanding the Order of Events
Setting Break Expressions
Handling Errors
Email us about this courses
Other Carlisle Enable Technology Training Courses
SSAS - Carlisle SQL Server Analysis Services Training Courses
Power Query Carlisle Training Courses
TSQL Carlisle Training Courses
PL/SQL Carlisle Training Courses
JQuery Mobile Carlisle Training Courses
Excel 365 Basic - Carlisle Excel Training Courses