Enable Technology

ACCESS GWYNEDD TRAINING COURSES 

ACCESS TRAINING COURSES GWYNEDD




About Enable Technology Gwynedd Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology training courses are delivered as instructor led courses. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We can also deliver the Access course at a local training venue in Gwynedd. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Birmingham City University, Royal & Sun Alliance Group PLC, Carillion PLC, Aston University, Nationwide Building Society Limited, Keele University, Boots UK Limited and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gwynedd
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using Message Boxes
    Understanding the Order of Events
    Naming Procedures
    Working with Procedures and Functions
    Using the For...Next Structure
    Using the With Statement
    Stepping through Code
    Working with Variable Lifetime
    Understanding the Development Environment
    Working with Events
    Trapping Errors with the On Error Statement
    Using the CacheSize Property - Optional
    Understanding the Err Object
    Understanding Classes and Objects
    Introduction to Programming in Access
    Guidelines for use of Branching Structures
    Using the Object Browser
    Using Visual Basic Help
    Why Program in Access?
    Handling Errors

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Gwynedd
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Data Validation
    DIY Forms
    Modifying Forms
    Creating and Using Macros
    Adding Records to a Table
    Adding Transactional Records
    Parameter Queries
    Relational Database Design
    Database Wellness
    Macro Techniques
    Working With Records
    Importing and Exporting Records
    Using a Navigation Form
    Calculations in Queries
    Designing a Lookup Database
    Creating and Using Forms
    Querying Techniques
    Macros on Forms
    Aggregation Queries
    Formatting Tables
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other Gwynedd Enable Technology Training Courses

PL/SQL Gwynedd Training Courses
Excel 365 Advanced - Gwynedd Excel Training Courses
SSAS Tabular - Gwynedd SQL Server Analysis Services Training Courses
Excel Power Pivot - Gwynedd Excel Training Courses
JQuery Gwynedd Training Courses
VBA Gwynedd Training Courses