ACCESS TRAINING COURSES SADDLEWORTH
About Enable Technology Saddleworth Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a venue near you in Saddleworth. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Cadbury PLC, Norfolk Police Constabulary, Royal Air Force, Halfords Group PLC, Canadian High Commission, Birmingham Heartlands Hospital, Dollond & Aitchison Limited and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Saddleworth
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Setting Break Expressions
- See Training Course Details...
Understanding Error Handling
Working with Methods
Understanding Data Types
Using the If...End If Decision Structures
Debugging Code
Navigating the Access Object Hierarchy
Using the For...Next Structure
Declaring and Creating Object Variables
Using Message Boxes
Stepping through Code
Understanding VBA's Error Trapping Options
Working with Variable Scope
Handling Errors
Setting Breakpoints
Understanding the Form Object
Controlling Program Execution
Using the Immediate Window to Call Procedures
Working with Recordsets
Microsoft Access
- 2 day course
- Location: Saddleworth
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Multi Table Queries
Creating and Using Forms
Creating a Lookup Database
Adding Transactional Records
Macro Techniques
Using a Navigation Form
Setting Table Relationships
Creating and Using Macros
Database Wellness
Macros on Forms
Database Security
Creating a Relational Database
Action Queries
Understanding VBA
Querying Techniques
Working With Records
Relational Database Design
Sorting and Filtering
Modifying Table Structures
Data Validation
Email us about this courses
Other Saddleworth Enable Technology Training Courses
TSQL - Saddleworth SQL Training Courses
SSIS - Saddleworth SQL Server Integration Services Training Courses
JavaScript Saddleworth Training Courses
JQuery Mobile Saddleworth Training Courses
SSAS - Saddleworth SQL Server Analysis Services Training Courses
Power BI Saddleworth Training Courses