Enable Technology



About Enable Technology Midlands Access Training Courses

We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. This instructor led course is available online only during the current lockdown. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor. Every Access course can me modified to meet your bespoke requirements.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Nuclear Engineering Services, Carillion PLC, Birmingham City University, Royal & Sun Alliance Group PLC, GKN PLC, Norwich Union PLC, Total Telecommunications Limited and Birmingham City Council.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Midlands
  • Telephone on 01952 305730
  • 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 ...
  • Using the Do...Loop Structure
    Working with Methods
    Understanding Data Types
    Trapping Errors with the On Error Statement
    Creating a Sub Procedure
    Introduction to Programming in Access
    Working with Variable Lifetime
    Guidelines for use of Branching Structures
    Understanding Classes and Objects
    Understanding Errors
    Using the Immediate Window to Call Procedures
    Understanding the Development Environment
    Setting Breakpoints
    Considering Variable Scope and Lifetime Together
    Using the Object Browser
    Controlling Program Execution
    Understanding Control-of-Flow Structures
    Using the CacheSize Property - Optional
    Naming Procedures

  • See Training Course Details...

Microsoft Access

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

  • See Training Course Details...

Email us about this courses

Other Midlands Enable Technology Training Courses

Visio 2013 Midlands Training Courses
JavaScript - Midlands JavaScript Training Courses
SSAS 2005 Midlands Training Courses
SQL - Midlands SQL Training Courses
Oracle SQL - Midlands SQL Training Courses
Microsoft Project Level 3 Midlands Training Courses

Midlands - Possible Access Training Course Locations

Wolverhampton, Hereford, Rowley, Leicester, Nottingham, Lichfield, Solihull, Redditch, Derby, Rugby, Newcastle Under Lyme, Milton Keynes, Leicestershire, West Midlands, Stourbridge, Droitwich, Bedworth, Stourbridge, Shropshire, Chester, Northhampton, Shrewsbury, Burton On Trent, Leek, Malvern, Midlands, East Midlands, Black Country, Halesowen, Cheltenham, Oxford, Dudley, Bridgnorth, West Bromwich, Staffordshire, Uttoxeter, Kidderminster, Herefordshire, Kenilworth, Cannock, Staffordshire, Bromsgrove, Crewe, Stafford, Kidsgrove, Walsall, Nuneaton, Smethwick, Worcester, Wednesbury, Sandwell, Leamington Spa, Warwickshire, Atherstone, Coventry, Stratford Upon Avon, Worcestershire, Stoke On Trent, Telford, Rugeley, Tipton, Evesham, Birmingham, Oswestry, Warwick, Tamworth