ACCESS TRAINING COURSES WARWICKSHIRE
About Enable Technology Warwickshire Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a local training venue in Warwickshire. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Lloyds TSB Bank PLC, TalkTalk Direct Limited, Birmingham Heartlands Hospital, Carillion PLC, Dollond & Aitchison Limited, Total Telecommunications Limited, Canadian High Commission and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Warwickshire
- 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 ... Creating Queries
- See Training Course Details...
Modifying Table Structures
Using a Navigation Form
Working With Records
Multi Table Queries
Formatting Tables
Creating and Using Reports
Database Wellness
Database Security
Calculations in Queries
Getting to Know Access
An Introduction to VBA
Adding Records to a Table
Data Validation
Aggregation Queries
Creating and Using Forms
Designing a Lookup Database
Creating a Lookup Database
Creating a Relational Database
DIY Forms
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warwickshire
- 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 ... Understanding the Order of Events
- See Training Course Details...
Debugging Code
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Working with Variable Scope
Using the For...Next Structure
Considering Variable Scope and Lifetime Together
Using Input Boxes
Working with the Application Object
Working with Inline Error Handling
Working with the ADODB Recordset Object
Locking Records for Updating
Understanding Classes and Objects
Using the Select Case...End Select Structure
Guidelines for use of Branching Structures
Creating a Standard Module
Understanding VBA's Error Trapping Options
Understanding Errors
Working with the Code Editor
Email us about this courses
Other Warwickshire Enable Technology Training Courses
Data Warehouse - Warwickshire SQL Training Courses
JavaScript Warwickshire Training Courses
Excel Power Pivot - Warwickshire Excel Training Courses
SQL - Warwickshire SQL Training Courses
TSQL Warwickshire Training Courses
Excel 365 Advanced Warwickshire Training Courses