ACCESS TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester Access Training Courses
We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology training courses are delivered as instructor led courses. 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. If you prefer we can offer an offsite training location in Gloucester. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Royal & Sun Alliance Group PLC, Norwich Union PLC, Aston University, DHL Express, University of Birmingham, TalkTalk Direct Limited, Keele University and Birmingham City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gloucester
- 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 ... Working with the Code Editor
- See Training Course Details...
Setting Break Expressions
Understanding Recordset Cursor Properties - Optional
Trapping Errors with the On Error Statement
Navigating the Access Object Hierarchy
Considering Variable Scope and Lifetime Together
Understanding Collections
Working with Events
Why Program in Access?
Working with Variable Scope
Understanding Classes and Objects
Using the For Each...Next Structure
Understanding the DoCmd Object
Writing an Error-Handling Routine
Determining the Value of Expressions
Working with Procedures and Functions
Understanding Errors
Using the For...Next Structure
Setting Breakpoints
Microsoft Access
- 2 day course
- Location: Gloucester
- 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 ... Database Security
- See Training Course Details...
Formatting Tables
Adding Records to a Table
Creating and Using Forms
Adding Transactional Records
Parameter Queries
Working With Records
Navigation Pane Protection
Multi Table Queries
Designing a Lookup Database
Modifying Table Structures
Importing and Exporting Records
Creating a Lookup Database
Database Wellness
Relational Database Design
An Introduction to VBA
Using a Navigation Form
Creating Queries
Querying Techniques
Creating a Relational Database
Aggregation Queries
Email us about this courses
Other Gloucester Enable Technology Training Courses
SSAS - Gloucester SQL Server Analysis Services Training Courses
Oracle SQL - Gloucester SQL Training Courses
VBA Gloucester Training Courses
Report Builder - Gloucester SQL Server Reporting Services Training Courses
Excel 365 Advanced - Gloucester Excel Training Courses
TSQL - Gloucester SQL Training Courses