ACCESS TRAINING COURSES HEREFORDSHIRE
About Enable Technology Herefordshire Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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 Herefordshire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We have operated primarily in the West Midlands for twenty years. Our clients include: Cadbury PLC, Vodafone Group Services, Nationwide Building Society Limited, Canadian High Commission, Keele University, Halfords Group PLC, Loughborough University and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Database Security
Aggregation Queries
Formatting Tables
Querying Techniques
Using a Navigation Form
Adding Transactional Records
An Introduction to VBA
Creating a Lookup Database
Action Queries
Adding Records to a Table
Creating and Using Forms
Setting Table Relationships
Macro Techniques
Multi Table Queries
Creating Queries
Relational Database Design
Modifying Forms
Importing and Exporting Records
Creating a Relational Database
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Herefordshire
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using the Do...Loop Structure
- See Training Course Details...
Working with Methods
Stepping through Code
Guidelines for use of Branching Structures
Using the Immediate Window to Call Procedures
Understanding Procedures
Understanding Expressions and Statements
Determining the Value of Expressions
Working with the Code Editor
Using Debugging Tools
Using the For Each...Next Structure
Setting Break Expressions
Creating a Standard Module
Locking Records for Updating
Understanding Error Handling
Using Intrinsic Functions
Using the Select Case...End Select Structure
Email us about this courses
Other Herefordshire Enable Technology Training Courses
Report Builder Herefordshire Training Courses
Excel 365 Basic - Herefordshire Excel Training Courses
SQL - Herefordshire SQL Training Courses
Power Query Herefordshire Training Courses
SSIS - Herefordshire SQL Server Integration Services Training Courses
SSAS Herefordshire Training Courses