ACCESS TRAINING COURSES CIL-Y-COED
About Enable Technology Cil-y-coed Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. If delivery onsite is an issue we will organise a socially distanced venue near you in Cil-y-coed. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are EDF Energy PLC, Royal Air Force, Countrywide Homes Limited, South Staffordshire Water PLC, National Power PLC, Capita Group PLC, Shell UK Oil Products Ltd and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cil-y-coed
- 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 ... Understanding Data Types
- See Training Course Details...
Using Intrinsic Functions
Using the Select Case...End Select Structure
Creating a Sub Procedure
Understanding Procedures
Declaring Variables
Working with Methods
Understanding Recordset Cursor Properties - Optional
Understanding the Err Object
Trapping Errors with the On Error Statement
Using Intrinsic Constants
Understanding Expressions and Statements
Calling Procedures
Specifying a Recordset Cursor Location - Optional
Locking Records for Updating
Working with the ADODB Recordset Object
Introduction to Programming in Access
Using the For Each...Next Structure
Determining the Value of Expressions
Declaring and Creating Object Variables
Microsoft Access
- 2 day course
- Location: Cil-y-coed
- 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...
Macro Techniques
Working With Records
Understanding VBA
Sorting and Filtering
Modifying Forms
Creating and Using Reports
Creating and Using Forms
Creating a Lookup Database
Relational Database Design
Navigation Pane Protection
Creating and Using Macros
Calculations in Queries
Creating Queries
Adding Records to a Table
Parameter Queries
Formatting Tables
An Introduction to VBA
Designing a Lookup Database
Database Wellness
Importing and Exporting Records
Email us about this courses
Other Cil-y-coed Enable Technology Training Courses
PL/SQL Cil-y-coed Training Courses
TSQL - Cil-y-coed SQL Training Courses
SSAS Tabular - Cil-y-coed SQL Server Analysis Services Training Courses
Power Query Cil-y-coed Training Courses
Excel Power Pivot - Cil-y-coed Excel Training Courses
Data Warehouse - Cil-y-coed SQL Training Courses