ACCESS TRAINING COURSES WORCESTERSHIRE
About Enable Technology Worcestershire Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. We can also deliver the Access course at a socially distanced local training venue in Worcestershire. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Norwich Union PLC, Unipart Group, Yell Group PLC, Capita Group PLC, Norfolk Police Constabulary, Carillion PLC, Aston University and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Worcestershire
- 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 ... Working with Variable Scope
- See Training Course Details...
Using the CacheSize Property - Optional
Understanding Collections
Understanding the Order of Events
Using Visual Basic Help
Writing an Error-Handling Routine
Working with Boolean Expressions
Using Expressions, Variables, and Intrinsic Functions
Naming Procedures
Working with the Code Editor
Specifying a Recordset Cursor Type
Using Intrinsic Constants
Considering Variable Scope and Lifetime Together
Locking Records for Updating
Specifying a Recordset Cursor Location - Optional
Working with the ADODB Recordset Object
Understanding Constants
Working with Recordsets
Understanding Control-of-Flow Structures
Using the Object Browser
Microsoft Access
- 2 day course
- Location: Worcestershire
- 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 ... Parameter Queries
- See Training Course Details...
Database Wellness
Action Queries
Aggregation Queries
Modifying Forms
Creating and Using Reports
Getting to Know Access
Querying Techniques
Adding Transactional Records
Creating Queries
Macros on Forms
Creating and Using Macros
Database Security
Understanding VBA
Macro Techniques
Navigation Pane Protection
DIY Forms
Adding Records to a Table
Creating a Relational Database
Using a Navigation Form
Relational Database Design
Email us about this courses
Other Worcestershire Enable Technology Training Courses
DAX Worcestershire Training Courses
Power Query - Worcestershire Excel Training Courses
SSIS Worcestershire Training Courses
JQuery Mobile - Worcestershire JavaScript Training Courses
Oracle SQL - Worcestershire SQL Training Courses
SSAS Tabular - Worcestershire SQL Server Analysis Services Training Courses