Enable Technology

ACCESS LEYLAND TRAINING COURSES 

ACCESS TRAINING COURSES LEYLAND




About Enable Technology Leyland Access Training Courses

We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. Another option is we can organise a local socially distanced training site in Leyland. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, Capita Group PLC, Shell UK Oil Products Ltd, EDF Energy PLC, South Staffordshire Water PLC, Aston University, Birmingham City University and University of Birmingham.




Microsoft Access

  • 2 day course
  • Location: Leyland
  • 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 ...
  • Navigation Pane Protection
    An Introduction to VBA
    Relational Database Design
    Modifying Table Structures
    Designing a Lookup Database
    Creating a Lookup Database
    Database Security
    Creating a Relational Database
    Macro Techniques
    Aggregation Queries
    Querying Techniques
    Using a Navigation Form
    Multi Table Queries
    Creating and Using Forms
    Parameter Queries
    Getting to Know Access 
    Creating Queries
    Data Validation
    Creating and Using Reports
    Working With Records
    Adding Transactional Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leyland
  • 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 ...
  • Working with Inline Error Handling
    Working with Boolean Expressions
    Understanding Classes and Objects
    Calling Procedures
    Working with Properties
    Understanding Constants
    Understanding Expressions and Statements
    Controlling Program Execution
    Declaring Variables
    Understanding Error Handling
    Understanding the Form Object
    Navigating the Access Object Hierarchy
    Using the For Each...Next Structure
    Working with Variable Lifetime
    Understanding Errors
    Guidelines for use of Branching Structures
    Creating a Sub Procedure
    Using Break Mode during Run Mode
    Understanding Data Types

  • See Training Course Details...



Email us about this courses



Other Leyland Enable Technology Training Courses

Excel Power Pivot - Leyland Excel Training Courses
VBA Leyland Training Courses
TSQL - Leyland SQL Training Courses
SSAS Leyland Training Courses
SSAS Tabular - Leyland SQL Server Analysis Services Training Courses
JQuery Mobile - Leyland JavaScript Training Courses