Enable Technology



About Enable Technology Bryn Pydew Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to 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.

Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local socially distanced training site in Bryn Pydew. 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are EDF Energy PLC, Keele University, Barclays Bank PLC, West Bromwich Building Society, Fujistu PLC, Capita Group PLC, GKN PLC and Birmingham Heartlands Hospital.

Microsoft Access

  • 2 day course
  • Location: Bryn Pydew
  • 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 ...
  • Multi Table Queries
    DIY Forms
    Calculations in Queries
    Aggregation Queries
    Creating and Using Macros
    Creating and Using Reports
    Data Validation
    Creating a Lookup Database
    Database Wellness
    Creating and Using Forms
    Getting to Know Access 
    Using a Navigation Form
    Parameter Queries
    Working With Records
    Navigation Pane Protection
    Action Queries
    Adding Transactional Records
    Relational Database Design
    Modifying Table Structures
    Querying Techniques
    Formatting Tables

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bryn Pydew
  • 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 ...
  • Determining the Value of Expressions
    Using Break Mode during Run Mode
    Declaring Variables
    Understanding Constants
    Using the CacheSize Property - Optional
    Understanding Procedures
    Considering Variable Scope and Lifetime Together
    Working with Methods
    Using the Do...Loop Structure
    Organizing Code and Procedures
    Understanding the Development Environment
    Understanding the Form Object
    Working with Recordsets
    Using the With Statement
    Why Program in Access?
    Setting Breakpoints
    Understanding Modules
    Working with the Code Editor
    Introduction to Programming in Access
    Working with Inline Error Handling
    Understanding Expressions and Statements

  • See Training Course Details...

Email us about this courses

Other Bryn Pydew Enable Technology Training Courses

SSIS Bryn Pydew Training Courses
DAX Bryn Pydew Training Courses
PL/SQL - Bryn Pydew SQL Training Courses
Excel 365 Intermediate Bryn Pydew Training Courses
JQuery Mobile - Bryn Pydew JavaScript Training Courses
Excel Power Pivot - Bryn Pydew Excel Training Courses