Enable Technology



About Enable Technology Huddersfield Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Wolverhampton City Council, Nationwide Building Society Limited, Countrywide Homes Limited, Vodafone Group Services, South Staffordshire Water PLC, Carillion PLC, Loughborough University and Queen's Medical Centre Nottingham.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Huddersfield
  • 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 Recordset Cursor Properties - Optional
    Creating a Function Procedure
    Working with the Application Object
    Understanding VBA's Error Trapping Options
    Trapping Errors with the On Error Statement
    Using Intrinsic Functions
    Understanding Expressions and Statements
    Setting Breakpoints
    Organizing Code and Procedures
    Introduction to Programming in Access
    Understanding Error Handling
    Using the Object Browser
    Debugging Code
    Understanding Collections
    Using the Select Case...End Select Structure
    Setting Break Expressions
    Working with the Code Editor
    Understanding Constants

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Huddersfield
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Macro Techniques
    Creating a Relational Database
    Creating and Using Forms
    Creating and Using Macros
    Understanding VBA
    Adding Records to a Table
    Aggregation Queries
    Multi Table Queries
    Working With Records
    Using a Navigation Form
    An Introduction to VBA
    Modifying Table Structures
    Setting Table Relationships
    Relational Database Design
    Parameter Queries
    Modifying Forms
    Macros on Forms
    Creating a Lookup Database
    Creating and Using Reports
    Database Wellness
    Database Security

  • See Training Course Details...

Email us about this courses

Other Huddersfield Enable Technology Training Courses

SSAS Tabular Huddersfield Training Courses
JQuery Mobile - Huddersfield JavaScript Training Courses
TSQL - Huddersfield SQL Training Courses
Excel Power Pivot Huddersfield Training Courses
SQL Huddersfield Training Courses
Oracle SQL - Huddersfield SQL Training Courses