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. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local training site. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: National Power PLC, Birmingham City University, Lloyds TSB Bank PLC, Boots UK Limited, Halfords Group PLC, Countrywide Homes Limited, Yell Group PLC and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Milton Keynes
- 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 ... Working with Variable Scope
- See Training Course Details...
Writing an Error-Handling Routine
Using Debugging Tools
Guidelines for use of Branching Structures
Understanding Data Types
Working with Variable Lifetime
Using the Immediate Window to Call Procedures
Introduction to Programming in Access
Understanding the DoCmd Object
Understanding Procedures
Understanding Recordset Cursor Properties - Optional
Understanding the Development Environment
Creating a Sub Procedure
Using the Object Browser
Understanding Classes and Objects
Understanding VBA's Error Trapping Options
Understanding Expressions and Statements
Locking Records for Updating
Working with the ADODB Recordset Object
Understanding the Order of Events
Microsoft Access
- 2 day course
- Location: Milton Keynes
- 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...
Multi Table Queries
Modifying Forms
Modifying Table Structures
Data Validation
Getting to Know Access
Creating and Using Forms
Calculations in Queries
Parameter Queries
Aggregation Queries
Macros on Forms
Adding Records to a Table
Adding Transactional Records
Relational Database Design
Action Queries
Working With Records
Formatting Tables
Database Security
DIY Forms
An Introduction to VBA
Creating a Lookup Database
Email us about this courses
Other Milton Keynes Enable Technology Training Courses
Excel Power Pivot - Milton Keynes Excel Training Courses
DAX - Milton Keynes Excel Training Courses
JQuery Mobile - Milton Keynes JavaScript Training Courses
Data Warehouse - Milton Keynes SQL Training Courses
Oracle SQL - Milton Keynes SQL Training Courses
Power BI - Milton Keynes Microsoft Power BI Training Courses