ACCESS TRAINING COURSES LEICESTERSHIRE
About Enable Technology Leicestershire Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. We can also deliver the Access course at a socially distanced local training venue in Leicestershire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Lloyds TSB Bank PLC, EDF Energy PLC, Nationwide Building Society Limited, Birmingham Heartlands Hospital, West Bromwich Building Society, Royal & Sun Alliance Group PLC, University of Birmingham and Homeserve PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leicestershire
- 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 ... Working with Variable Lifetime
- See Training Course Details...
Understanding Recordset Cursor Properties - Optional
Working with Properties
Using the With Statement
Working with the Application Object
Working with Recordsets
Organizing Code and Procedures
Understanding Modules
Trapping Errors with the On Error Statement
Creating a Sub Procedure
Using Expressions, Variables, and Intrinsic Functions
Understanding the Development Environment
Understanding Procedures
Understanding Classes and Objects
Working with Inline Error Handling
Understanding Objects
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Understanding Data Types
Using Debugging Tools
Microsoft Access
- 2 day course
- Location: Leicestershire
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Creating Queries
Action Queries
Creating and Using Reports
Adding Transactional Records
Creating and Using Macros
Importing and Exporting Records
Aggregation Queries
Database Wellness
Navigation Pane Protection
Macros on Forms
Working With Records
Understanding VBA
Formatting Tables
An Introduction to VBA
Creating a Relational Database
Modifying Forms
Creating a Lookup Database
DIY Forms
Relational Database Design
Using a Navigation Form
Email us about this courses
Other Leicestershire Enable Technology Training Courses
VBA Leicestershire Training Courses
JavaScript Leicestershire Training Courses
Data Warehouse - Leicestershire SQL Training Courses
Excel 365 Basic Leicestershire Training Courses
JQuery - Leicestershire JavaScript Training Courses
SSAS Tabular - Leicestershire SQL Server Analysis Services Training Courses