ACCESS TRAINING COURSES STROUD
About Enable Technology Stroud Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver Access courses at your site. The Access course could also be scheduled at a socially distanced site near you in Stroud. 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Shell UK Oil Products Ltd, West Bromwich Building Society, Birmingham City Council, Norwich Union PLC, GKN PLC, Birmingham City University, Vodafone Group Services and Lloyds TSB Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stroud
- 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 ... Creating a Standard Module
- See Training Course Details...
Declaring and Creating Object Variables
Understanding the DoCmd Object
Using the Object Browser
Understanding Collections
Working with Properties
Understanding Data Types
Organizing Code and Procedures
Understanding the Order of Events
Working with Methods
Using Expressions, Variables, and Intrinsic Functions
Handling Errors
Understanding Constants
Why Program in Access?
Using the Select Case...End Select Structure
Using the For Each...Next Structure
Working with Recordsets
Using Input Boxes
Understanding the Err Object
Working with Variable Lifetime
Microsoft Access
- 2 day course
- Location: Stroud
- 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 ... Macro Techniques
- See Training Course Details...
An Introduction to VBA
Creating a Relational Database
Adding Records to a Table
Database Wellness
Creating a Lookup Database
Multi Table Queries
Adding Transactional Records
DIY Forms
Macros on Forms
Getting to Know Access
Using a Navigation Form
Creating and Using Macros
Aggregation Queries
Formatting Tables
Calculations in Queries
Action Queries
Working With Records
Creating and Using Reports
Querying Techniques
Understanding VBA
Email us about this courses
Other Stroud Enable Technology Training Courses
Excel 365 Intermediate - Stroud Excel Training Courses
Excel 365 Basic - Stroud Excel Training Courses
SQL - Stroud SQL Training Courses
Data Warehouse Stroud Training Courses
Oracle SQL Stroud Training Courses
JavaScript Stroud Training Courses