ACCESS TRAINING COURSES HOLYHEAD
About Enable Technology Holyhead Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a training location in Holyhead. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, GKN PLC, Nationwide Building Society Limited, Wolverhampton City Council, Homeserve PLC, Cadbury PLC and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Holyhead
- 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 ... Formatting Tables
- See Training Course Details...
Aggregation Queries
Multi Table Queries
Setting Table Relationships
Creating and Using Forms
Adding Transactional Records
Sorting and Filtering
Macros on Forms
Getting to Know Access
Navigation Pane Protection
DIY Forms
Importing and Exporting Records
Working With Records
Using a Navigation Form
Action Queries
Modifying Table Structures
Parameter Queries
Creating and Using Macros
Creating a Relational Database
Querying Techniques
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Holyhead
- 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 ... Working with Events
- See Training Course Details...
Understanding Expressions and Statements
Using Message Boxes
Organizing Code and Procedures
Understanding the Order of Events
Using the Select Case...End Select Structure
Considering Variable Scope and Lifetime Together
Understanding Procedures
Using Input Boxes
Understanding Error Handling
Creating a Function Procedure
Working with Variable Lifetime
Understanding the Err Object
Declaring Variables
Setting Breakpoints
Understanding Errors
Using the For...Next Structure
Specifying a Recordset Cursor Type
Locking Records for Updating
Debugging Code
Creating a Sub Procedure
Email us about this courses
Other Holyhead Enable Technology Training Courses
Power BI Holyhead Training Courses
JQuery Holyhead Training Courses
Power Query Holyhead Training Courses
Data Warehouse - Holyhead SQL Training Courses
JQuery Mobile - Holyhead JavaScript Training Courses
PL/SQL Holyhead Training Courses