ACCESS TRAINING COURSES HALIFAX
About Enable Technology Halifax Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a venue near you in Halifax. We are happy to discuss customising the course content should you have particular Access training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Vodafone Group Services, National Power PLC, DHL Express, Lloyds TSB Bank PLC, Canadian High Commission, Royal & Sun Alliance Group PLC, Shell UK Oil Products Ltd and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Halifax
- 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 ... Handling Errors
- See Training Course Details...
Creating a Function Procedure
Locking Records for Updating
Creating a Standard Module
Understanding Errors
Working with Variable Scope
Using the Object Browser
Stepping through Code
Working with Boolean Expressions
Organizing Code and Procedures
Working with the Code Editor
Understanding Objects
Working with Events
Understanding the Order of Events
Specifying a Recordset Cursor Type
Why Program in Access?
Understanding the Form Object
Using the If...End If Decision Structures
Considering Variable Scope and Lifetime Together
Using Message Boxes
Microsoft Access
- 2 day course
- Location: Halifax
- 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 ... Designing a Lookup Database
- See Training Course Details...
Macros on Forms
An Introduction to VBA
Parameter Queries
Creating and Using Reports
Action Queries
Adding Transactional Records
Calculations in Queries
Macro Techniques
Adding Records to a Table
Creating Queries
Using a Navigation Form
Multi Table Queries
Modifying Table Structures
DIY Forms
Creating and Using Forms
Data Validation
Understanding VBA
Navigation Pane Protection
Creating a Lookup Database
Working With Records
Email us about this courses
Other Halifax Enable Technology Training Courses
Excel 365 Basic Halifax Training Courses
SSAS Tabular - Halifax SQL Server Analysis Services Training Courses
JQuery - Halifax JavaScript Training Courses
Excel 365 Advanced Halifax Training Courses
Data Warehouse Halifax Training Courses
Oracle SQL Halifax Training Courses