Enable Technology

ACCESS NORTH WEST TRAINING COURSES 

ACCESS TRAINING COURSES NORTH WEST




About Enable Technology North West Access Training Courses

We are a company that offers short, practical, Access hands on technology 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. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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. The Access course could also be scheduled at a socially distanced site near you in the North West. The Access syllabus can be modified to accommodate your specific training needs.

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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Lloyds TSB Bank PLC, Nationwide Building Society Limited, Birmingham Heartlands Hospital, Vodafone Group Services, EDF Energy PLC, Boots UK Limited, Dollond & Aitchison Limited and Birmingham City Council.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: North West
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using the Immediate Window to Call Procedures
    Using the If...End If Decision Structures
    Guidelines for use of Branching Structures
    Understanding Procedures
    Using the Object Browser
    Specifying a Recordset Cursor Type
    Understanding the Err Object
    Working with Inline Error Handling
    Using Intrinsic Functions
    Using the Do...Loop Structure
    Working with Properties
    Understanding Control-of-Flow Structures
    Understanding the Form Object
    Understanding Classes and Objects
    Working with Variable Scope
    Using the Select Case...End Select Structure
    Working with Variable Lifetime
    Declaring Variables
    Creating a Standard Module

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: North West
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Macro Techniques
    An Introduction to VBA
    Modifying Table Structures
    Modifying Forms
    Aggregation Queries
    Data Validation
    Action Queries
    Relational Database Design
    DIY Forms
    Navigation Pane Protection
    Database Security
    Formatting Tables
    Querying Techniques
    Adding Transactional Records
    Designing a Lookup Database
    Adding Records to a Table
    Setting Table Relationships
    Sorting and Filtering
    Getting to Know Access 
    Multi Table Queries
    Working With Records

  • See Training Course Details...



Email us about this courses



Other North West Enable Technology Training Courses

Power Query - North West Excel Training Courses
JavaScript North West Training Courses
SQL North West Training Courses
PL/SQL - North West SQL Training Courses
SSAS Tabular North West Training Courses
Power BI - North West Microsoft Power BI Training Courses