Enable Technology

ACCESS TAUNTON TRAINING COURSES 

ACCESS TRAINING COURSES TAUNTON




About Enable Technology Taunton Access Training Courses

Enable Technology specialise in succinct skills based Access training. 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. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Taunton. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Carillion PLC, Royal Air Force, Lloyds TSB Bank PLC, Norfolk Police Constabulary, South Staffordshire Water PLC, TalkTalk Direct Limited, EDF Energy PLC and Nuclear Engineering Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Taunton
  • 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 ...
  • Creating a Function Procedure
    Understanding Modules
    Specifying a Recordset Cursor Location - Optional
    Understanding VBA's Error Trapping Options
    Using the With Statement
    Understanding Expressions and Statements
    Using the Immediate Window to Call Procedures
    Using Message Boxes
    Understanding Constants
    Working with the Application Object
    Guidelines for use of Branching Structures
    Debugging Code
    Understanding Procedures
    Stepping through Code
    Using Break Mode during Run Mode
    Working with Methods
    Understanding the Form Object
    Understanding the Development Environment
    Determining the Value of Expressions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Taunton
  • 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 ...
  • Importing and Exporting Records
    Data Validation
    Designing a Lookup Database
    Modifying Table Structures
    Creating a Relational Database
    Sorting and Filtering
    Adding Records to a Table
    Parameter Queries
    Working With Records
    Creating and Using Macros
    Using a Navigation Form
    Querying Techniques
    Database Security
    Relational Database Design
    Understanding VBA
    Creating and Using Reports
    Modifying Forms
    Creating a Lookup Database
    Getting to Know Access 
    Action Queries
    Macros on Forms

  • See Training Course Details...



Email us about this courses



Other Taunton Enable Technology Training Courses

SSAS Tabular - Taunton SQL Server Analysis Services Training Courses
SQL - Taunton SQL Training Courses
Excel 365 Basic - Taunton Excel Training Courses
Power Query Taunton Training Courses
SSIS Taunton Training Courses
VBA - Taunton Excel Training Courses