ACCESS TRAINING COURSES BROMSGROVE
About Enable Technology Bromsgrove Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Access training courses onsite at your premises. The Access course could also be scheduled at a socially distanced site near you in Bromsgrove. All Access courses can be customised to meet your particular requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Shell UK Oil Products Ltd, Royal Air Force, Countrywide Homes Limited, Halfords Group PLC, Total Telecommunications Limited, Nuclear Engineering Services, Barclays Bank PLC and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Bromsgrove
- 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 ... Formatting Tables
- See Training Course Details...
Modifying Forms
Creating Queries
DIY Forms
Creating and Using Reports
Creating a Lookup Database
Database Security
Working With Records
Creating and Using Forms
Multi Table Queries
Modifying Table Structures
Sorting and Filtering
Macro Techniques
Relational Database Design
Setting Table Relationships
Database Wellness
Navigation Pane Protection
Macros on Forms
Aggregation Queries
Designing a Lookup Database
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bromsgrove
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Expressions and Statements
- See Training Course Details...
Understanding Classes and Objects
Handling Errors
Controlling Program Execution
Working with the Code Editor
Using Debugging Tools
Understanding Procedures
Specifying a Recordset Cursor Type
Understanding Collections
Working with the ADODB Recordset Object
Understanding the Order of Events
Using Break Mode during Run Mode
Working with Variable Scope
Working with the Application Object
Navigating the Access Object Hierarchy
Understanding Errors
Creating a Standard Module
Writing an Error-Handling Routine
Understanding the DoCmd Object
Email us about this courses
Other Bromsgrove Enable Technology Training Courses
JQuery - Bromsgrove JavaScript Training Courses
Excel 365 Advanced - Bromsgrove Excel Training Courses
SQL Bromsgrove Training Courses
SSAS Bromsgrove Training Courses
Excel Power Pivot Bromsgrove Training Courses
Oracle SQL Bromsgrove Training Courses