ACCESS TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post training. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. Alternatively we could schedule a Access course at an alternative training site in Mid Glamorgan. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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 group of companies has been operating continuously providing IT training since 1998. Our clients include: DHL Express, EDF Energy PLC, National Power PLC, South Staffordshire Water PLC, Nationwide Building Society Limited, Norwich Union PLC, Norfolk Police Constabulary and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mid 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 Properties
- See Training Course Details...
Understanding Objects
Using Debugging Tools
Writing an Error-Handling Routine
Handling Errors
Navigating the Access Object Hierarchy
Using the If...End If Decision Structures
Creating a Function Procedure
Understanding Modules
Understanding Recordset Cursor Properties - Optional
Specifying a Recordset Cursor Type
Understanding Procedures
Using the Immediate Window to Call Procedures
Understanding the Err Object
Understanding Collections
Understanding Constants
Working with Recordsets
Considering Variable Scope and Lifetime Together
Debugging Code
Working with Boolean Expressions
Microsoft Access
- 2 day course
- Location: Mid Glamorgan
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Understanding VBA
Relational Database Design
Action Queries
Using a Navigation Form
Multi Table Queries
Creating Queries
Adding Records to a Table
Adding Transactional Records
Macros on Forms
Designing a Lookup Database
Querying Techniques
Sorting and Filtering
Creating and Using Reports
Creating and Using Forms
Creating and Using Macros
Setting Table Relationships
Modifying Forms
Aggregation Queries
Database Wellness
Working With Records
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
Power BI - Mid Glamorgan Microsoft Power BI Training Courses
TSQL - Mid Glamorgan SQL Training Courses
Power Query - Mid Glamorgan Excel Training Courses
SSAS Tabular - Mid Glamorgan SQL Server Analysis Services Training Courses
Report Builder - Mid Glamorgan SQL Server Reporting Services Training Courses
Excel 365 Advanced - Mid Glamorgan Excel Training Courses