Enable Technology

ACCESS WALES TRAINING COURSES 

ACCESS TRAINING COURSES WALES




About Enable Technology Wales Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. If you prefer we can offer an offsite socially distanced training location in Wales. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

We have operated primarily in the West Midlands for twenty years. Our clients include: EDF Energy PLC, Lloyds TSB Bank PLC, Yell Group PLC, Norfolk Police Constabulary, University of Birmingham, Keele University, Countrywide Homes Limited and Nuclear Engineering Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wales
  • 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 ...
  • Understanding Objects
    Using the Immediate Window to Call Procedures
    Controlling Program Execution
    Working with Methods
    Understanding Modules
    Using the For...Next Structure
    Understanding the Err Object
    Understanding Error Handling
    Understanding Data Types
    Debugging Code
    Creating a Sub Procedure
    Working with Events
    Introduction to Programming in Access
    Setting Break Expressions
    Considering Variable Scope and Lifetime Together
    Locking Records for Updating
    Using the If...End If Decision Structures
    Creating a Function Procedure
    Using the With Statement
    Calling Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Wales
  • 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 ...
  • Formatting Tables
    Macro Techniques
    Aggregation Queries
    Working With Records
    Understanding VBA
    Creating Queries
    Adding Transactional Records
    Data Validation
    Database Wellness
    Creating a Relational Database
    DIY Forms
    Creating and Using Forms
    Using a Navigation Form
    Setting Table Relationships
    Adding Records to a Table
    An Introduction to VBA
    Querying Techniques
    Getting to Know Access 
    Navigation Pane Protection
    Macros on Forms
    Modifying Forms

  • See Training Course Details...



Email us about this courses



Other Wales Enable Technology Training Courses

Excel 365 Advanced - Wales Excel Training Courses
Power Query Wales Training Courses
SQL - Wales SQL Training Courses
Excel Power Pivot - Wales Excel Training Courses
JavaScript Wales Training Courses
SSAS Tabular Wales Training Courses