ACCESS TRAINING COURSES CHIPPENHAM
About Enable Technology Chippenham Access Training Courses
We have a twenty year history of providing skills based Access industry training. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Loughborough University, Nationwide Building Society Limited, Total Telecommunications Limited, Norwich Union PLC, Shell UK Oil Products Ltd, Queen's Medical Centre Nottingham, Canadian High Commission and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chippenham
- 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 ... Guidelines for use of Branching Structures
- See Training Course Details...
Working with Events
Using Input Boxes
Controlling Program Execution
Using Message Boxes
Working with Methods
Using the For Each...Next Structure
Considering Variable Scope and Lifetime Together
Setting Breakpoints
Understanding VBA's Error Trapping Options
Handling Errors
Calling Procedures
Using the If...End If Decision Structures
Understanding Procedures
Understanding Constants
Trapping Errors with the On Error Statement
Creating a Function Procedure
Microsoft Access
- 2 day course
- Location: Chippenham
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Sorting and Filtering
Querying Techniques
Creating a Relational Database
Understanding VBA
Adding Transactional Records
Using a Navigation Form
Importing and Exporting Records
Aggregation Queries
Database Wellness
Working With Records
Designing a Lookup Database
Creating and Using Forms
Action Queries
DIY Forms
Modifying Table Structures
Data Validation
Calculations in Queries
Modifying Forms
Relational Database Design
An Introduction to VBA
Email us about this courses
Other Chippenham Enable Technology Training Courses
Excel 365 Basic Chippenham Training Courses
Report Builder - Chippenham SQL Server Reporting Services Training Courses
SSIS Chippenham Training Courses
JQuery Mobile - Chippenham JavaScript Training Courses
Data Warehouse - Chippenham SQL Training Courses
SSAS Chippenham Training Courses