ACCESS TRAINING COURSES CAERPHILLY
About Enable Technology Caerphilly Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Access courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Caerphilly. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Keele University, Shell UK Oil Products Ltd, Fujistu PLC, Countrywide Homes Limited, EDF Energy PLC, Homeserve PLC, National Power PLC and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Caerphilly
- 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 ... Handling Errors
- See Training Course Details...
Creating a Standard Module
Understanding Data Types
Determining the Value of Expressions
Guidelines for use of Branching Structures
Understanding Collections
Considering Variable Scope and Lifetime Together
Working with Variable Lifetime
Working with Variable Scope
Working with Inline Error Handling
Why Program in Access?
Understanding the Err Object
Locking Records for Updating
Using Expressions, Variables, and Intrinsic Functions
Navigating the Access Object Hierarchy
Understanding Errors
Working with Events
Specifying a Recordset Cursor Location - Optional
Microsoft Access
- 2 day course
- Location: Caerphilly
- 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 a Relational Database
- See Training Course Details...
Aggregation Queries
Querying Techniques
Adding Transactional Records
Getting to Know Access
Relational Database Design
Creating Queries
An Introduction to VBA
Designing a Lookup Database
Database Security
Macros on Forms
Action Queries
Creating and Using Reports
Multi Table Queries
Parameter Queries
Creating and Using Macros
Formatting Tables
Modifying Table Structures
Adding Records to a Table
Importing and Exporting Records
Macro Techniques
Email us about this courses
Other Caerphilly Enable Technology Training Courses
SSAS - Caerphilly SQL Server Analysis Services Training Courses
Excel 365 Basic Caerphilly Training Courses
Power BI Caerphilly Training Courses
JQuery - Caerphilly JavaScript Training Courses
Excel Power Pivot Caerphilly Training Courses
JQuery Mobile - Caerphilly JavaScript Training Courses