ACCESS TRAINING COURSES HYDE
About Enable Technology Hyde Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in Hyde. Every Access course can be modified to meet your bespoke requirements.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: TalkTalk Direct Limited, Homeserve PLC, Nuclear Engineering Services, Loughborough University, Wolverhampton City Council, Canadian High Commission, Halfords Group PLC and EDF Energy PLC.
Microsoft Access
- 2 day course
- Location: Hyde
- 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 ... Getting to Know Access
- See Training Course Details...
Database Wellness
Creating and Using Forms
Modifying Forms
Creating Queries
Working With Records
DIY Forms
Adding Records to a Table
Relational Database Design
Setting Table Relationships
Action Queries
Understanding VBA
Formatting Tables
Macro Techniques
Adding Transactional Records
An Introduction to VBA
Multi Table Queries
Calculations in Queries
Querying Techniques
Creating and Using Macros
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hyde
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Working with Variable Lifetime
- See Training Course Details...
Stepping through Code
Working with Variable Scope
Creating a Standard Module
Writing an Error-Handling Routine
Trapping Errors with the On Error Statement
Working with Recordsets
Using Input Boxes
Understanding Expressions and Statements
Using the Immediate Window to Call Procedures
Creating a Sub Procedure
Setting Break Expressions
Introduction to Programming in Access
Working with the Application Object
Using the With Statement
Working with Events
Controlling Program Execution
Understanding Collections
Working with Procedures and Functions
Email us about this courses
Other Hyde Enable Technology Training Courses
TSQL Hyde Training Courses
PL/SQL - Hyde SQL Training Courses
Excel 365 Intermediate Hyde Training Courses
SSIS - Hyde SQL Server Integration Services Training Courses
Power BI Hyde Training Courses
SSRS - Hyde SQL Server Reporting Services Training Courses