Enable Technology



About Enable Technology Cil-y-coed Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training 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.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Unipart Group, Vodafone Group Services, Birmingham City Council, Keele University, Boots UK Limited, Dollond & Aitchison Limited, University of Birmingham and Loughborough University.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cil-y-coed
  • 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 ...
  • Controlling Program Execution
    Using Message Boxes
    Working with Procedures and Functions
    Organizing Code and Procedures
    Setting Break Expressions
    Using Break Mode during Run Mode
    Understanding the DoCmd Object
    Considering Variable Scope and Lifetime Together
    Trapping Errors with the On Error Statement
    Understanding Procedures
    Understanding Expressions and Statements
    Using Intrinsic Constants
    Guidelines for use of Branching Structures
    Specifying a Recordset Cursor Type
    Using the Object Browser
    Why Program in Access?
    Naming Procedures
    Specifying a Recordset Cursor Location - Optional
    Understanding VBA's Error Trapping Options

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Modifying Forms
    Querying Techniques
    Multi Table Queries
    Database Security
    Macro Techniques
    Creating a Lookup Database
    Parameter Queries
    Creating and Using Forms
    Adding Records to a Table
    Creating Queries
    Aggregation Queries
    An Introduction to VBA
    Working With Records
    Macros on Forms
    Creating and Using Macros
    Relational Database Design
    Setting Table Relationships
    Adding Transactional Records
    Data Validation
    Formatting Tables
    Calculations in Queries

  • See Training Course Details...

Email us about this courses

Other Cil-y-coed Enable Technology Training Courses

Excel 365 Intermediate - Cil-y-coed Excel Training Courses
Power BI Cil-y-coed Training Courses
VBA - Cil-y-coed Excel Training Courses
Data Warehouse - Cil-y-coed SQL Training Courses
JQuery Mobile - Cil-y-coed JavaScript Training Courses
JavaScript - Cil-y-coed JavaScript Training Courses