ACCESS TRAINING COURSES HAVERFORDWEST
About Enable Technology Haverfordwest Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. Another way we could deliver the Access course is at a local training site. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
We have operated primarily in the West Midlands for twenty years. Our clients include: Aston University, National Power PLC, Loughborough University, University of Birmingham, GKN PLC, Dollond & Aitchison Limited, Homeserve PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Haverfordwest
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Database Wellness
- See Training Course Details...
Working With Records
Creating a Relational Database
Sorting and Filtering
Parameter Queries
Creating Queries
Creating a Lookup Database
Navigation Pane Protection
Calculations in Queries
DIY Forms
Data Validation
An Introduction to VBA
Creating and Using Macros
Formatting Tables
Macro Techniques
Modifying Table Structures
Designing a Lookup Database
Creating and Using Reports
Modifying Forms
Multi Table Queries
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Haverfordwest
- 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 ... Trapping Errors with the On Error Statement
- See Training Course Details...
Understanding the Development Environment
Using the If...End If Decision Structures
Understanding Procedures
Understanding Data Types
Understanding Constants
Debugging Code
Working with the Application Object
Using the CacheSize Property - Optional
Working with Methods
Using the Object Browser
Understanding Error Handling
Setting Breakpoints
Controlling Program Execution
Understanding VBA's Error Trapping Options
Specifying a Recordset Cursor Type
Understanding Recordset Cursor Properties - Optional
Working with Recordsets
Working with Inline Error Handling
Email us about this courses
Other Haverfordwest Enable Technology Training Courses
Power Query - Haverfordwest Excel Training Courses
SSIS Haverfordwest Training Courses
Data Warehouse Haverfordwest Training Courses
Oracle SQL Haverfordwest Training Courses
SQL - Haverfordwest SQL Training Courses
VBA Haverfordwest Training Courses