Enable Technology



About Enable Technology Warrington Access Training Courses

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

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Warrington. All Access courses can be customised to meet your particular requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Unipart Group, Norwich Union PLC, National Power PLC, Barclays Bank PLC, Cadbury PLC, Queen's Medical Centre Nottingham, Fujistu PLC and Birmingham Heartlands Hospital.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Warrington
  • 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 ...
  • Using Intrinsic Functions
    Working with the Application Object
    Using the Select Case...End Select Structure
    Organizing Code and Procedures
    Handling Errors
    Setting Breakpoints
    Controlling Program Execution
    Creating a Sub Procedure
    Locking Records for Updating
    Understanding Objects
    Declaring Variables
    Understanding Control-of-Flow Structures
    Understanding the DoCmd Object
    Using the With Statement
    Guidelines for use of Branching Structures
    Understanding the Err Object
    Understanding the Development Environment
    Using the Do...Loop Structure

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Warrington
  • 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 ...
  • Calculations in Queries
    Importing and Exporting Records
    Working With Records
    Multi Table Queries
    Adding Transactional Records
    Macros on Forms
    Action Queries
    Formatting Tables
    Sorting and Filtering
    Data Validation
    Parameter Queries
    Modifying Forms
    Creating and Using Forms
    Navigation Pane Protection
    Creating and Using Reports
    Understanding VBA
    Using a Navigation Form
    Database Security
    Querying Techniques
    Creating a Lookup Database
    Adding Records to a Table

  • See Training Course Details...

Email us about this courses

Other Warrington Enable Technology Training Courses

Report Builder - Warrington SQL Server Reporting Services Training Courses
Power Query Warrington Training Courses
Excel 365 Advanced - Warrington Excel Training Courses
Power BI - Warrington Microsoft Power BI Training Courses
Excel Power Pivot - Warrington Excel Training Courses
Excel 365 Intermediate Warrington Training Courses