Enable Technology



About Enable Technology Lytham Urmston Access Training Courses

Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite socially distanced training location in Lytham Urmston. We are happy to modify the Access syllabus to match your teams training requirements.

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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Barclays Bank PLC, Vodafone Group Services, Nationwide Building Society Limited, West Bromwich Building Society, University of Birmingham, Nuclear Engineering Services, Aston University and Royal Air Force.

Microsoft Access

  • 2 day course
  • Location: Lytham Urmston
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • An Introduction to VBA
    Creating a Lookup Database
    Modifying Table Structures
    Creating a Relational Database
    Parameter Queries
    Data Validation
    Navigation Pane Protection
    Working With Records
    Designing a Lookup Database
    Action Queries
    Importing and Exporting Records
    Adding Transactional Records
    Macro Techniques
    Aggregation Queries
    Database Security
    Multi Table Queries
    Querying Techniques
    Database Wellness
    Macros on Forms
    Formatting Tables
    Modifying Forms

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lytham Urmston
  • 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 ...
  • Determining the Value of Expressions
    Writing an Error-Handling Routine
    Understanding Objects
    Working with Events
    Creating a Sub Procedure
    Using the Select Case...End Select Structure
    Creating a Function Procedure
    Using the Do...Loop Structure
    Using the If...End If Decision Structures
    Understanding Control-of-Flow Structures
    Declaring Variables
    Understanding Error Handling
    Working with Methods
    Working with Variable Scope
    Guidelines for use of Branching Structures
    Understanding the Err Object
    Working with Recordsets
    Setting Breakpoints
    Working with Inline Error Handling
    Understanding Procedures

  • See Training Course Details...

Email us about this courses

Other Lytham Urmston Enable Technology Training Courses

SQL - Lytham Urmston SQL Training Courses
SSRS - Lytham Urmston SQL Server Reporting Services Training Courses
Oracle SQL Lytham Urmston Training Courses
SSAS Tabular Lytham Urmston Training Courses
JavaScript Lytham Urmston Training Courses
Excel 365 Intermediate Lytham Urmston Training Courses