ACCESS TRAINING COURSES CARDIFF
About Enable Technology Cardiff Access Training Courses
We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If you prefer we can offer an offsite training location in Cardiff. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Capita Group PLC, Aston University, Vodafone Group Services, Wolverhampton City Council, Dollond & Aitchison Limited, Cadbury PLC, Norwich Union PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Cardiff
- 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 ... Creating Queries
- See Training Course Details...
Setting Table Relationships
Creating a Relational Database
Querying Techniques
Macro Techniques
Creating and Using Reports
Multi Table Queries
Action Queries
An Introduction to VBA
Using a Navigation Form
Modifying Table Structures
Getting to Know Access
Sorting and Filtering
Creating and Using Macros
Creating and Using Forms
Designing a Lookup Database
DIY Forms
Aggregation Queries
Adding Records to a Table
Navigation Pane Protection
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cardiff
- 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 the Object Browser
- See Training Course Details...
Setting Break Expressions
Understanding Recordset Cursor Properties - Optional
Organizing Code and Procedures
Working with the Code Editor
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Guidelines for use of Branching Structures
Declaring and Creating Object Variables
Understanding Errors
Understanding the Development Environment
Working with Variable Lifetime
Using Intrinsic Constants
Debugging Code
Using Expressions, Variables, and Intrinsic Functions
Creating a Sub Procedure
Understanding Collections
Working with Events
Understanding Classes and Objects
Naming Procedures
Email us about this courses
Other Cardiff Enable Technology Training Courses
JQuery - Cardiff JavaScript Training Courses
JavaScript - Cardiff JavaScript Training Courses
Power Query - Cardiff Excel Training Courses
VBA Cardiff Training Courses
Excel 365 Basic Cardiff Training Courses
Excel Power Pivot Cardiff Training Courses