Enable Technology

ACCESS SANDWELL TRAINING COURSES 

ACCESS TRAINING COURSES SANDWELL




About Enable Technology Sandwell Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a venue near you in Sandwell. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Keele University, Carillion PLC, Nationwide Building Society Limited, Barclays Bank PLC, Loughborough University, Capita Group PLC, Dollond & Aitchison Limited and Vodafone Group Services.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sandwell
  • 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 ...
  • Specifying a Recordset Cursor Type
    Organizing Code and Procedures
    Understanding Procedures
    Considering Variable Scope and Lifetime Together
    Using the With Statement
    Understanding Data Types
    Using Debugging Tools
    Using the For...Next Structure
    Locking Records for Updating
    Working with Procedures and Functions
    Using Intrinsic Functions
    Using Intrinsic Constants
    Writing an Error-Handling Routine
    Creating a Sub Procedure
    Understanding Control-of-Flow Structures
    Setting Break Expressions
    Introduction to Programming in Access
    Creating a Standard Module
    Understanding Error Handling
    Working with Variable Scope

  • See Training Course Details...


Microsoft Access

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

  • See Training Course Details...



Email us about this courses



Other Sandwell Enable Technology Training Courses

JQuery Mobile Sandwell Training Courses
Oracle SQL Sandwell Training Courses
JQuery - Sandwell JavaScript Training Courses
SSAS Sandwell Training Courses
PL/SQL - Sandwell SQL Training Courses
Report Builder Sandwell Training Courses