ACCESS TRAINING COURSES MOLD
About Enable Technology Mold Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. 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 training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. If delivery onsite is an issue we will organise a venue near you in Mold. 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Nationwide Building Society Limited, Norwich Union PLC, Birmingham City Council, Shell UK Oil Products Ltd, Wolverhampton City Council, Vodafone Group Services, GKN PLC and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Mold
- 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 ... Setting Table Relationships
- See Training Course Details...
Creating a Lookup Database
Parameter Queries
Database Security
Adding Records to a Table
Understanding VBA
Creating and Using Forms
Creating a Relational Database
Getting to Know Access
Modifying Table Structures
Sorting and Filtering
Designing a Lookup Database
Macros on Forms
Relational Database Design
Importing and Exporting Records
Data Validation
Working With Records
Using a Navigation Form
Multi Table Queries
Formatting Tables
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mold
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Declaring Variables
- See Training Course Details...
Declaring and Creating Object Variables
Using the Do...Loop Structure
Determining the Value of Expressions
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Debugging Code
Using Input Boxes
Working with the Code Editor
Understanding VBA's Error Trapping Options
Controlling Program Execution
Using the Object Browser
Using the For Each...Next Structure
Using Expressions, Variables, and Intrinsic Functions
Working with Procedures and Functions
Understanding Data Types
Understanding Recordset Cursor Properties - Optional
Email us about this courses
Other Mold Enable Technology Training Courses
Power Query Mold Training Courses
JQuery Mobile Mold Training Courses
Oracle SQL - Mold SQL Training Courses
SSRS Mold Training Courses
Data Warehouse - Mold SQL Training Courses
JQuery - Mold JavaScript Training Courses