Enable Technology



About Enable Technology Bath Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another option is we can organise a local socially distanced training site in Bath. 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.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are West Bromwich Building Society, University of Birmingham, Loughborough University, GKN PLC, Halfords Group PLC, Yell Group PLC, Dollond & Aitchison Limited and Birmingham City University.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bath
  • 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 ...
  • Understanding the Err Object
    Understanding Expressions and Statements
    Guidelines for use of Branching Structures
    Determining the Value of Expressions
    Using the For Each...Next Structure
    Using the Immediate Window to Call Procedures
    Using the With Statement
    Understanding the Development Environment
    Specifying a Recordset Cursor Location - Optional
    Working with Variable Scope
    Naming Procedures
    Using the Object Browser
    Working with Recordsets
    Working with Variable Lifetime
    Locking Records for Updating
    Considering Variable Scope and Lifetime Together
    Understanding Constants
    Working with the Application Object
    Organizing Code and Procedures
    Why Program in Access?

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Bath
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Database Security
    Modifying Forms
    Creating a Lookup Database
    Adding Transactional Records
    Parameter Queries
    Querying Techniques
    Understanding VBA
    Formatting Tables
    Multi Table Queries
    Calculations in Queries
    Using a Navigation Form
    Adding Records to a Table
    Creating and Using Macros
    Macros on Forms
    Relational Database Design
    An Introduction to VBA
    DIY Forms
    Sorting and Filtering
    Database Wellness
    Modifying Table Structures
    Setting Table Relationships

  • See Training Course Details...

Email us about this courses

Other Bath Enable Technology Training Courses

PL/SQL - Bath SQL Training Courses
VBA Bath Training Courses
DAX Bath Training Courses
SQL - Bath SQL Training Courses
SSIS Bath Training Courses
Power BI - Bath Microsoft Power BI Training Courses