ACCESS TRAINING COURSES WINSFORD
About Enable Technology Winsford Access Training Courses
Enable Technology specialise in succinct skills based Access training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with Access training materials which they keep after the course. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Winsford. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Fujistu PLC, Birmingham City Council, Countrywide Homes Limited, Wolverhampton City Council, Homeserve PLC, Norfolk Police Constabulary, Queen's Medical Centre Nottingham and GKN PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Winsford
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Working with Inline Error Handling
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Specifying a Recordset Cursor Location - Optional
Understanding Procedures
Understanding Collections
Using Expressions, Variables, and Intrinsic Functions
Working with the ADODB Recordset Object
Understanding the Err Object
Using Visual Basic Help
Using the Select Case...End Select Structure
Using Intrinsic Constants
Setting Breakpoints
Working with Variable Scope
Working with Properties
Creating a Sub Procedure
Using Intrinsic Functions
Understanding the Form Object
Stepping through Code
Microsoft Access
- 2 day course
- Location: Winsford
- 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 ... Adding Transactional Records
- See Training Course Details...
Creating a Lookup Database
Getting to Know Access
Creating and Using Forms
Aggregation Queries
Understanding VBA
Action Queries
Multi Table Queries
Modifying Forms
Using a Navigation Form
Database Security
Modifying Table Structures
Database Wellness
Relational Database Design
An Introduction to VBA
DIY Forms
Querying Techniques
Creating and Using Macros
Creating Queries
Parameter Queries
Designing a Lookup Database
Email us about this courses
Other Winsford Enable Technology Training Courses
SQL Winsford Training Courses
Report Builder - Winsford SQL Server Reporting Services Training Courses
Data Warehouse Winsford Training Courses
SSIS - Winsford SQL Server Integration Services Training Courses
Power Query - Winsford Excel Training Courses
VBA - Winsford Excel Training Courses