ACCESS TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in East Midlands. Every Access course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: South Staffordshire Water PLC, Capita Group PLC, Birmingham Heartlands Hospital, Halfords Group PLC, National Power PLC, Royal & Sun Alliance Group PLC, Yell Group PLC and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: East Midlands
- 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 ... Creating and Using Reports
- See Training Course Details...
Creating Queries
Macro Techniques
Creating a Lookup Database
Working With Records
Adding Records to a Table
DIY Forms
Getting to Know Access
Database Security
Modifying Forms
Relational Database Design
Database Wellness
Understanding VBA
Formatting Tables
Navigation Pane Protection
Action Queries
Designing a Lookup Database
Multi Table Queries
Setting Table Relationships
Data Validation
Adding Transactional Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: East Midlands
- 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 ... Understanding Modules
- See Training Course Details...
Handling Errors
Declaring and Creating Object Variables
Using the For Each...Next Structure
Understanding the Development Environment
Using Break Mode during Run Mode
Understanding Errors
Organizing Code and Procedures
Understanding Data Types
Guidelines for use of Branching Structures
Understanding Error Handling
Using the Select Case...End Select Structure
Understanding Constants
Using the If...End If Decision Structures
Setting Break Expressions
Working with Recordsets
Stepping through Code
Email us about this courses
Other East Midlands Enable Technology Training Courses
JQuery Mobile - East Midlands JavaScript Training Courses
Excel 365 Intermediate East Midlands Training Courses
SSRS - East Midlands SQL Server Reporting Services Training Courses
SQL - East Midlands SQL Training Courses
SSIS - East Midlands SQL Server Integration Services Training Courses
TSQL East Midlands Training Courses