Enable Technology



About Enable Technology Wakefield Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a socially distanced training location in Wakefield. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: DHL Express, TalkTalk Direct Limited, Capita Group PLC, Countrywide Homes Limited, Total Telecommunications Limited, Homeserve PLC, Norfolk Police Constabulary and Birmingham City Council.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wakefield
  • Telephone on 01952 305730
  • 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 ...
  • Understanding the Development Environment
    Introduction to Programming in Access
    Using the If...End If Decision Structures
    Understanding Collections
    Working with the ADODB Recordset Object
    Understanding the DoCmd Object
    Declaring and Creating Object Variables
    Using the Object Browser
    Calling Procedures
    Using the For...Next Structure
    Understanding Procedures
    Locking Records for Updating
    Using the Select Case...End Select Structure
    Declaring Variables
    Guidelines for use of Branching Structures
    Working with Procedures and Functions
    Specifying a Recordset Cursor Type
    Using Input Boxes
    Considering Variable Scope and Lifetime Together

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Wakefield
  • Telephone on 01952 305730
  • 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 and Using Macros
    Designing a Lookup Database
    Modifying Table Structures
    Understanding VBA
    Creating and Using Reports
    Adding Records to a Table
    Adding Transactional Records
    Multi Table Queries
    Formatting Tables
    An Introduction to VBA
    Creating Queries
    Creating a Lookup Database
    Navigation Pane Protection
    Modifying Forms
    Database Wellness
    DIY Forms
    Setting Table Relationships
    Action Queries
    Relational Database Design
    Sorting and Filtering
    Calculations in Queries

  • See Training Course Details...

Email us about this courses

Other Wakefield Enable Technology Training Courses

SSRS 2005 - Wakefield SQL Server Reporting Services Training Courses
TSQL Wakefield Training Courses
Data Warehouse Wakefield Training Courses
HTML - Wakefield Web Development Training Courses
SSAS 2014 - Wakefield SQL Server Analysis Services Training Courses
Report Builder Wakefield Training Courses

North - Possible Access Training Course Locations

Wetherby Access Training Courses
Doncaster Access Training Courses
Castleford Access Training Courses
Gateshead Access Training Courses
North East Access Training Courses
Rotherham Access Training Courses
Leeds Access Training Courses
Newcastle Upon Tyne Access Training Courses
Yorkshire Access Training Courses
South Shields Access Training Courses
Sheffield Access Training Courses
Middlesbrough Access Training Courses
Halifax Access Training Courses
Scunthorpe Access Training Courses
Dewsbury Access Training Courses
Wakefield Access Training Courses
Scarborough Access Training Courses
Batley Access Training Courses
Sunderland Access Training Courses
York Access Training Courses
Grimsby Access Training Courses
Keighley Access Training Courses
Bridlington Access Training Courses
Hartlepool Access Training Courses
Normanton Access Training Courses
Harrogate Access Training Courses
Hexham Access Training Courses
Barnsley Access Training Courses
Huddersfield Access Training Courses
Pudsey Access Training Courses
Durham Access Training Courses

Wetherby, Doncaster, Castleford, Gateshead, North East, Rotherham, Leeds, Newcastle Upon Tyne, Yorkshire, South Shields, Sheffield, Middlesbrough, Halifax, Scunthorpe, Dewsbury, Wakefield, Scarborough, Batley, Sunderland, York, Grimsby, Keighley, Bridlington, Hartlepool, Normanton, Harrogate, Hexham, Barnsley, Huddersfield, Pudsey, Durham