ACCESS TRAINING COURSES MALVERN
About Enable Technology Malvern Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain 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 Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite training location in Malvern. Every Access course can be modified to meet your bespoke requirements.
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 Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Barclays Bank PLC, Norfolk Police Constabulary, Royal & Sun Alliance Group PLC, TalkTalk Direct Limited, Cadbury PLC, Countrywide Homes Limited, Canadian High Commission and National Power PLC.
Microsoft Access
- 2 day course
- Location: Malvern
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Aggregation Queries
Adding Transactional Records
Data Validation
Sorting and Filtering
Working With Records
DIY Forms
Creating and Using Forms
Calculations in Queries
An Introduction to VBA
Creating and Using Reports
Creating a Relational Database
Database Wellness
Adding Records to a Table
Creating a Lookup Database
Formatting Tables
Creating and Using Macros
Multi Table Queries
Modifying Forms
Understanding VBA
Database Security
Microsoft Access Programming Using VBA
- 3 day course
- Location: Malvern
- 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 Data Types
- See Training Course Details...
Understanding Classes and Objects
Using the With Statement
Declaring and Creating Object Variables
Understanding Procedures
Understanding Modules
Understanding VBA's Error Trapping Options
Using the If...End If Decision Structures
Debugging Code
Using the Select Case...End Select Structure
Understanding Collections
Understanding the Err Object
Stepping through Code
Setting Break Expressions
Using the Do...Loop Structure
Using Visual Basic Help
Creating a Standard Module
Working with Variable Scope
Working with Events
Email us about this courses
Other Malvern Enable Technology Training Courses
Power Query - Malvern Excel Training Courses
SSRS Malvern Training Courses
Oracle SQL - Malvern SQL Training Courses
SSAS Tabular - Malvern SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Malvern Excel Training Courses
VBA - Malvern Excel Training Courses