ACCESS TRAINING COURSES WEST GLAMORGAN
About Enable Technology West Glamorgan Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in West Glamorgan. The Access syllabus can be modified to accommodate your specific training needs.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are DHL Express, Halfords Group PLC, Royal & Sun Alliance Group PLC, Total Telecommunications Limited, Yell Group PLC, Norwich Union PLC, Dollond & Aitchison Limited and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: West Glamorgan
- 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 ... Working with Methods
- See Training Course Details...
Locking Records for Updating
Using Intrinsic Constants
Understanding VBA's Error Trapping Options
Handling Errors
Declaring Variables
Using the Select Case...End Select Structure
Working with Variable Lifetime
Understanding Constants
Naming Procedures
Debugging Code
Using the With Statement
Understanding the Err Object
Organizing Code and Procedures
Creating a Standard Module
Stepping through Code
Working with Procedures and Functions
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Microsoft Access
- 2 day course
- Location: West Glamorgan
- 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 ... Querying Techniques
- See Training Course Details...
Importing and Exporting Records
Parameter Queries
Creating and Using Macros
Creating Queries
Macro Techniques
Creating a Relational Database
Understanding VBA
Designing a Lookup Database
Multi Table Queries
Creating a Lookup Database
Database Security
Database Wellness
Using a Navigation Form
DIY Forms
Calculations in Queries
Modifying Forms
Creating and Using Reports
Aggregation Queries
Working With Records
Sorting and Filtering
Email us about this courses
Other West Glamorgan Enable Technology Training Courses
VBA West Glamorgan Training Courses
Oracle SQL West Glamorgan Training Courses
SQL - West Glamorgan SQL Training Courses
SSIS - West Glamorgan SQL Server Integration Services Training Courses
Power BI West Glamorgan Training Courses
SSRS - West Glamorgan SQL Server Reporting Services Training Courses