ACCESS TRAINING COURSES NUNEATON
About Enable Technology Nuneaton Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Access training materials which they keep after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. Alternatively we could schedule a course at a local socially distanced venue in Nuneaton. All Access courses can be customised to meet your particular requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Vodafone Group Services, Yell Group PLC, Carillion PLC, National Power PLC, University of Birmingham, Shell UK Oil Products Ltd, Keele University and TalkTalk Direct Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Nuneaton
- 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 ... Calling Procedures
- See Training Course Details...
Using the With Statement
Understanding Procedures
Working with the Code Editor
Writing an Error-Handling Routine
Using the CacheSize Property - Optional
Using Intrinsic Constants
Understanding Constants
Using the Object Browser
Guidelines for use of Branching Structures
Determining the Value of Expressions
Understanding Modules
Organizing Code and Procedures
Creating a Function Procedure
Understanding Collections
Handling Errors
Understanding Recordset Cursor Properties - Optional
Understanding the Development Environment
Setting Break Expressions
Working with Inline Error Handling
Microsoft Access
- 2 day course
- Location: Nuneaton
- 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 ... Getting to Know Access
- See Training Course Details...
Working With Records
DIY Forms
Designing a Lookup Database
Understanding VBA
Database Wellness
An Introduction to VBA
Adding Records to a Table
Creating and Using Macros
Aggregation Queries
Data Validation
Creating a Relational Database
Creating Queries
Modifying Table Structures
Adding Transactional Records
Calculations in Queries
Querying Techniques
Database Security
Formatting Tables
Creating a Lookup Database
Creating and Using Forms
Email us about this courses
Other Nuneaton Enable Technology Training Courses
DAX - Nuneaton Excel Training Courses
Excel 365 Basic - Nuneaton Excel Training Courses
TSQL - Nuneaton SQL Training Courses
JavaScript - Nuneaton JavaScript Training Courses
Report Builder Nuneaton Training Courses
Power BI - Nuneaton Microsoft Power BI Training Courses