ACCESS TRAINING COURSES CAERPHILLY
About Enable Technology Caerphilly Access Training Courses
Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Caerphilly. All Access courses can be customised to meet your particular 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
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Total Telecommunications Limited, Nuclear Engineering Services, Loughborough University, Capita Group PLC, Norfolk Police Constabulary, Nationwide Building Society Limited, Aston University and Birmingham City University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Caerphilly
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Data Types
- See Training Course Details...
Working with Methods
Understanding Error Handling
Using Message Boxes
Working with Variable Scope
Using the For...Next Structure
Using Input Boxes
Organizing Code and Procedures
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Functions
Understanding the DoCmd Object
Specifying a Recordset Cursor Type
Working with Events
Understanding Procedures
Working with the Application Object
Considering Variable Scope and Lifetime Together
Determining the Value of Expressions
Using the Do...Loop Structure
Understanding Modules
Debugging Code
Microsoft Access
- 2 day course
- Location: Caerphilly
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Macro Techniques
- See Training Course Details...
Adding Transactional Records
Importing and Exporting Records
Sorting and Filtering
Modifying Table Structures
Using a Navigation Form
Creating and Using Macros
Macros on Forms
Working With Records
Database Security
Action Queries
Database Wellness
Aggregation Queries
DIY Forms
Creating a Lookup Database
Designing a Lookup Database
Understanding VBA
Navigation Pane Protection
Modifying Forms
Adding Records to a Table
Creating Queries
Email us about this courses
Other Caerphilly Enable Technology Training Courses
JQuery Caerphilly Training Courses
Excel Power Pivot - Caerphilly Excel Training Courses
SSAS Tabular Caerphilly Training Courses
VBA - Caerphilly Excel Training Courses
Power BI - Caerphilly Microsoft Power BI Training Courses
SQL - Caerphilly SQL Training Courses