ACCESS TRAINING COURSES DEWSBURY
About Enable Technology Dewsbury 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). Every course participant will receives course practice files and Access course resources that can be referenced post 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 offers instructor led training taught by technology specialists. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a Access course at an alternative training site in Dewsbury. We are happy to modify the Access syllabus to match your teams 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, National Power PLC, GKN PLC, Lloyds TSB Bank PLC, Vodafone Group Services, Birmingham Heartlands Hospital, Birmingham City Council and Halfords Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dewsbury
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Writing an Error-Handling Routine
Naming Procedures
Understanding Expressions and Statements
Understanding Constants
Understanding the DoCmd Object
Using Message Boxes
Understanding the Err Object
Working with Properties
Understanding Errors
Using Expressions, Variables, and Intrinsic Functions
Understanding the Order of Events
Considering Variable Scope and Lifetime Together
Creating a Sub Procedure
Navigating the Access Object Hierarchy
Understanding the Development Environment
Working with the ADODB Recordset Object
Understanding VBA's Error Trapping Options
Organizing Code and Procedures
Using Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Dewsbury
- 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 ... Relational Database Design
- See Training Course Details...
An Introduction to VBA
DIY Forms
Creating and Using Reports
Importing and Exporting Records
Navigation Pane Protection
Sorting and Filtering
Querying Techniques
Multi Table Queries
Creating a Lookup Database
Calculations in Queries
Action Queries
Adding Records to a Table
Designing a Lookup Database
Creating and Using Forms
Macros on Forms
Using a Navigation Form
Formatting Tables
Working With Records
Aggregation Queries
Modifying Table Structures
Email us about this courses
Other Dewsbury Enable Technology Training Courses
Power Query - Dewsbury Excel Training Courses
SSAS - Dewsbury SQL Server Analysis Services Training Courses
SSIS - Dewsbury SQL Server Integration Services Training Courses
Oracle SQL Dewsbury Training Courses
Data Warehouse Dewsbury Training Courses
SQL - Dewsbury SQL Training Courses