Enable Technology



About Enable Technology Crosby Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can refer to after the course. 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. We can bring the equipment necessary to deliver Access courses at your site. Alternatively we could schedule a course at a local socially distanced venue in Crosby. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time 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 Cadbury PLC, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, EDF Energy PLC, National Power PLC, Royal & Sun Alliance Group PLC, TalkTalk Direct Limited and Birmingham City Council.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Crosby
  • 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
    Understanding Procedures
    Using Message Boxes
    Using the If...End If Decision Structures
    Using the For...Next Structure
    Trapping Errors with the On Error Statement
    Understanding Constants
    Guidelines for use of Branching Structures
    Specifying a Recordset Cursor Type
    Working with Procedures and Functions
    Using Input Boxes
    Understanding the Form Object
    Stepping through Code
    Locking Records for Updating
    Navigating the Access Object Hierarchy
    Creating a Sub Procedure
    Using the For Each...Next Structure
    Organizing Code and Procedures
    Understanding VBA's Error Trapping Options

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Crosby
  • 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 ...
  • Action Queries
    Working With Records
    Creating a Relational Database
    Aggregation Queries
    Parameter Queries
    Creating Queries
    Understanding VBA
    Creating a Lookup Database
    Relational Database Design
    Data Validation
    Modifying Table Structures
    Importing and Exporting Records
    Creating and Using Reports
    Adding Records to a Table
    Creating and Using Forms
    Multi Table Queries
    Database Security
    Adding Transactional Records
    Designing a Lookup Database
    Creating and Using Macros
    Using a Navigation Form

  • See Training Course Details...

Email us about this courses

Other Crosby Enable Technology Training Courses

SSAS - Crosby SQL Server Analysis Services Training Courses
JQuery Mobile - Crosby JavaScript Training Courses
JavaScript - Crosby JavaScript Training Courses
PL/SQL Crosby Training Courses
SSIS - Crosby SQL Server Integration Services Training Courses
Oracle SQL Crosby Training Courses