ACCESS TRAINING COURSES WETHERBY
About Enable Technology Wetherby Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. 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 offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a venue near you in Wetherby. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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. Our clients include: Halfords Group PLC, Royal Air Force, Birmingham City University, Nuclear Engineering Services, Cadbury PLC, Keele University, Royal & Sun Alliance Group PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Wetherby
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Modifying Forms
- See Training Course Details...
Setting Table Relationships
Relational Database Design
DIY Forms
Aggregation Queries
Macro Techniques
Database Wellness
Creating and Using Macros
Formatting Tables
Multi Table Queries
Sorting and Filtering
Getting to Know Access
Adding Records to a Table
Querying Techniques
Action Queries
Importing and Exporting Records
Creating and Using Forms
Calculations in Queries
Working With Records
Using a Navigation Form
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wetherby
- 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 ... Using Input Boxes
- See Training Course Details...
Using the Immediate Window to Call Procedures
Understanding Control-of-Flow Structures
Understanding Classes and Objects
Understanding the Form Object
Working with Inline Error Handling
Setting Break Expressions
Using Debugging Tools
Understanding the Err Object
Handling Errors
Why Program in Access?
Calling Procedures
Using the If...End If Decision Structures
Creating a Standard Module
Trapping Errors with the On Error Statement
Considering Variable Scope and Lifetime Together
Understanding Collections
Using the Do...Loop Structure
Controlling Program Execution
Understanding the Order of Events
Email us about this courses
Other Wetherby Enable Technology Training Courses
JQuery Wetherby Training Courses
SQL Wetherby Training Courses
SSRS - Wetherby SQL Server Reporting Services Training Courses
Excel 365 Advanced Wetherby Training Courses
Data Warehouse - Wetherby SQL Training Courses
SSAS Wetherby Training Courses