ACCESS TRAINING COURSES MERTHYR TYDFIL
About Enable Technology Merthyr Tydfil Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a venue near you in Merthyr Tydfil. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations 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
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Vodafone Group Services, Nuclear Engineering Services, EDF Energy PLC, Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham, Nationwide Building Society Limited, Countrywide Homes Limited and South Staffordshire Water PLC.
Microsoft Access
- 2 day course
- Location: Merthyr Tydfil
- 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 ... Using a Navigation Form
- See Training Course Details...
Sorting and Filtering
Navigation Pane Protection
Creating Queries
Database Security
Creating and Using Forms
An Introduction to VBA
Creating and Using Macros
Macro Techniques
Aggregation Queries
Creating a Relational Database
Creating and Using Reports
Action Queries
Relational Database Design
Working With Records
Data Validation
Multi Table Queries
Setting Table Relationships
Adding Records to a Table
Querying Techniques
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Merthyr Tydfil
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Organizing Code and Procedures
Handling Errors
Understanding the Development Environment
Understanding Data Types
Using the With Statement
Navigating the Access Object Hierarchy
Understanding Control-of-Flow Structures
Working with Variable Lifetime
Why Program in Access?
Declaring Variables
Understanding Objects
Working with Properties
Working with the ADODB Recordset Object
Understanding Classes and Objects
Using the For...Next Structure
Setting Break Expressions
Working with Methods
Locking Records for Updating
Email us about this courses
Other Merthyr Tydfil Enable Technology Training Courses
SQL - Merthyr Tydfil SQL Training Courses
Oracle SQL - Merthyr Tydfil SQL Training Courses
VBA Merthyr Tydfil Training Courses
Report Builder - Merthyr Tydfil SQL Server Reporting Services Training Courses
Power BI Merthyr Tydfil Training Courses
Data Warehouse - Merthyr Tydfil SQL Training Courses