ACCESS TRAINING COURSES DYFED
About Enable Technology Dyfed Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Dyfed. We are happy to modify the Access syllabus to match your teams training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Nationwide Building Society Limited, West Bromwich Building Society, Norwich Union PLC, Wolverhampton City Council, Yell Group PLC, Unipart Group, DHL Express and Queen's Medical Centre Nottingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dyfed
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using Message Boxes
- See Training Course Details...
Using Intrinsic Constants
Writing an Error-Handling Routine
Using the Do...Loop Structure
Working with Methods
Working with Properties
Understanding Recordset Cursor Properties - Optional
Working with Variable Lifetime
Specifying a Recordset Cursor Type
Working with Variable Scope
Understanding Error Handling
Understanding Expressions and Statements
Handling Errors
Setting Break Expressions
Using Intrinsic Functions
Creating a Sub Procedure
Creating a Function Procedure
Using the Select Case...End Select Structure
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 ... Data Validation
- See Training Course Details...
Multi Table Queries
Parameter Queries
Setting Table Relationships
Querying Techniques
Relational Database Design
DIY Forms
Sorting and Filtering
Formatting Tables
Calculations in Queries
Designing a Lookup Database
Getting to Know Access
Aggregation Queries
Creating a Relational Database
Action Queries
Modifying Forms
Creating and Using Reports
Database Security
Understanding VBA
Creating Queries
Creating and Using Macros
Email us about this courses
Other Dyfed Enable Technology Training Courses
PL/SQL - Dyfed SQL Training Courses
Power Query Dyfed Training Courses
SSAS - Dyfed SQL Server Analysis Services Training Courses
Excel 365 Intermediate Dyfed Training Courses
Excel 365 Basic Dyfed Training Courses
Data Warehouse Dyfed Training Courses