ACCESS TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. 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 provide instructor led training coupled with hands on training. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Wolverhampton City Council, Loughborough University, University of Birmingham, Norwich Union PLC, Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Royal & Sun Alliance Group PLC and Capita Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stratford Upon Avon
- 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 ... Debugging Code
- See Training Course Details...
Using Break Mode during Run Mode
Using Intrinsic Functions
Considering Variable Scope and Lifetime Together
Locking Records for Updating
Creating a Function Procedure
Understanding Collections
Trapping Errors with the On Error Statement
Specifying a Recordset Cursor Type
Understanding Classes and Objects
Working with the Code Editor
Understanding Data Types
Working with Recordsets
Using Message Boxes
Setting Breakpoints
Understanding Constants
Handling Errors
Introduction to Programming in Access
Working with Events
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Adding Records to a Table
- See Training Course Details...
Setting Table Relationships
An Introduction to VBA
Using a Navigation Form
Data Validation
Formatting Tables
Navigation Pane Protection
Working With Records
Database Wellness
Modifying Table Structures
Creating a Lookup Database
Adding Transactional Records
Querying Techniques
DIY Forms
Relational Database Design
Calculations in Queries
Sorting and Filtering
Modifying Forms
Action Queries
Aggregation Queries
Creating Queries
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
SSAS - Stratford Upon Avon SQL Server Analysis Services Training Courses
JQuery - Stratford Upon Avon JavaScript Training Courses
SSAS Tabular Stratford Upon Avon Training Courses
VBA Stratford Upon Avon Training Courses
Power Query - Stratford Upon Avon Excel Training Courses
Excel Power Pivot - Stratford Upon Avon Excel Training Courses