ACCESS TRAINING COURSES SWINDON
About Enable Technology Swindon Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Courses are instructor led and groups sizes small. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a venue near you in Swindon. Every Access course can be modified to meet your bespoke 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 have operated primarily in the West Midlands for twenty years. Some of our clients are Barclays Bank PLC, Carillion PLC, Royal & Sun Alliance Group PLC, Royal Air Force, National Power PLC, Boots UK Limited, Unipart Group and Countrywide Homes Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Swindon
- 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 ... Locking Records for Updating
- See Training Course Details...
Setting Break Expressions
Using the Immediate Window to Call Procedures
Working with the Application Object
Understanding Error Handling
Using the With Statement
Calling Procedures
Using Input Boxes
Understanding Procedures
Understanding the Err Object
Working with Methods
Understanding Collections
Declaring Variables
Setting Breakpoints
Creating a Sub Procedure
Working with Boolean Expressions
Stepping through Code
Understanding the Form Object
Using the Do...Loop Structure
Debugging Code
Microsoft Access
- 2 day course
- Location: Swindon
- 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 ... Database Wellness
- See Training Course Details...
Calculations in Queries
Setting Table Relationships
An Introduction to VBA
Database Security
Creating a Lookup Database
Creating and Using Macros
Multi Table Queries
Designing a Lookup Database
Relational Database Design
Macros on Forms
Adding Records to a Table
Using a Navigation Form
Action Queries
Working With Records
Creating Queries
Getting to Know Access
DIY Forms
Creating and Using Reports
Importing and Exporting Records
Aggregation Queries
Email us about this courses
Other Swindon Enable Technology Training Courses
JavaScript - Swindon JavaScript Training Courses
SQL Swindon Training Courses
Excel 365 Basic - Swindon Excel Training Courses
SSAS Tabular Swindon Training Courses
Oracle SQL Swindon Training Courses
Excel Power Pivot - Swindon Excel Training Courses