Enable Technology



About Enable Technology Abergavenny Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If you prefer we can offer an offsite socially distanced training location in Abergavenny. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Barclays Bank PLC, Boots UK Limited, Norwich Union PLC, Birmingham City Council, South Staffordshire Water PLC, Norfolk Police Constabulary, Total Telecommunications Limited and Halfords Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Abergavenny
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Understanding the Form Object
    Working with the ADODB Recordset Object
    Working with Inline Error Handling
    Using Visual Basic Help
    Understanding Recordset Cursor Properties - Optional
    Understanding the Development Environment
    Understanding Modules
    Using the For Each...Next Structure
    Understanding VBA's Error Trapping Options
    Understanding the DoCmd Object
    Guidelines for use of Branching Structures
    Creating a Sub Procedure
    Using Intrinsic Constants
    Introduction to Programming in Access
    Setting Breakpoints
    Understanding Collections
    Understanding Objects
    Using Debugging Tools
    Working with Variable Scope
    Using Input Boxes
    Working with Methods

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Abergavenny
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Working With Records
    Creating and Using Reports
    Data Validation
    Multi Table Queries
    Sorting and Filtering
    Adding Records to a Table
    Setting Table Relationships
    Querying Techniques
    Calculations in Queries
    Modifying Table Structures
    Aggregation Queries
    Database Security
    Database Wellness
    DIY Forms
    Creating a Lookup Database
    Designing a Lookup Database
    An Introduction to VBA
    Creating a Relational Database
    Understanding VBA
    Creating and Using Macros
    Creating and Using Forms

  • See Training Course Details...

Email us about this courses

Other Abergavenny Enable Technology Training Courses

Excel 365 Advanced Abergavenny Training Courses
TSQL Abergavenny Training Courses
JQuery Abergavenny Training Courses
Power Query Abergavenny Training Courses
SSAS Abergavenny Training Courses
PL/SQL Abergavenny Training Courses