ACCESS TRAINING COURSES BURNLEY
About Enable Technology Burnley Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a Access course at an alternative training site in Burnley. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Norwich Union PLC, Dollond & Aitchison Limited, Carillion PLC, Norfolk Police Constabulary, Capita Group PLC, West Bromwich Building Society, University of Birmingham and Canadian High Commission.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Burnley
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Writing an Error-Handling Routine
- See Training Course Details...
Using the Select Case...End Select Structure
Using the For Each...Next Structure
Working with the Code Editor
Setting Breakpoints
Using the If...End If Decision Structures
Using Intrinsic Constants
Locking Records for Updating
Using Expressions, Variables, and Intrinsic Functions
Using Message Boxes
Understanding the Form Object
Using the For...Next Structure
Understanding Control-of-Flow Structures
Creating a Standard Module
Understanding Collections
Specifying a Recordset Cursor Location - Optional
Understanding Errors
Working with Variable Lifetime
Understanding Classes and Objects
Controlling Program Execution
Microsoft Access
- 2 day course
- Location: Burnley
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Setting Table Relationships
Creating and Using Forms
Macro Techniques
Calculations in Queries
Creating Queries
Aggregation Queries
Macros on Forms
Multi Table Queries
Creating a Lookup Database
Modifying Table Structures
Creating and Using Macros
Database Security
Data Validation
Sorting and Filtering
Creating and Using Reports
Formatting Tables
Adding Records to a Table
An Introduction to VBA
Modifying Forms
Getting to Know Access
Email us about this courses
Other Burnley Enable Technology Training Courses
SSIS Burnley Training Courses
JavaScript - Burnley JavaScript Training Courses
VBA Burnley Training Courses
SSRS Burnley Training Courses
Data Warehouse Burnley Training Courses
TSQL - Burnley SQL Training Courses