ACCESS TRAINING COURSES TELFORD
About Enable Technology Telford Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Telford. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: National Power PLC, University of Birmingham, Lloyds TSB Bank PLC, Cadbury PLC, Boots UK Limited, Fujistu PLC, Canadian High Commission and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Telford
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Setting Break Expressions
- See Training Course Details...
Using the CacheSize Property - Optional
Using the Select Case...End Select Structure
Understanding Control-of-Flow Structures
Working with Procedures and Functions
Understanding Errors
Understanding Objects
Understanding Procedures
Considering Variable Scope and Lifetime Together
Using the With Statement
Working with Variable Scope
Working with Inline Error Handling
Using the For...Next Structure
Creating a Sub Procedure
Understanding Constants
Understanding Error Handling
Using Intrinsic Functions
Working with Properties
Working with the ADODB Recordset Object
Working with Recordsets
Using the For Each...Next Structure
Microsoft Access
- 2 day course
- Location: Telford
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Setting Table Relationships
- See Training Course Details...
Macro Techniques
Creating Queries
Macros on Forms
Relational Database Design
An Introduction to VBA
Getting to Know Access
Aggregation Queries
Navigation Pane Protection
Creating a Relational Database
Adding Transactional Records
Understanding VBA
Database Security
Working With Records
Database Wellness
Adding Records to a Table
DIY Forms
Creating and Using Reports
Parameter Queries
Creating and Using Macros
Sorting and Filtering
Email us about this courses
Other Telford Enable Technology Training Courses
SQL Telford Training Courses
SSRS - Telford SQL Server Reporting Services Training Courses
SSIS - Telford SQL Server Integration Services Training Courses
JQuery Mobile Telford Training Courses
Power BI Telford Training Courses
Oracle SQL Telford Training Courses