ACCESS TRAINING COURSES CHELTENHAM
About Enable Technology Cheltenham Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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 supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a venue near you in Cheltenham. All Access courses can be customised to meet your particular requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time 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 Yell Group PLC, Barclays Bank PLC, Nationwide Building Society Limited, Nuclear Engineering Services, Birmingham Heartlands Hospital, Queen's Medical Centre Nottingham, Wolverhampton City Council and National Power PLC.
Microsoft Access
- 2 day course
- Location: Cheltenham
- 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...
Setting Table Relationships
Creating Queries
Creating and Using Macros
Adding Transactional Records
Action Queries
Relational Database Design
Aggregation Queries
Database Wellness
Working With Records
Creating a Relational Database
Adding Records to a Table
Creating and Using Forms
Modifying Table Structures
Database Security
Modifying Forms
Calculations in Queries
Querying Techniques
Importing and Exporting Records
Using a Navigation Form
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cheltenham
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Using the Do...Loop Structure
- See Training Course Details...
Debugging Code
Stepping through Code
Trapping Errors with the On Error Statement
Working with Boolean Expressions
Working with Properties
Understanding the Err Object
Calling Procedures
Understanding Error Handling
Understanding Objects
Understanding Modules
Controlling Program Execution
Navigating the Access Object Hierarchy
Locking Records for Updating
Understanding the Form Object
Creating a Standard Module
Using the For Each...Next Structure
Specifying a Recordset Cursor Location - Optional
Introduction to Programming in Access
Working with Recordsets
Understanding Procedures
Email us about this courses
Other Cheltenham Enable Technology Training Courses
SSRS - Cheltenham SQL Server Reporting Services Training Courses
SQL - Cheltenham SQL Training Courses
Power Query Cheltenham Training Courses
JavaScript - Cheltenham JavaScript Training Courses
PL/SQL Cheltenham Training Courses
Oracle SQL - Cheltenham SQL Training Courses