ACCESS TRAINING COURSES CHRISTCHURCH
About Enable Technology Christchurch Access Training Courses
We have a twenty year history of providing skills based Access industry training. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Christchurch. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Wolverhampton City Council, DHL Express, Nuclear Engineering Services, Aston University, Vodafone Group Services, Yell Group PLC, Nationwide Building Society Limited and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Christchurch
- 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 ... Relational Database Design
- See Training Course Details...
Working With Records
Creating and Using Macros
DIY Forms
Getting to Know Access
Using a Navigation Form
Modifying Forms
Designing a Lookup Database
Setting Table Relationships
Formatting Tables
Creating Queries
Understanding VBA
Database Wellness
Data Validation
Querying Techniques
Modifying Table Structures
Creating a Lookup Database
Parameter Queries
An Introduction to VBA
Aggregation Queries
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Christchurch
- 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 ... Working with Variable Lifetime
- See Training Course Details...
Understanding Data Types
Understanding the Err Object
Using the Immediate Window to Call Procedures
Understanding Error Handling
Specifying a Recordset Cursor Location - Optional
Understanding Objects
Using the With Statement
Determining the Value of Expressions
Considering Variable Scope and Lifetime Together
Understanding Recordset Cursor Properties - Optional
Stepping through Code
Understanding Control-of-Flow Structures
Using Break Mode during Run Mode
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Using the For...Next Structure
Understanding Constants
Working with the ADODB Recordset Object
Calling Procedures
Using the If...End If Decision Structures
Email us about this courses
Other Christchurch Enable Technology Training Courses
SSAS Tabular - Christchurch SQL Server Analysis Services Training Courses
Power Query - Christchurch Excel Training Courses
DAX - Christchurch Excel Training Courses
SQL Christchurch Training Courses
Excel Power Pivot Christchurch Training Courses
SSIS - Christchurch SQL Server Integration Services Training Courses