ACCESS TRAINING COURSES POWYS
About Enable Technology Powys Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a socially distanced venue near you in Powys. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Barclays Bank PLC, University of Birmingham, Nationwide Building Society Limited, Homeserve PLC, Lloyds TSB Bank PLC, Dollond & Aitchison Limited, Loughborough University and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Powys
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Adding Transactional Records
- See Training Course Details...
Formatting Tables
Creating and Using Reports
Querying Techniques
Data Validation
Modifying Table Structures
Creating a Lookup Database
Creating Queries
Understanding VBA
Modifying Forms
Navigation Pane Protection
Multi Table Queries
Action Queries
Using a Navigation Form
Importing and Exporting Records
Getting to Know Access
Creating and Using Forms
Working With Records
Creating a Relational Database
Database Security
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Powys
- 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 ... Using Debugging Tools
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Working with Events
Understanding Modules
Working with Inline Error Handling
Using Expressions, Variables, and Intrinsic Functions
Using the For Each...Next Structure
Organizing Code and Procedures
Stepping through Code
Working with Boolean Expressions
Understanding the Order of Events
Writing an Error-Handling Routine
Understanding Recordset Cursor Properties - Optional
Working with the ADODB Recordset Object
Working with Procedures and Functions
Working with Methods
Creating a Sub Procedure
Setting Break Expressions
Introduction to Programming in Access
Navigating the Access Object Hierarchy
Email us about this courses
Other Powys Enable Technology Training Courses
Oracle SQL - Powys SQL Training Courses
TSQL Powys Training Courses
SSIS - Powys SQL Server Integration Services Training Courses
VBA Powys Training Courses
Excel 365 Intermediate Powys Training Courses
Power BI - Powys Microsoft Power BI Training Courses