ACCESS TRAINING COURSES HEREFORD
About Enable Technology Hereford Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a Access course at an alternative training site in Hereford. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham Heartlands Hospital, Loughborough University, Capita Group PLC, Nationwide Building Society Limited, Homeserve PLC, Birmingham City University, TalkTalk Direct Limited and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hereford
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Events
- See Training Course Details...
Trapping Errors with the On Error Statement
Working with Procedures and Functions
Determining the Value of Expressions
Working with Recordsets
Understanding Error Handling
Using Input Boxes
Handling Errors
Understanding Classes and Objects
Calling Procedures
Understanding Control-of-Flow Structures
Writing an Error-Handling Routine
Understanding VBA's Error Trapping Options
Understanding Constants
Understanding the Err Object
Using the For Each...Next Structure
Understanding Data Types
Using the With Statement
Microsoft Access
- 2 day course
- Location: Hereford
- 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 ... Designing a Lookup Database
- See Training Course Details...
Navigation Pane Protection
DIY Forms
Creating and Using Macros
Creating a Lookup Database
Importing and Exporting Records
Data Validation
Parameter Queries
Working With Records
Using a Navigation Form
Adding Transactional Records
Adding Records to a Table
Macros on Forms
Macro Techniques
Database Wellness
Creating a Relational Database
Modifying Table Structures
Database Security
Sorting and Filtering
Action Queries
Formatting Tables
Email us about this courses
Other Hereford Enable Technology Training Courses
PL/SQL Hereford Training Courses
Data Warehouse - Hereford SQL Training Courses
SSAS Hereford Training Courses
SQL - Hereford SQL Training Courses
JQuery Mobile Hereford Training Courses
Report Builder - Hereford SQL Server Reporting Services Training Courses