ACCESS TRAINING COURSES EXETER
About Enable Technology Exeter Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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 Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Exeter. 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.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions 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. Our clients include: Birmingham City Council, Norwich Union PLC, Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Aston University, Carillion PLC, Homeserve PLC and Norfolk Police Constabulary.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Exeter
- 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 Classes and Objects
- See Training Course Details...
Using the With Statement
Determining the Value of Expressions
Using Intrinsic Constants
Trapping Errors with the On Error Statement
Using the If...End If Decision Structures
Locking Records for Updating
Understanding the Order of Events
Creating a Standard Module
Controlling Program Execution
Understanding the Form Object
Working with the Code Editor
Setting Breakpoints
Naming Procedures
Specifying a Recordset Cursor Location - Optional
Understanding Objects
Considering Variable Scope and Lifetime Together
Using Break Mode during Run Mode
Writing an Error-Handling Routine
Understanding the DoCmd Object
Microsoft Access
- 2 day course
- Location: Exeter
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
Adding Transactional Records
Modifying Forms
DIY Forms
Sorting and Filtering
Macros on Forms
Relational Database Design
Adding Records to a Table
Navigation Pane Protection
Formatting Tables
Modifying Table Structures
Creating and Using Macros
Importing and Exporting Records
Macro Techniques
An Introduction to VBA
Creating Queries
Data Validation
Working With Records
Getting to Know Access
Creating and Using Reports
Action Queries
Email us about this courses
Other Exeter Enable Technology Training Courses
JQuery Mobile Exeter Training Courses
SSRS Exeter Training Courses
SSIS - Exeter SQL Server Integration Services Training Courses
DAX Exeter Training Courses
Excel 365 Basic - Exeter Excel Training Courses
Excel Power Pivot - Exeter Excel Training Courses