Enable Technology

ACCESS WARWICKSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES WARWICKSHIRE




About Enable Technology Warwickshire Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. 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.

Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a local training venue in Warwickshire. The Access syllabus can be adjusted and additional topics incorporated if helpful.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Lloyds TSB Bank PLC, TalkTalk Direct Limited, Birmingham Heartlands Hospital, Carillion PLC, Dollond & Aitchison Limited, Total Telecommunications Limited, Canadian High Commission and Boots UK Limited.




Microsoft Access

  • 2 day course
  • Location: Warwickshire
  • 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 Queries
    Modifying Table Structures
    Using a Navigation Form
    Working With Records
    Multi Table Queries
    Formatting Tables
    Creating and Using Reports
    Database Wellness
    Database Security
    Calculations in Queries
    Getting to Know Access 
    An Introduction to VBA
    Adding Records to a Table
    Data Validation
    Aggregation Queries
    Creating and Using Forms
    Designing a Lookup Database
    Creating a Lookup Database
    Creating a Relational Database
    DIY Forms
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Warwickshire
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Understanding the Order of Events
    Debugging Code
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Expressions and Statements
    Working with Variable Scope
    Using the For...Next Structure
    Considering Variable Scope and Lifetime Together
    Using Input Boxes
    Working with the Application Object
    Working with Inline Error Handling
    Working with the ADODB Recordset Object
    Locking Records for Updating
    Understanding Classes and Objects
    Using the Select Case...End Select Structure
    Guidelines for use of Branching Structures
    Creating a Standard Module
    Understanding VBA's Error Trapping Options
    Understanding Errors
    Working with the Code Editor

  • See Training Course Details...



Email us about this courses



Other Warwickshire Enable Technology Training Courses

Data Warehouse - Warwickshire SQL Training Courses
JavaScript Warwickshire Training Courses
Excel Power Pivot - Warwickshire Excel Training Courses
SQL - Warwickshire SQL Training Courses
TSQL Warwickshire Training Courses
Excel 365 Advanced Warwickshire Training Courses