ACCESS TRAINING COURSES WILTSHIRE
About Enable Technology Wiltshire Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.
We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Wiltshire. We are happy to discuss customising the course content should you have particular Access training requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Boots UK Limited, Carillion PLC, Royal Air Force, Capita Group PLC, University of Birmingham, GKN PLC, Fujistu PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Wiltshire
- 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 ... Importing and Exporting Records
- See Training Course Details...
Sorting and Filtering
Adding Records to a Table
Understanding VBA
Parameter Queries
Multi Table Queries
Creating and Using Forms
Designing a Lookup Database
Using a Navigation Form
Working With Records
Calculations in Queries
An Introduction to VBA
Setting Table Relationships
Database Security
Macro Techniques
Modifying Forms
Relational Database Design
Action Queries
DIY Forms
Database Wellness
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wiltshire
- 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...
Introduction to Programming in Access
Writing an Error-Handling Routine
Setting Breakpoints
Understanding Collections
Working with Boolean Expressions
Using the Select Case...End Select Structure
Creating a Standard Module
Guidelines for use of Branching Structures
Using the Immediate Window to Call Procedures
Handling Errors
Declaring Variables
Understanding Control-of-Flow Structures
Locking Records for Updating
Using Expressions, Variables, and Intrinsic Functions
Understanding Error Handling
Working with Recordsets
Email us about this courses
Other Wiltshire Enable Technology Training Courses
Excel 365 Intermediate Wiltshire Training Courses
JQuery Mobile - Wiltshire JavaScript Training Courses
SSIS - Wiltshire SQL Server Integration Services Training Courses
SSAS Tabular - Wiltshire SQL Server Analysis Services Training Courses
VBA Wiltshire Training Courses
JavaScript Wiltshire Training Courses