ACCESS TRAINING COURSES BOURNEMOUTH
About Enable Technology Bournemouth Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We provide instructor led training coupled with hands on training. 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 can also deliver the Access course at a local training venue in Bournemouth. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Homeserve PLC, Carillion PLC, Birmingham City University, Royal Air Force, Shell UK Oil Products Ltd, Halfords Group PLC, West Bromwich Building Society and Unipart Group.
Microsoft Access
- 2 day course
- Location: Bournemouth
- 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 ... Navigation Pane Protection
- See Training Course Details...
Understanding VBA
Modifying Table Structures
Creating Queries
Querying Techniques
Macros on Forms
Sorting and Filtering
Modifying Forms
Creating and Using Forms
Setting Table Relationships
Creating a Relational Database
Creating and Using Reports
Working With Records
An Introduction to VBA
Relational Database Design
Parameter Queries
Macro Techniques
Using a Navigation Form
Database Wellness
Multi Table Queries
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bournemouth
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Navigating the Access Object Hierarchy
- See Training Course Details...
Using Intrinsic Functions
Understanding the Form Object
Understanding Errors
Working with Variable Lifetime
Working with the Code Editor
Stepping through Code
Understanding Modules
Understanding the DoCmd Object
Working with Properties
Using the If...End If Decision Structures
Calling Procedures
Understanding Recordset Cursor Properties - Optional
Organizing Code and Procedures
Using the For...Next Structure
Understanding Collections
Using Debugging Tools
Writing an Error-Handling Routine
Using the Do...Loop Structure
Email us about this courses
Other Bournemouth Enable Technology Training Courses
Excel 365 Advanced - Bournemouth Excel Training Courses
Excel 365 Basic - Bournemouth Excel Training Courses
PL/SQL - Bournemouth SQL Training Courses
SSAS Tabular Bournemouth Training Courses
JavaScript - Bournemouth JavaScript Training Courses
SSAS Bournemouth Training Courses