ACCESS TRAINING COURSES HUYTON
About Enable Technology Huyton Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a socially distanced venue near you in Huyton. 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.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Canadian High Commission, Yell Group PLC, Wolverhampton City Council, Dollond & Aitchison Limited, Boots UK Limited, Norfolk Police Constabulary, Birmingham City University and EDF Energy PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Huyton
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Understanding Recordset Cursor Properties - Optional
Working with the Code Editor
Using Break Mode during Run Mode
Trapping Errors with the On Error Statement
Considering Variable Scope and Lifetime Together
Understanding the Err Object
Working with Inline Error Handling
Understanding VBA's Error Trapping Options
Why Program in Access?
Creating a Function Procedure
Understanding Collections
Declaring Variables
Organizing Code and Procedures
Locking Records for Updating
Calling Procedures
Setting Break Expressions
Using the For...Next Structure
Using the Immediate Window to Call Procedures
Understanding Data Types
Microsoft Access
- 2 day course
- Location: Huyton
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Database Wellness
Data Validation
Getting to Know Access
DIY Forms
Parameter Queries
Macro Techniques
Multi Table Queries
Working With Records
Adding Records to a Table
Modifying Forms
Sorting and Filtering
Aggregation Queries
Database Security
Creating a Relational Database
Understanding VBA
Macros on Forms
Using a Navigation Form
Querying Techniques
Setting Table Relationships
Modifying Table Structures
Email us about this courses
Other Huyton Enable Technology Training Courses
SSAS Tabular Huyton Training Courses
Excel 365 Basic - Huyton Excel Training Courses
VBA - Huyton Excel Training Courses
Excel Power Pivot - Huyton Excel Training Courses
Excel 365 Advanced Huyton Training Courses
TSQL - Huyton SQL Training Courses