ACCESS TRAINING COURSES TEWKESBURY
About Enable Technology Tewkesbury Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Tewkesbury. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Total Telecommunications Limited, Queen's Medical Centre Nottingham, Wolverhampton City Council, Norwich Union PLC, Keele University and Countrywide Homes Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tewkesbury
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Classes and Objects
- See Training Course Details...
Using Visual Basic Help
Understanding the Order of Events
Specifying a Recordset Cursor Location - Optional
Working with Variable Lifetime
Understanding Errors
Understanding the Development Environment
Working with Events
Locking Records for Updating
Controlling Program Execution
Using the Do...Loop Structure
Determining the Value of Expressions
Introduction to Programming in Access
Using Expressions, Variables, and Intrinsic Functions
Understanding Data Types
Why Program in Access?
Calling Procedures
Writing an Error-Handling Routine
Using Break Mode during Run Mode
Understanding Collections
Microsoft Access
- 2 day course
- Location: Tewkesbury
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Creating and Using Macros
Setting Table Relationships
Sorting and Filtering
Creating and Using Reports
Multi Table Queries
Adding Records to a Table
Understanding VBA
Using a Navigation Form
Creating Queries
Modifying Forms
Getting to Know Access
Creating a Lookup Database
An Introduction to VBA
Action Queries
DIY Forms
Working With Records
Macros on Forms
Creating a Relational Database
Relational Database Design
Parameter Queries
Email us about this courses
Other Tewkesbury Enable Technology Training Courses
Power Query - Tewkesbury Excel Training Courses
JavaScript Tewkesbury Training Courses
SSAS Tabular - Tewkesbury SQL Server Analysis Services Training Courses
JQuery - Tewkesbury JavaScript Training Courses
SSRS Tewkesbury Training Courses
PL/SQL - Tewkesbury SQL Training Courses