ACCESS TRAINING COURSES LLANTWIT MAJOR
About Enable Technology Llantwit Major Access Training Courses
Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Llantwit Major. 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Loughborough University, TalkTalk Direct Limited, Nationwide Building Society Limited, Birmingham City University, Queen's Medical Centre Nottingham, Keele University, EDF Energy PLC and Cadbury PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llantwit Major
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Working with Variable Scope
- See Training Course Details...
Setting Break Expressions
Declaring Variables
Specifying a Recordset Cursor Type
Working with Recordsets
Understanding Collections
Using the For Each...Next Structure
Using Intrinsic Functions
Determining the Value of Expressions
Naming Procedures
Working with the Code Editor
Understanding Constants
Using the If...End If Decision Structures
Navigating the Access Object Hierarchy
Specifying a Recordset Cursor Location - Optional
Understanding Control-of-Flow Structures
Using Break Mode during Run Mode
Using the With Statement
Creating a Sub Procedure
Microsoft Access
- 2 day course
- Location: Llantwit Major
- 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 ... Formatting Tables
- See Training Course Details...
An Introduction to VBA
Parameter Queries
Understanding VBA
Getting to Know Access
Macros on Forms
Data Validation
Modifying Forms
Creating and Using Reports
Adding Records to a Table
Navigation Pane Protection
Creating a Relational Database
Database Security
Database Wellness
Designing a Lookup Database
Aggregation Queries
Sorting and Filtering
DIY Forms
Multi Table Queries
Creating and Using Macros
Importing and Exporting Records
Email us about this courses
Other Llantwit Major Enable Technology Training Courses
SSAS - Llantwit Major SQL Server Analysis Services Training Courses
SQL Llantwit Major Training Courses
Oracle SQL Llantwit Major Training Courses
JQuery Mobile Llantwit Major Training Courses
JavaScript Llantwit Major Training Courses
VBA - Llantwit Major Excel Training Courses