ACCESS TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a local training venue in Black Country. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Fujistu PLC, EDF Energy PLC, Homeserve PLC, Nuclear Engineering Services, Birmingham City Council, GKN PLC, Canadian High Commission and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Black Country
- 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 ... Macros on Forms
- See Training Course Details...
Creating and Using Reports
Multi Table Queries
Database Security
Modifying Table Structures
Action Queries
Creating a Lookup Database
Designing a Lookup Database
Querying Techniques
Setting Table Relationships
Sorting and Filtering
Creating and Using Forms
An Introduction to VBA
Importing and Exporting Records
Using a Navigation Form
Calculations in Queries
Creating Queries
Getting to Know Access
Relational Database Design
Macro Techniques
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Black Country
- 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...
Using the For...Next Structure
Understanding the Order of Events
Working with the Application Object
Creating a Function Procedure
Specifying a Recordset Cursor Location - Optional
Understanding Objects
Working with the Code Editor
Creating a Standard Module
Understanding VBA's Error Trapping Options
Why Program in Access?
Stepping through Code
Trapping Errors with the On Error Statement
Using the Do...Loop Structure
Using Expressions, Variables, and Intrinsic Functions
Understanding Control-of-Flow Structures
Using Visual Basic Help
Understanding Collections
Guidelines for use of Branching Structures
Understanding the Err Object
Email us about this courses
Other Black Country Enable Technology Training Courses
SSAS - Black Country SQL Server Analysis Services Training Courses
SSRS Black Country Training Courses
SSAS Tabular Black Country Training Courses
Data Warehouse - Black Country SQL Training Courses
JQuery Black Country Training Courses
DAX - Black Country Excel Training Courses