Enable Technology



About Enable Technology Colwyn Bay Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local socially distanced training site in Colwyn Bay. The Access syllabus can be modified to accommodate your specific training needs.

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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are West Bromwich Building Society, Capita Group PLC, South Staffordshire Water PLC, Carillion PLC, GKN PLC, Birmingham City Council, Norfolk Police Constabulary and Nationwide Building Society Limited.

Microsoft Access

  • 2 day course
  • Location: Colwyn Bay
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Importing and Exporting Records
    Creating a Lookup Database
    Aggregation Queries
    Macro Techniques
    Working With Records
    Action Queries
    Creating and Using Macros
    Multi Table Queries
    Creating Queries
    Designing a Lookup Database
    Setting Table Relationships
    Database Security
    Using a Navigation Form
    Modifying Forms
    Sorting and Filtering
    Creating and Using Reports
    DIY Forms
    Querying Techniques
    Relational Database Design
    Database Wellness
    Macros on Forms

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Colwyn Bay
  • 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 Modules
    Using the Object Browser
    Understanding Collections
    Considering Variable Scope and Lifetime Together
    Working with Procedures and Functions
    Working with Variable Lifetime
    Understanding the Development Environment
    Working with Inline Error Handling
    Using the Immediate Window to Call Procedures
    Working with Events
    Specifying a Recordset Cursor Location - Optional
    Using Break Mode during Run Mode
    Using Message Boxes
    Introduction to Programming in Access
    Determining the Value of Expressions
    Locking Records for Updating
    Understanding Error Handling
    Writing an Error-Handling Routine
    Trapping Errors with the On Error Statement

  • See Training Course Details...

Email us about this courses

Other Colwyn Bay Enable Technology Training Courses

Report Builder Colwyn Bay Training Courses
JQuery - Colwyn Bay JavaScript Training Courses
PL/SQL - Colwyn Bay SQL Training Courses
SQL Colwyn Bay Training Courses
Power Query - Colwyn Bay Excel Training Courses
SSIS - Colwyn Bay SQL Server Integration Services Training Courses