Enable Technology



About Enable Technology Gwent 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. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a socially distanced venue near you in Gwent. All Access courses can be customised to meet your particular requirements.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Canadian High Commission, Nationwide Building Society Limited, Vodafone Group Services, University of Birmingham, Capita Group PLC, Nuclear Engineering Services, Birmingham City Council and Queen's Medical Centre Nottingham.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gwent
  • 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 ...
  • Setting Breakpoints
    Using the For Each...Next Structure
    Working with the Code Editor
    Using Break Mode during Run Mode
    Working with Properties
    Understanding the Form Object
    Understanding the DoCmd Object
    Creating a Function Procedure
    Specifying a Recordset Cursor Location - Optional
    Using the Do...Loop Structure
    Using the For...Next Structure
    Understanding Errors
    Working with Events
    Working with Procedures and Functions
    Setting Break Expressions
    Understanding Control-of-Flow Structures
    Specifying a Recordset Cursor Type

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Gwent
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Adding Records to a Table
    Macro Techniques
    Multi Table Queries
    Formatting Tables
    Calculations in Queries
    Getting to Know Access 
    Creating a Lookup Database
    An Introduction to VBA
    Creating and Using Reports
    Querying Techniques
    DIY Forms
    Creating a Relational Database
    Working With Records
    Action Queries
    Creating Queries
    Creating and Using Macros
    Designing a Lookup Database
    Setting Table Relationships
    Creating and Using Forms
    Using a Navigation Form
    Relational Database Design

  • See Training Course Details...

Email us about this courses

Other Gwent Enable Technology Training Courses

SSAS Tabular Gwent Training Courses
JQuery Mobile - Gwent JavaScript Training Courses
Power BI Gwent Training Courses
Oracle SQL - Gwent SQL Training Courses
Excel 365 Basic - Gwent Excel Training Courses
Power Query - Gwent Excel Training Courses