ACCESS TRAINING COURSES CASTLEFORD
About Enable Technology Castleford Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Castleford. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Yell Group PLC, Dollond & Aitchison Limited, DHL Express, Countrywide Homes Limited, Capita Group PLC, TalkTalk Direct Limited, University of Birmingham and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Castleford
- 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 ... Relational Database Design
- See Training Course Details...
Creating and Using Reports
An Introduction to VBA
DIY Forms
Creating and Using Forms
Macros on Forms
Parameter Queries
Setting Table Relationships
Formatting Tables
Macro Techniques
Navigation Pane Protection
Aggregation Queries
Creating Queries
Modifying Forms
Calculations in Queries
Using a Navigation Form
Importing and Exporting Records
Adding Transactional Records
Sorting and Filtering
Data Validation
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Castleford
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Organizing Code and Procedures
- See Training Course Details...
Handling Errors
Setting Break Expressions
Creating a Sub Procedure
Declaring Variables
Understanding Constants
Understanding Error Handling
Understanding Modules
Working with Variable Scope
Writing an Error-Handling Routine
Using Intrinsic Constants
Stepping through Code
Understanding Collections
Locking Records for Updating
Using Intrinsic Functions
Understanding VBA's Error Trapping Options
Working with Recordsets
Using Expressions, Variables, and Intrinsic Functions
Understanding Control-of-Flow Structures
Working with Events
Working with the Application Object
Email us about this courses
Other Castleford Enable Technology Training Courses
Report Builder Castleford Training Courses
Excel Power Pivot Castleford Training Courses
SQL Castleford Training Courses
Data Warehouse Castleford Training Courses
Excel 365 Advanced - Castleford Excel Training Courses
JQuery - Castleford JavaScript Training Courses