ACCESS TRAINING COURSES YORK
About Enable Technology York Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in York. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Total Telecommunications Limited, Wolverhampton City Council, Yell Group PLC, West Bromwich Building Society, Vodafone Group Services, Unipart Group, DHL Express and Countrywide Homes Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: York
- 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 Intrinsic Functions
- See Training Course Details...
Working with Inline Error Handling
Understanding Error Handling
Handling Errors
Specifying a Recordset Cursor Type
Understanding Expressions and Statements
Working with the Application Object
Setting Breakpoints
Using the Do...Loop Structure
Understanding VBA's Error Trapping Options
Using Expressions, Variables, and Intrinsic Functions
Understanding Constants
Declaring and Creating Object Variables
Specifying a Recordset Cursor Location - Optional
Calling Procedures
Working with the Code Editor
Writing an Error-Handling Routine
Declaring Variables
Setting Break Expressions
Creating a Standard Module
Creating a Function Procedure
Microsoft Access
- 2 day course
- Location: York
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Aggregation Queries
An Introduction to VBA
Working With Records
Modifying Forms
Creating Queries
Querying Techniques
Setting Table Relationships
Creating a Lookup Database
Creating a Relational Database
Database Wellness
Multi Table Queries
Understanding VBA
DIY Forms
Parameter Queries
Database Security
Creating and Using Macros
Macro Techniques
Adding Transactional Records
Macros on Forms
Data Validation
Email us about this courses
Other York Enable Technology Training Courses
JavaScript - York JavaScript Training Courses
Excel Power Pivot - York Excel Training Courses
Excel 365 Advanced York Training Courses
PL/SQL York Training Courses
VBA - York Excel Training Courses
Power Query - York Excel Training Courses