ACCESS TRAINING COURSES DYFED
About Enable Technology Dyfed Access Training Courses
Enable Technology provides practical Access skills based technology training. 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. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Dyfed. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Yell Group PLC, Total Telecommunications Limited, Birmingham Heartlands Hospital, Dollond & Aitchison Limited, Halfords Group PLC, Aston University, South Staffordshire Water PLC and Birmingham City University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dyfed
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Organizing Code and Procedures
Understanding the DoCmd Object
Understanding the Order of Events
Using Input Boxes
Understanding Expressions and Statements
Using the Do...Loop Structure
Understanding Control-of-Flow Structures
Guidelines for use of Branching Structures
Setting Break Expressions
Debugging Code
Understanding Recordset Cursor Properties - Optional
Working with Events
Understanding Error Handling
Declaring and Creating Object Variables
Creating a Function Procedure
Understanding Objects
Understanding VBA's Error Trapping Options
Working with Methods
Microsoft Access
- 2 day course
- Location: Dyfed
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... DIY Forms
- See Training Course Details...
Database Security
Sorting and Filtering
Modifying Forms
Data Validation
Database Wellness
Working With Records
Aggregation Queries
Creating and Using Reports
Navigation Pane Protection
Creating a Relational Database
Relational Database Design
Creating Queries
Action Queries
Macro Techniques
Creating and Using Macros
Parameter Queries
Setting Table Relationships
Modifying Table Structures
Adding Records to a Table
Macros on Forms
Email us about this courses
Other Dyfed Enable Technology Training Courses
JavaScript - Dyfed JavaScript Training Courses
Excel Power Pivot - Dyfed Excel Training Courses
SSAS Tabular - Dyfed SQL Server Analysis Services Training Courses
PL/SQL - Dyfed SQL Training Courses
Report Builder Dyfed Training Courses
SSAS Dyfed Training Courses