Enable Technology



About Enable Technology Coventry Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a socially distanced training location in Coventry. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your 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. Our clients include: Nationwide Building Society Limited, South Staffordshire Water PLC, National Power PLC, Norwich Union PLC, Countrywide Homes Limited, Wolverhampton City Council, Barclays Bank PLC and Boots UK Limited.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Coventry
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Using the For Each...Next Structure
    Determining the Value of Expressions
    Understanding Procedures
    Understanding Modules
    Using Input Boxes
    Understanding the Form Object
    Working with the Code Editor
    Understanding Error Handling
    Working with Variable Lifetime
    Considering Variable Scope and Lifetime Together
    Understanding Classes and Objects
    Understanding Expressions and Statements
    Specifying a Recordset Cursor Type
    Creating a Standard Module
    Understanding Errors
    Understanding Recordset Cursor Properties - Optional
    Using Expressions, Variables, and Intrinsic Functions
    Declaring Variables
    Using Intrinsic Constants

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Coventry
  • 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 ...
  • Adding Transactional Records
    Creating and Using Reports
    Calculations in Queries
    Macro Techniques
    Formatting Tables
    Database Security
    Using a Navigation Form
    Creating Queries
    Multi Table Queries
    Querying Techniques
    Adding Records to a Table
    An Introduction to VBA
    Data Validation
    Macros on Forms
    Creating and Using Macros
    Creating a Lookup Database
    DIY Forms
    Aggregation Queries
    Setting Table Relationships
    Importing and Exporting Records
    Action Queries

  • See Training Course Details...

Email us about this courses

Other Coventry Enable Technology Training Courses

SSAS - Coventry SQL Server Analysis Services Training Courses
VBA - Coventry Excel Training Courses
JavaScript Coventry Training Courses
Report Builder Coventry Training Courses
Power BI Coventry Training Courses
Power Query - Coventry Excel Training Courses