Enable Technology



About Enable Technology Llandudno Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. We will issue each Access training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a Access course at an alternative training site in Llandudno. All Access courses can be customised to meet your particular requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are DHL Express, Capita Group PLC, Canadian High Commission, Birmingham City University, South Staffordshire Water PLC, Halfords Group PLC, National Power PLC and Norwich Union PLC.

Microsoft Access

  • 2 day course
  • Location: Llandudno
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Sorting and Filtering
    Aggregation Queries
    Getting to Know Access 
    Designing a Lookup Database
    Database Security
    Macros on Forms
    Creating and Using Forms
    Relational Database Design
    Navigation Pane Protection
    Creating a Relational Database
    Macro Techniques
    Using a Navigation Form
    Creating a Lookup Database
    Parameter Queries
    An Introduction to VBA
    Creating and Using Macros
    Formatting Tables
    Modifying Table Structures
    Adding Transactional Records
    Querying Techniques

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Llandudno
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Using the CacheSize Property - Optional
    Understanding the Form Object
    Trapping Errors with the On Error Statement
    Working with the Code Editor
    Calling Procedures
    Setting Break Expressions
    Understanding the Err Object
    Navigating the Access Object Hierarchy
    Debugging Code
    Guidelines for use of Branching Structures
    Using the If...End If Decision Structures
    Creating a Standard Module
    Understanding Errors
    Using the For Each...Next Structure
    Working with Procedures and Functions
    Understanding Error Handling

  • See Training Course Details...

Email us about this courses

Other Llandudno Enable Technology Training Courses

PL/SQL Llandudno Training Courses
Power Query Llandudno Training Courses
Excel Power Pivot - Llandudno Excel Training Courses
DAX Llandudno Training Courses
JQuery Llandudno Training Courses
Excel 365 Advanced - Llandudno Excel Training Courses