Enable Technology



About Enable Technology Worcestershire Access Training Courses

Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Worcestershire. 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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Norwich Union PLC, Loughborough University, Capita Group PLC, Birmingham City University, Nationwide Building Society Limited, Total Telecommunications Limited, Nuclear Engineering Services and Birmingham City Council.

Microsoft Access

  • 2 day course
  • Location: Worcestershire
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Macros on Forms
    Adding Records to a Table
    Database Security
    DIY Forms
    Calculations in Queries
    Designing a Lookup Database
    Adding Transactional Records
    Modifying Forms
    Working With Records
    Formatting Tables
    Sorting and Filtering
    Querying Techniques
    Creating a Lookup Database
    Creating and Using Forms
    Importing and Exporting Records
    Creating and Using Reports
    Navigation Pane Protection
    Relational Database Design
    Database Wellness
    Multi Table Queries
    Creating a Relational Database

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Worcestershire
  • 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 ...
  • Working with Inline Error Handling
    Working with Variable Scope
    Understanding Collections
    Working with Procedures and Functions
    Understanding the Development Environment
    Working with Variable Lifetime
    Specifying a Recordset Cursor Location - Optional
    Navigating the Access Object Hierarchy
    Working with Events
    Using the Do...Loop Structure
    Understanding the Order of Events
    Using the For Each...Next Structure
    Creating a Sub Procedure
    Setting Breakpoints
    Understanding Constants
    Using the Immediate Window to Call Procedures
    Why Program in Access?
    Calling Procedures

  • See Training Course Details...

Email us about this courses

Other Worcestershire Enable Technology Training Courses

SSAS - Worcestershire SQL Server Analysis Services Training Courses
JavaScript Worcestershire Training Courses
Power Query Worcestershire Training Courses
VBA Worcestershire Training Courses
Excel Power Pivot Worcestershire Training Courses
Data Warehouse - Worcestershire SQL Training Courses