ACCESS TRAINING COURSES HOLYHEAD
About Enable Technology Holyhead Access Training Courses
We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Holyhead. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are National Power PLC, DHL Express, Birmingham City Council, Lloyds TSB Bank PLC, Barclays Bank PLC, Queen's Medical Centre Nottingham, Birmingham City University and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Holyhead
- 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 ... Specifying a Recordset Cursor Location - Optional
- See Training Course Details...
Working with Methods
Navigating the Access Object Hierarchy
Considering Variable Scope and Lifetime Together
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Using Visual Basic Help
Understanding Expressions and Statements
Stepping through Code
Controlling Program Execution
Trapping Errors with the On Error Statement
Using Intrinsic Constants
Understanding Constants
Declaring and Creating Object Variables
Debugging Code
Working with the ADODB Recordset Object
Specifying a Recordset Cursor Type
Understanding Data Types
Using Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Holyhead
- 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 ... Aggregation Queries
- See Training Course Details...
Formatting Tables
Understanding VBA
Multi Table Queries
Sorting and Filtering
Getting to Know Access
Importing and Exporting Records
Creating and Using Macros
Creating a Lookup Database
Adding Transactional Records
Working With Records
An Introduction to VBA
Querying Techniques
Macros on Forms
Macro Techniques
Database Security
Creating and Using Forms
Calculations in Queries
Database Wellness
Relational Database Design
Data Validation
Email us about this courses
Other Holyhead Enable Technology Training Courses
VBA - Holyhead Excel Training Courses
Excel 365 Intermediate Holyhead Training Courses
SSRS Holyhead Training Courses
JavaScript Holyhead Training Courses
SSAS Holyhead Training Courses
Excel 365 Advanced Holyhead Training Courses