ACCESS TRAINING COURSES SOMERSET
About Enable Technology Somerset Access Training Courses
We have a twenty year history of providing skills based Access industry training. 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. The Access course could also be scheduled at a socially distanced site near you in Somerset. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are DHL Express, Capita Group PLC, Birmingham City Council, GKN PLC, EDF Energy PLC, Vodafone Group Services, Nuclear Engineering Services and Halfords Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Somerset
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding Expressions and Statements
- See Training Course Details...
Understanding VBA's Error Trapping Options
Working with Boolean Expressions
Handling Errors
Understanding Collections
Working with Variable Scope
Using Debugging Tools
Using the Immediate Window to Call Procedures
Understanding the Err Object
Understanding Modules
Guidelines for use of Branching Structures
Working with Recordsets
Understanding the Development Environment
Considering Variable Scope and Lifetime Together
Using the Select Case...End Select Structure
Creating a Function Procedure
Trapping Errors with the On Error Statement
Working with the Application Object
Using the Object Browser
Understanding Objects
Microsoft Access
- 2 day course
- Location: Somerset
- 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 ... Creating a Lookup Database
- See Training Course Details...
Creating a Relational Database
Adding Records to a Table
Action Queries
Parameter Queries
Navigation Pane Protection
Macro Techniques
Data Validation
Getting to Know Access
Working With Records
Modifying Forms
Macros on Forms
Modifying Table Structures
Setting Table Relationships
Sorting and Filtering
Multi Table Queries
DIY Forms
Formatting Tables
Using a Navigation Form
Calculations in Queries
Creating Queries
Email us about this courses
Other Somerset Enable Technology Training Courses
DAX - Somerset Excel Training Courses
Oracle SQL Somerset Training Courses
JQuery Mobile Somerset Training Courses
Power Query - Somerset Excel Training Courses
Excel Power Pivot Somerset Training Courses
SSAS Tabular - Somerset SQL Server Analysis Services Training Courses