ACCESS TRAINING COURSES HYDE
About Enable Technology Hyde Access Training Courses
Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local training site in Hyde. We are happy to discuss customising the course content should you have particular Access training requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norwich Union PLC, Birmingham Heartlands Hospital, Vodafone Group Services, Total Telecommunications Limited, Halfords Group PLC, TalkTalk Direct Limited, Nationwide Building Society Limited and Boots UK Limited.
Microsoft Access
- 2 day course
- Location: Hyde
- 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 ... Creating a Relational Database
- See Training Course Details...
Creating a Lookup Database
Creating Queries
Creating and Using Macros
Understanding VBA
Using a Navigation Form
Calculations in Queries
Designing a Lookup Database
Sorting and Filtering
Creating and Using Reports
Action Queries
DIY Forms
Navigation Pane Protection
Adding Transactional Records
Parameter Queries
Multi Table Queries
Formatting Tables
Modifying Table Structures
Getting to Know Access
Creating and Using Forms
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hyde
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Working with Methods
- See Training Course Details...
Creating a Sub Procedure
Understanding the Form Object
Understanding Procedures
Stepping through Code
Declaring Variables
Creating a Standard Module
Setting Break Expressions
Writing an Error-Handling Routine
Working with Recordsets
Understanding Data Types
Determining the Value of Expressions
Guidelines for use of Branching Structures
Using the Select Case...End Select Structure
Understanding Error Handling
Navigating the Access Object Hierarchy
Understanding the DoCmd Object
Introduction to Programming in Access
Debugging Code
Email us about this courses
Other Hyde Enable Technology Training Courses
Report Builder - Hyde SQL Server Reporting Services Training Courses
SSIS Hyde Training Courses
JQuery Hyde Training Courses
DAX Hyde Training Courses
Excel 365 Advanced - Hyde Excel Training Courses
Power BI Hyde Training Courses