ACCESS TRAINING COURSES TELFORD
About Enable Technology Telford Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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 can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We are also more than happy to organise a local course at a training location in Telford. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Loughborough University, Wolverhampton City Council, Halfords Group PLC, Royal Air Force, TalkTalk Direct Limited, Birmingham Heartlands Hospital, Boots UK Limited and Barclays Bank PLC.
Microsoft Access
- 2 day course
- Location: Telford
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Modifying Forms
Multi Table Queries
Creating Queries
Sorting and Filtering
Database Security
Adding Records to a Table
Aggregation Queries
Working With Records
Relational Database Design
Importing and Exporting Records
Formatting Tables
Navigation Pane Protection
DIY Forms
Setting Table Relationships
Macro Techniques
Creating a Lookup Database
Creating and Using Forms
Using a Navigation Form
Data Validation
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Telford
- 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 Recordset Cursor Properties - Optional
- See Training Course Details...
Working with Methods
Using Input Boxes
Understanding the Order of Events
Creating a Function Procedure
Using Debugging Tools
Understanding the Development Environment
Working with the Application Object
Stepping through Code
Controlling Program Execution
Naming Procedures
Working with Properties
Determining the Value of Expressions
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Debugging Code
Creating a Sub Procedure
Using Visual Basic Help
Email us about this courses
Other Telford Enable Technology Training Courses
Data Warehouse Telford Training Courses
Report Builder Telford Training Courses
JavaScript - Telford JavaScript Training Courses
JQuery Mobile Telford Training Courses
Excel 365 Intermediate - Telford Excel Training Courses
PL/SQL Telford Training Courses