Enable Technology



About Enable Technology Carmarthen Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based 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. 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.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Carmarthen. 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. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are EDF Energy PLC, Royal & Sun Alliance Group PLC, Capita Group PLC, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Loughborough University, Fujistu PLC and Cadbury PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Carmarthen
  • Telephone on 01952 938014
  • 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 CacheSize Property - Optional
    Considering Variable Scope and Lifetime Together
    Working with Variable Scope
    Understanding VBA's Error Trapping Options
    Understanding Expressions and Statements
    Specifying a Recordset Cursor Type
    Understanding the DoCmd Object
    Specifying a Recordset Cursor Location - Optional
    Working with Variable Lifetime
    Using Input Boxes
    Creating a Sub Procedure
    Setting Break Expressions
    Creating a Function Procedure
    Working with Methods
    Using Intrinsic Functions
    Understanding the Err Object
    Creating a Standard Module
    Understanding the Form Object

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Carmarthen
  • 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 ...
  • Setting Table Relationships
    Creating a Relational Database
    Navigation Pane Protection
    DIY Forms
    Modifying Forms
    Creating and Using Macros
    Getting to Know Access 
    Importing and Exporting Records
    Calculations in Queries
    Modifying Table Structures
    Creating a Lookup Database
    Working With Records
    Parameter Queries
    Adding Transactional Records
    Multi Table Queries
    Understanding VBA
    Sorting and Filtering
    Creating Queries
    Database Security
    Creating and Using Reports
    Using a Navigation Form

  • See Training Course Details...

Email us about this courses

Other Carmarthen Enable Technology Training Courses

JQuery Carmarthen Training Courses
PL/SQL Carmarthen Training Courses
JavaScript Carmarthen Training Courses
TSQL - Carmarthen SQL Training Courses
SSAS Tabular - Carmarthen SQL Server Analysis Services Training Courses
Data Warehouse - Carmarthen SQL Training Courses