Enable Technology

ACCESS OXFORD TRAINING COURSES 

ACCESS TRAINING COURSES OXFORD




About Enable Technology Oxford Access Training Courses

Enable Technology provides practical Access skills based technology training. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post 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. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Oxford. All Access courses can be customised to meet your particular requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, Shell UK Oil Products Ltd, Loughborough University, National Power PLC, Vodafone Group Services, EDF Energy PLC, Halfords Group PLC and University of Birmingham.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Oxford
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Writing an Error-Handling Routine
    Using Debugging Tools
    Working with the Code Editor
    Creating a Sub Procedure
    Understanding Classes and Objects
    Guidelines for use of Branching Structures
    Using the Do...Loop Structure
    Locking Records for Updating
    Setting Break Expressions
    Using Input Boxes
    Handling Errors
    Understanding Control-of-Flow Structures
    Understanding the Order of Events
    Understanding the Development Environment
    Working with the ADODB Recordset Object
    Using the For Each...Next Structure
    Working with Inline Error Handling
    Understanding Objects
    Understanding Constants
    Using the For...Next Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Oxford
  • 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 ...
  • Calculations in Queries
    An Introduction to VBA
    Macros on Forms
    Creating a Lookup Database
    Querying Techniques
    Creating and Using Macros
    Creating Queries
    Importing and Exporting Records
    Database Wellness
    Getting to Know Access 
    Creating and Using Reports
    Sorting and Filtering
    Designing a Lookup Database
    Action Queries
    Macro Techniques
    Adding Records to a Table
    Setting Table Relationships
    Creating a Relational Database
    Modifying Forms
    Parameter Queries
    Creating and Using Forms

  • See Training Course Details...



Email us about this courses



Other Oxford Enable Technology Training Courses

PL/SQL Oxford Training Courses
JQuery Mobile - Oxford JavaScript Training Courses
Excel 365 Intermediate Oxford Training Courses
SSIS - Oxford SQL Server Integration Services Training Courses
Excel 365 Basic - Oxford Excel Training Courses
VBA Oxford Training Courses