Enable Technology

ACCESS CAERPHILLY TRAINING COURSES 

ACCESS TRAINING COURSES CAERPHILLY




About Enable Technology Caerphilly Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Caerphilly. Every Access course can be modified to meet your bespoke 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Queen's Medical Centre Nottingham, Cadbury PLC, University of Birmingham, Lloyds TSB Bank PLC, Vodafone Group Services, EDF Energy PLC, Royal Air Force and Boots UK Limited.




Microsoft Access

  • 2 day course
  • Location: Caerphilly
  • 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 ...
  • Getting to Know Access 
    Calculations in Queries
    Formatting Tables
    Modifying Forms
    Macros on Forms
    Creating and Using Macros
    An Introduction to VBA
    Adding Records to a Table
    Navigation Pane Protection
    Relational Database Design
    Using a Navigation Form
    Querying Techniques
    Aggregation Queries
    Designing a Lookup Database
    Creating and Using Reports
    Understanding VBA
    Macro Techniques
    Creating a Lookup Database
    Parameter Queries
    Modifying Table Structures
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Caerphilly
  • 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 ...
  • Calling Procedures
    Understanding Error Handling
    Understanding Recordset Cursor Properties - Optional
    Setting Break Expressions
    Understanding the Development Environment
    Working with Variable Scope
    Working with Events
    Using the For Each...Next Structure
    Understanding the DoCmd Object
    Using Intrinsic Constants
    Working with the ADODB Recordset Object
    Using the CacheSize Property - Optional
    Declaring and Creating Object Variables
    Working with Boolean Expressions
    Determining the Value of Expressions
    Using the Immediate Window to Call Procedures
    Trapping Errors with the On Error Statement
    Stepping through Code
    Understanding Classes and Objects

  • See Training Course Details...



Email us about this courses



Other Caerphilly Enable Technology Training Courses

SSAS Tabular Caerphilly Training Courses
VBA - Caerphilly Excel Training Courses
Report Builder Caerphilly Training Courses
TSQL - Caerphilly SQL Training Courses
JQuery Mobile Caerphilly Training Courses
SQL - Caerphilly SQL Training Courses