ACCESS TRAINING COURSES LLANTWIT MAJOR
About Enable Technology Llantwit Major Access Training Courses
We offer intensive two and three days Access courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If you prefer we can offer an offsite training location in Llantwit Major. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Birmingham City University, Birmingham Heartlands Hospital, Canadian High Commission, Aston University, TalkTalk Direct Limited, National Power PLC, Queen's Medical Centre Nottingham and Homeserve 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 ... Introduction to Programming in Access
- See Training Course Details...
Navigating the Access Object Hierarchy
Working with Procedures and Functions
Using Intrinsic Constants
Controlling Program Execution
Setting Breakpoints
Naming Procedures
Working with Methods
Understanding the Err Object
Using the CacheSize Property - Optional
Understanding the Form Object
Using the Do...Loop Structure
Using Debugging Tools
Working with the ADODB Recordset Object
Understanding Constants
Working with Recordsets
Working with the Code Editor
Writing an Error-Handling Routine
Working with Properties
Microsoft Access
- 2 day course
- Location: Llantwit Major
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Designing a Lookup Database
- See Training Course Details...
Creating and Using Reports
An Introduction to VBA
Data Validation
Creating and Using Forms
Database Wellness
Creating a Relational Database
Database Security
Formatting Tables
Working With Records
DIY Forms
Modifying Forms
Aggregation Queries
Macro Techniques
Relational Database Design
Creating and Using Macros
Macros on Forms
Sorting and Filtering
Setting Table Relationships
Getting to Know Access
Understanding VBA
Email us about this courses
Other Llantwit Major Enable Technology Training Courses
VBA - Llantwit Major Excel Training Courses
SSIS - Llantwit Major SQL Server Integration Services Training Courses
JQuery Llantwit Major Training Courses
Report Builder Llantwit Major Training Courses
SQL Llantwit Major Training Courses
TSQL - Llantwit Major SQL Training Courses