Enable Technology

ACCESS CIL-Y-COED TRAINING COURSES 

ACCESS TRAINING COURSES CIL-Y-COED




About Enable Technology Cil-y-coed Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to 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.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. If delivery onsite is an issue we will organise a socially distanced venue near you in Cil-y-coed. We are happy to discuss customising the course content should you have particular Access training requirements.

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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are EDF Energy PLC, Royal Air Force, Countrywide Homes Limited, South Staffordshire Water PLC, National Power PLC, Capita Group PLC, Shell UK Oil Products Ltd and Aston University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cil-y-coed
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding Data Types
    Using Intrinsic Functions
    Using the Select Case...End Select Structure
    Creating a Sub Procedure
    Understanding Procedures
    Declaring Variables
    Working with Methods
    Understanding Recordset Cursor Properties - Optional
    Understanding the Err Object
    Trapping Errors with the On Error Statement
    Using Intrinsic Constants
    Understanding Expressions and Statements
    Calling Procedures
    Specifying a Recordset Cursor Location - Optional
    Locking Records for Updating
    Working with the ADODB Recordset Object
    Introduction to Programming in Access
    Using the For Each...Next Structure
    Determining the Value of Expressions
    Declaring and Creating Object Variables

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Cil-y-coed
  • 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 ...
  • Creating a Relational Database
    Macro Techniques
    Working With Records
    Understanding VBA
    Sorting and Filtering
    Modifying Forms
    Creating and Using Reports
    Creating and Using Forms
    Creating a Lookup Database
    Relational Database Design
    Navigation Pane Protection
    Creating and Using Macros
    Calculations in Queries
    Creating Queries
    Adding Records to a Table
    Parameter Queries
    Formatting Tables
    An Introduction to VBA
    Designing a Lookup Database
    Database Wellness
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Cil-y-coed Enable Technology Training Courses

PL/SQL Cil-y-coed Training Courses
TSQL - Cil-y-coed SQL Training Courses
SSAS Tabular - Cil-y-coed SQL Server Analysis Services Training Courses
Power Query Cil-y-coed Training Courses
Excel Power Pivot - Cil-y-coed Excel Training Courses
Data Warehouse - Cil-y-coed SQL Training Courses