ACCESS TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Access Training Courses
Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in East Midlands. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Birmingham City University, Shell UK Oil Products Ltd, Total Telecommunications Limited, Aston University, Yell Group PLC, University of Birmingham and Homeserve PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: East Midlands
- 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 Recordsets
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Understanding Data Types
Using Debugging Tools
Creating a Function Procedure
Considering Variable Scope and Lifetime Together
Using Message Boxes
Calling Procedures
Using Input Boxes
Creating a Sub Procedure
Understanding the Form Object
Understanding Collections
Introduction to Programming in Access
Working with Variable Lifetime
Understanding Procedures
Using Break Mode during Run Mode
Understanding Expressions and Statements
Using the CacheSize Property - Optional
Microsoft Access
- 2 day course
- Location: East Midlands
- 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 ... DIY Forms
- See Training Course Details...
Importing and Exporting Records
Querying Techniques
Action Queries
Navigation Pane Protection
Aggregation Queries
Parameter Queries
Using a Navigation Form
Formatting Tables
Designing a Lookup Database
Creating a Relational Database
Creating and Using Macros
Macro Techniques
Database Wellness
Calculations in Queries
Getting to Know Access
Macros on Forms
Multi Table Queries
Modifying Table Structures
Adding Transactional Records
An Introduction to VBA
Email us about this courses
Other East Midlands Enable Technology Training Courses
Excel Power Pivot East Midlands Training Courses
DAX East Midlands Training Courses
Excel 365 Intermediate East Midlands Training Courses
SSRS - East Midlands SQL Server Reporting Services Training Courses
SSAS Tabular East Midlands Training Courses
Oracle SQL - East Midlands SQL Training Courses