ACCESS TRAINING COURSES PENARTH
About Enable Technology Penarth Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Penarth. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, Nationwide Building Society Limited, Countrywide Homes Limited, Canadian High Commission, Royal & Sun Alliance Group PLC, Unipart Group and Homeserve PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Penarth
- 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 ... Setting Breakpoints
- See Training Course Details...
Working with Methods
Specifying a Recordset Cursor Location - Optional
Working with the Application Object
Understanding VBA's Error Trapping Options
Using the With Statement
Working with Events
Using the Do...Loop Structure
Creating a Standard Module
Trapping Errors with the On Error Statement
Understanding Recordset Cursor Properties - Optional
Using the For Each...Next Structure
Navigating the Access Object Hierarchy
Understanding Error Handling
Understanding the Err Object
Understanding the Development Environment
Working with the Code Editor
Working with Boolean Expressions
Working with Properties
Microsoft Access
- 2 day course
- Location: Penarth
- 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 ... Sorting and Filtering
- See Training Course Details...
Navigation Pane Protection
Setting Table Relationships
Aggregation Queries
An Introduction to VBA
Database Security
Creating a Lookup Database
Creating a Relational Database
Querying Techniques
Parameter Queries
Relational Database Design
Calculations in Queries
Getting to Know Access
Modifying Forms
Using a Navigation Form
Action Queries
Database Wellness
Adding Transactional Records
Understanding VBA
Adding Records to a Table
Creating and Using Reports
Email us about this courses
Other Penarth Enable Technology Training Courses
Oracle SQL - Penarth SQL Training Courses
SQL Penarth Training Courses
Excel 365 Basic Penarth Training Courses
SSAS - Penarth SQL Server Analysis Services Training Courses
VBA - Penarth Excel Training Courses
Excel 365 Intermediate - Penarth Excel Training Courses