ACCESS TRAINING COURSES STOCKPORT
About Enable Technology Stockport Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a training location in Stockport. 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.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are South Staffordshire Water PLC, Norwich Union PLC, Dollond & Aitchison Limited, Unipart Group, Total Telecommunications Limited, Fujistu PLC, Birmingham Heartlands Hospital and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stockport
- 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 ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Working with Variable Lifetime
Understanding Classes and Objects
Understanding Collections
Why Program in Access?
Stepping through Code
Using the Object Browser
Understanding the Form Object
Understanding the Development Environment
Specifying a Recordset Cursor Location - Optional
Using Input Boxes
Setting Break Expressions
Using the For Each...Next Structure
Naming Procedures
Handling Errors
Working with Variable Scope
Specifying a Recordset Cursor Type
Debugging Code
Microsoft Access
- 2 day course
- Location: Stockport
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Macros on Forms
Parameter Queries
Creating Queries
Database Security
Setting Table Relationships
Creating and Using Reports
Aggregation Queries
Relational Database Design
Creating a Relational Database
Multi Table Queries
DIY Forms
Using a Navigation Form
Adding Records to a Table
Designing a Lookup Database
Database Wellness
Modifying Table Structures
Calculations in Queries
Getting to Know Access
Understanding VBA
An Introduction to VBA
Email us about this courses
Other Stockport Enable Technology Training Courses
TSQL - Stockport SQL Training Courses
Data Warehouse Stockport Training Courses
JQuery Stockport Training Courses
Power BI Stockport Training Courses
Power Query Stockport Training Courses
Excel 365 Intermediate - Stockport Excel Training Courses