ACCESS TRAINING COURSES EAST MIDLANDS
About Enable Technology East Midlands Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in East Midlands. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Loughborough University, Cadbury PLC, South Staffordshire Water PLC, Lloyds TSB Bank PLC, Barclays Bank PLC, TalkTalk Direct Limited, West Bromwich Building Society and Aston University.
Microsoft Access
- 2 day course
- Location: East 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 ... Working With Records
- See Training Course Details...
Database Security
Creating a Lookup Database
Creating and Using Macros
Macros on Forms
Navigation Pane Protection
Querying Techniques
Adding Records to a Table
Designing a Lookup Database
DIY Forms
Multi Table Queries
Formatting Tables
Modifying Table Structures
Adding Transactional Records
Getting to Know Access
Calculations in Queries
Using a Navigation Form
Modifying Forms
Data Validation
Macro Techniques
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: East Midlands
- 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 ... Locking Records for Updating
- See Training Course Details...
Specifying a Recordset Cursor Type
Debugging Code
Writing an Error-Handling Routine
Using Input Boxes
Using Message Boxes
Working with Inline Error Handling
Working with Recordsets
Guidelines for use of Branching Structures
Using the CacheSize Property - Optional
Understanding Control-of-Flow Structures
Understanding Expressions and Statements
Understanding the Err Object
Understanding Collections
Stepping through Code
Navigating the Access Object Hierarchy
Naming Procedures
Handling Errors
Email us about this courses
Other East Midlands Enable Technology Training Courses
SSAS Tabular East Midlands Training Courses
Oracle SQL - East Midlands SQL Training Courses
Power BI - East Midlands Microsoft Power BI Training Courses
JavaScript East Midlands Training Courses
JQuery Mobile East Midlands Training Courses
SSIS East Midlands Training Courses