ACCESS TRAINING COURSES WYTHENSHAWE
About Enable Technology Wythenshawe Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Wythenshawe. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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: Dollond & Aitchison Limited, Countrywide Homes Limited, South Staffordshire Water PLC, Royal & Sun Alliance Group PLC, Unipart Group, Total Telecommunications Limited, Carillion PLC and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wythenshawe
- 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 Procedures
- See Training Course Details...
Using the Select Case...End Select Structure
Understanding Classes and Objects
Using the For...Next Structure
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using Message Boxes
Understanding Errors
Handling Errors
Understanding Data Types
Understanding Error Handling
Debugging Code
Guidelines for use of Branching Structures
Working with Variable Scope
Working with Variable Lifetime
Working with Properties
Stepping through Code
Working with Recordsets
Creating a Standard Module
Microsoft Access
- 2 day course
- Location: Wythenshawe
- 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 ... Database Security
- See Training Course Details...
Modifying Forms
Getting to Know Access
Navigation Pane Protection
Aggregation Queries
Importing and Exporting Records
Macros on Forms
Using a Navigation Form
DIY Forms
Multi Table Queries
Modifying Table Structures
Macro Techniques
Creating Queries
Creating a Lookup Database
Action Queries
Creating and Using Macros
Calculations in Queries
Creating a Relational Database
Sorting and Filtering
Setting Table Relationships
Understanding VBA
Email us about this courses
Other Wythenshawe Enable Technology Training Courses
Power BI - Wythenshawe Microsoft Power BI Training Courses
TSQL Wythenshawe Training Courses
DAX Wythenshawe Training Courses
JavaScript Wythenshawe Training Courses
Data Warehouse - Wythenshawe SQL Training Courses
SSIS Wythenshawe Training Courses