Enable Technology



About Enable Technology Llantrisant Access Training Courses

We have a twenty year history of providing skills based Access industry training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Llantrisant. The Access syllabus can be adjusted and additional topics incorporated if helpful.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Wolverhampton City Council, Queen's Medical Centre Nottingham, West Bromwich Building Society, Lloyds TSB Bank PLC, Nuclear Engineering Services, Barclays Bank PLC, TalkTalk Direct Limited and Royal & Sun Alliance Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Llantrisant
  • 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 Objects
    Understanding Procedures
    Understanding the DoCmd Object
    Introduction to Programming in Access
    Working with Boolean Expressions
    Understanding VBA's Error Trapping Options
    Considering Variable Scope and Lifetime Together
    Understanding Constants
    Working with Methods
    Understanding the Err Object
    Working with Variable Scope
    Declaring Variables
    Working with Inline Error Handling
    Organizing Code and Procedures
    Locking Records for Updating
    Working with Events
    Understanding Data Types
    Using Message Boxes
    Using the Object Browser
    Setting Breakpoints
    Why Program in Access?

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Llantrisant
  • 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 ...
  • Creating a Lookup Database
    Data Validation
    An Introduction to VBA
    Creating and Using Forms
    Creating a Relational Database
    Creating and Using Macros
    Sorting and Filtering
    Formatting Tables
    Database Security
    Importing and Exporting Records
    Querying Techniques
    Calculations in Queries
    Modifying Forms
    Relational Database Design
    Macro Techniques
    Action Queries
    Setting Table Relationships
    Using a Navigation Form
    Adding Records to a Table
    Database Wellness
    Aggregation Queries

  • See Training Course Details...

Email us about this courses

Other Llantrisant Enable Technology Training Courses

SSRS Llantrisant Training Courses
SQL - Llantrisant SQL Training Courses
DAX Llantrisant Training Courses
VBA - Llantrisant Excel Training Courses
TSQL - Llantrisant SQL Training Courses
Power Query - Llantrisant Excel Training Courses