Enable Technology

ACCESS GLOUCESTER TRAINING COURSES 

ACCESS TRAINING COURSES GLOUCESTER




About Enable Technology Gloucester Access Training Courses

Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Access training courses onsite at your premises. If you prefer we can offer an offsite socially distanced training location in Gloucester. The Access syllabus can be modified to accommodate your specific 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 Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: TalkTalk Direct Limited, Capita Group PLC, Royal Air Force, Nuclear Engineering Services, Total Telecommunications Limited, Royal & Sun Alliance Group PLC, Shell UK Oil Products Ltd and Queen's Medical Centre Nottingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gloucester
  • Telephone on 01952 305730
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Using the CacheSize Property - Optional
    Working with the Application Object
    Using Break Mode during Run Mode
    Navigating the Access Object Hierarchy
    Using the Immediate Window to Call Procedures
    Understanding Procedures
    Working with Variable Scope
    Understanding Modules
    Organizing Code and Procedures
    Using the If...End If Decision Structures
    Using the For...Next Structure
    Using the Object Browser
    Understanding the Form Object
    Understanding Recordset Cursor Properties - Optional
    Understanding Error Handling
    Understanding the Development Environment
    Introduction to Programming in Access
    Writing an Error-Handling Routine

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Gloucester
  • Telephone on 01952 305730
  • 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 ...
  • Creating and Using Forms
    Adding Transactional Records
    Working With Records
    Relational Database Design
    Database Wellness
    Setting Table Relationships
    Understanding VBA
    Using a Navigation Form
    Action Queries
    Calculations in Queries
    Data Validation
    Formatting Tables
    Database Security
    DIY Forms
    Creating a Relational Database
    Aggregation Queries
    Modifying Table Structures
    Multi Table Queries
    An Introduction to VBA
    Designing a Lookup Database
    Sorting and Filtering

  • See Training Course Details...



Email us about this courses



Other Gloucester Enable Technology Training Courses

SSAS 2005 - Gloucester SQL Server Analysis Services Training Courses
JavaScript Gloucester Training Courses
SSRS 2005 - Gloucester SQL Server Reporting Services Training Courses
JQuery Mobile Gloucester Training Courses
SSAS Tabular - Gloucester SQL Server Analysis Services Training Courses
SSRS 2016 - Gloucester SQL Server Reporting Services Training Courses



South West - Possible Access Training Course Locations


Trowbridge Access Training Courses
Bath Access Training Courses
Cirencester Access Training Courses
Exeter Access Training Courses
Bournemouth Access Training Courses
Somerset Access Training Courses
Tewkesbury Access Training Courses
Poole Access Training Courses
Devon Access Training Courses
Dorset Access Training Courses
Chippenham Access Training Courses
South West Access Training Courses
Cheltenham Access Training Courses
Wells Access Training Courses
Christchurch Access Training Courses
Swindon Access Training Courses
Torquay Access Training Courses
Taunton Access Training Courses
Bristol Access Training Courses
Dorchester Access Training Courses
Wiltshire Access Training Courses
Yoevil Access Training Courses
Plymouth Access Training Courses
Stroud Access Training Courses
Gloucestershire Access Training Courses
Weymouth Access Training Courses
Gloucester Access Training Courses
Salisbury Access Training Courses

Trowbridge, Bath, Cirencester, Exeter, Bournemouth, Somerset, Tewkesbury, Poole, Devon, Dorset, Chippenham, South West, Cheltenham, Wells, Christchurch, Swindon, Torquay, Taunton, Bristol, Dorchester, Wiltshire, Yoevil, Plymouth, Stroud, Gloucestershire, Weymouth, Gloucester, Salisbury