Enable Technology



About Enable Technology Saddleworth Access Training Courses

Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Saddleworth. The Access syllabus can be adjusted and additional topics incorporated if helpful.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Birmingham City Council, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Fujistu PLC, Canadian High Commission, Wolverhampton City Council and National Power PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Saddleworth
  • 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 VBA's Error Trapping Options
    Working with Boolean Expressions
    Working with Inline Error Handling
    Understanding the Form Object
    Understanding Recordset Cursor Properties - Optional
    Navigating the Access Object Hierarchy
    Understanding Collections
    Understanding the Development Environment
    Working with Events
    Working with Procedures and Functions
    Setting Break Expressions
    Working with Variable Lifetime
    Using the Immediate Window to Call Procedures
    Using Input Boxes
    Using Message Boxes
    Creating a Function Procedure
    Using Expressions, Variables, and Intrinsic Functions
    Declaring and Creating Object Variables
    Creating a Standard Module
    Naming Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Saddleworth
  • 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 ...
  • DIY Forms
    An Introduction to VBA
    Aggregation Queries
    Relational Database Design
    Importing and Exporting Records
    Database Security
    Understanding VBA
    Querying Techniques
    Creating Queries
    Calculations in Queries
    Action Queries
    Sorting and Filtering
    Getting to Know Access 
    Designing a Lookup Database
    Creating a Relational Database
    Creating and Using Forms
    Formatting Tables
    Using a Navigation Form
    Database Wellness
    Macros on Forms
    Adding Transactional Records

  • See Training Course Details...

Email us about this courses

Other Saddleworth Enable Technology Training Courses

PL/SQL Saddleworth Training Courses
Report Builder - Saddleworth SQL Server Reporting Services Training Courses
Excel Power Pivot Saddleworth Training Courses
SQL - Saddleworth SQL Training Courses
JavaScript - Saddleworth JavaScript Training Courses
SSAS Tabular - Saddleworth SQL Server Analysis Services Training Courses