ACCESS TRAINING COURSES TREDEGAR
About Enable Technology Tredegar Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. Another option is we can organise a local training site in Tredegar. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Cadbury PLC, Unipart Group, Birmingham Heartlands Hospital, Birmingham City Council, Total Telecommunications Limited, Wolverhampton City Council, West Bromwich Building Society and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Tredegar
- 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 ... Aggregation Queries
- See Training Course Details...
An Introduction to VBA
Relational Database Design
Using a Navigation Form
Modifying Table Structures
Database Wellness
Creating a Lookup Database
Database Security
Action Queries
Navigation Pane Protection
Creating a Relational Database
Creating and Using Forms
Multi Table Queries
Data Validation
Querying Techniques
Getting to Know Access
Creating and Using Macros
Macro Techniques
Creating Queries
Designing a Lookup Database
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tredegar
- 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 ... Understanding Constants
- See Training Course Details...
Using Input Boxes
Understanding Error Handling
Working with Variable Lifetime
Understanding Classes and Objects
Understanding the Order of Events
Understanding Recordset Cursor Properties - Optional
Creating a Standard Module
Understanding Collections
Controlling Program Execution
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Constants
Guidelines for use of Branching Structures
Using the CacheSize Property - Optional
Using the For...Next Structure
Understanding the Development Environment
Declaring and Creating Object Variables
Declaring Variables
Using the For Each...Next Structure
Understanding the DoCmd Object
Email us about this courses
Other Tredegar Enable Technology Training Courses
Excel 365 Basic Tredegar Training Courses
SSRS - Tredegar SQL Server Reporting Services Training Courses
SSIS Tredegar Training Courses
Excel 365 Intermediate Tredegar Training Courses
TSQL - Tredegar SQL Training Courses
Power BI - Tredegar Microsoft Power BI Training Courses