ACCESS TRAINING COURSES WIDNES
About Enable Technology Widnes Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. 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.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local training site in Widnes. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Wolverhampton City Council, Vodafone Group Services, Birmingham City University, Countrywide Homes Limited, Lloyds TSB Bank PLC, National Power PLC, West Bromwich Building Society and Queen's Medical Centre Nottingham.
Microsoft Access
- 2 day course
- Location: Widnes
- 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...
Relational Database Design
Creating and Using Macros
Calculations in Queries
Using a Navigation Form
Formatting Tables
Parameter Queries
Multi Table Queries
Sorting and Filtering
Modifying Table Structures
Creating a Relational Database
Adding Records to a Table
Navigation Pane Protection
Database Security
Macro Techniques
Adding Transactional Records
Database Wellness
Creating a Lookup Database
Designing a Lookup Database
Creating Queries
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Widnes
- 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 ... Working with Variable Scope
- See Training Course Details...
Understanding the DoCmd Object
Using Visual Basic Help
Guidelines for use of Branching Structures
Debugging Code
Understanding Procedures
Understanding Recordset Cursor Properties - Optional
Stepping through Code
Using the Do...Loop Structure
Using Message Boxes
Working with Properties
Using Debugging Tools
Understanding the Order of Events
Understanding Modules
Controlling Program Execution
Creating a Standard Module
Using Intrinsic Constants
Understanding Objects
Setting Break Expressions
Using the With Statement
Email us about this courses
Other Widnes Enable Technology Training Courses
Report Builder - Widnes SQL Server Reporting Services Training Courses
Excel Power Pivot Widnes Training Courses
Excel 365 Advanced Widnes Training Courses
VBA Widnes Training Courses
JavaScript Widnes Training Courses
SSIS - Widnes SQL Server Integration Services Training Courses