ACCESS TRAINING COURSES MIDLANDS
About Enable Technology Midlands Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in the Midlands. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Our clients include: Cadbury PLC, Loughborough University, Capita Group PLC, Homeserve PLC, University of Birmingham, Royal Air Force, Birmingham City University and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Midlands
- Telephone on 01952 938014
- 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 ... An Introduction to VBA
- See Training Course Details...
Creating and Using Macros
Getting to Know Access
Designing a Lookup Database
Calculations in Queries
Creating a Relational Database
Setting Table Relationships
DIY Forms
Parameter Queries
Using a Navigation Form
Modifying Table Structures
Database Wellness
Creating Queries
Relational Database Design
Adding Records to a Table
Macros on Forms
Multi Table Queries
Macro Techniques
Importing and Exporting Records
Creating a Lookup Database
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Midlands
- 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 ... Organizing Code and Procedures
- See Training Course Details...
Determining the Value of Expressions
Using the Select Case...End Select Structure
Using Intrinsic Constants
Calling Procedures
Naming Procedures
Handling Errors
Understanding Modules
Working with Variable Scope
Working with Procedures and Functions
Navigating the Access Object Hierarchy
Using Debugging Tools
Specifying a Recordset Cursor Location - Optional
Working with Boolean Expressions
Declaring Variables
Understanding the Form Object
Stepping through Code
Using the CacheSize Property - Optional
Working with the Code Editor
Email us about this courses
Other Midlands Enable Technology Training Courses
PL/SQL - Midlands SQL Training Courses
SQL - Midlands SQL Training Courses
SSAS Tabular - Midlands SQL Server Analysis Services Training Courses
SSIS Midlands Training Courses
VBA Midlands Training Courses
Excel Power Pivot - Midlands Excel Training Courses