ACCESS TRAINING COURSES ABERGAVENNY
About Enable Technology Abergavenny Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Abergavenny. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Total Telecommunications Limited, Aston University, Nationwide Building Society Limited, Dollond & Aitchison Limited, Barclays Bank PLC, Halfords Group PLC, Lloyds TSB Bank PLC and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Abergavenny
- 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 Errors
- See Training Course Details...
Guidelines for use of Branching Structures
Stepping through Code
Calling Procedures
Using Debugging Tools
Writing an Error-Handling Routine
Naming Procedures
Creating a Function Procedure
Working with Boolean Expressions
Understanding Data Types
Using the With Statement
Setting Break Expressions
Using the For Each...Next Structure
Working with Properties
Using the CacheSize Property - Optional
Using Break Mode during Run Mode
Understanding Procedures
Using Intrinsic Constants
Microsoft Access
- 2 day course
- Location: Abergavenny
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Database Security
Working With Records
Modifying Table Structures
Aggregation Queries
Using a Navigation Form
Database Wellness
Understanding VBA
Importing and Exporting Records
Action Queries
Modifying Forms
Creating a Relational Database
Creating Queries
Creating and Using Reports
Multi Table Queries
Navigation Pane Protection
Macro Techniques
Macros on Forms
Relational Database Design
Formatting Tables
Querying Techniques
Email us about this courses
Other Abergavenny Enable Technology Training Courses
Excel 365 Basic - Abergavenny Excel Training Courses
JavaScript Abergavenny Training Courses
Oracle SQL - Abergavenny SQL Training Courses
SSAS - Abergavenny SQL Server Analysis Services Training Courses
DAX - Abergavenny Excel Training Courses
Excel 365 Intermediate - Abergavenny Excel Training Courses