ACCESS TRAINING COURSES MILTON KEYNES
About Enable Technology Milton Keynes Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local venue in Milton Keynes. We are happy to modify the Access syllabus to match your teams training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Capita Group PLC, Dollond & Aitchison Limited, Halfords Group PLC, Unipart Group, Carillion PLC, Yell Group PLC, Shell UK Oil Products Ltd and Birmingham City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milton Keynes
- Telephone on 01952 938014
- 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 ... Creating a Sub Procedure
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Working with Variable Lifetime
Understanding the Development Environment
Understanding Classes and Objects
Considering Variable Scope and Lifetime Together
Working with the Code Editor
Using the For...Next Structure
Declaring and Creating Object Variables
Using the CacheSize Property - Optional
Naming Procedures
Understanding Recordset Cursor Properties - Optional
Setting Break Expressions
Understanding the DoCmd Object
Using Message Boxes
Organizing Code and Procedures
Using the For Each...Next Structure
Using Debugging Tools
Understanding Error Handling
Microsoft Access
- 2 day course
- Location: Milton Keynes
- 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 ... Sorting and Filtering
- See Training Course Details...
Navigation Pane Protection
Calculations in Queries
Aggregation Queries
Creating and Using Reports
Macros on Forms
Understanding VBA
Working With Records
Modifying Table Structures
Getting to Know Access
Action Queries
Parameter Queries
Creating a Relational Database
Macro Techniques
Creating Queries
DIY Forms
Database Wellness
Formatting Tables
Adding Transactional Records
Database Security
Multi Table Queries
Email us about this courses
Other Milton Keynes Enable Technology Training Courses
SSAS Tabular - Milton Keynes SQL Server Analysis Services Training Courses
Report Builder Milton Keynes Training Courses
Power BI - Milton Keynes Microsoft Power BI Training Courses
Excel 365 Intermediate Milton Keynes Training Courses
Power Query - Milton Keynes Excel Training Courses
PL/SQL - Milton Keynes SQL Training Courses