ACCESS TRAINING COURSES MACCLESFIELD
About Enable Technology Macclesfield Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If you prefer we can offer an offsite training location in Macclesfield. 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. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are National Power PLC, Total Telecommunications Limited, Loughborough University, Nationwide Building Society Limited, Fujistu PLC, GKN PLC, Royal Air Force and Unipart Group.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Macclesfield
- 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 Error Handling
- See Training Course Details...
Understanding Collections
Navigating the Access Object Hierarchy
Creating a Sub Procedure
Working with the ADODB Recordset Object
Understanding Control-of-Flow Structures
Using the For...Next Structure
Determining the Value of Expressions
Understanding VBA's Error Trapping Options
Calling Procedures
Using Debugging Tools
Working with Properties
Working with Variable Scope
Understanding Objects
Understanding Procedures
Declaring Variables
Using Expressions, Variables, and Intrinsic Functions
Organizing Code and Procedures
Microsoft Access
- 2 day course
- Location: Macclesfield
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
Working With Records
Adding Transactional Records
Using a Navigation Form
Sorting and Filtering
Designing a Lookup Database
Macro Techniques
Database Wellness
Creating and Using Reports
Parameter Queries
An Introduction to VBA
DIY Forms
Multi Table Queries
Creating and Using Forms
Database Security
Querying Techniques
Calculations in Queries
Adding Records to a Table
Data Validation
Macros on Forms
Navigation Pane Protection
Email us about this courses
Other Macclesfield Enable Technology Training Courses
Data Warehouse - Macclesfield SQL Training Courses
Report Builder - Macclesfield SQL Server Reporting Services Training Courses
Oracle SQL - Macclesfield SQL Training Courses
PL/SQL - Macclesfield SQL Training Courses
VBA Macclesfield Training Courses
DAX Macclesfield Training Courses