Enable Technology



About Enable Technology Sheffield 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. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local socially distanced venue in Sheffield. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Homeserve PLC, Shell UK Oil Products Ltd, Birmingham Heartlands Hospital, South Staffordshire Water PLC, Unipart Group, Aston University, Carillion PLC and Fujistu PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sheffield
  • Telephone on 01952 305730
  • 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 ...
  • Why Program in Access?
    Using the Immediate Window to Call Procedures
    Using the For...Next Structure
    Working with Events
    Understanding VBA's Error Trapping Options
    Understanding Classes and Objects
    Working with Procedures and Functions
    Considering Variable Scope and Lifetime Together
    Declaring Variables
    Understanding Collections
    Understanding Expressions and Statements
    Using the For Each...Next Structure
    Calling Procedures
    Using the CacheSize Property - Optional
    Organizing Code and Procedures
    Stepping through Code
    Introduction to Programming in Access
    Working with Boolean Expressions

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Sheffield
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Creating Queries
    Creating a Lookup Database
    Querying Techniques
    Importing and Exporting Records
    Database Wellness
    Action Queries
    Designing a Lookup Database
    Creating a Relational Database
    Multi Table Queries
    Getting to Know Access 
    Modifying Forms
    Macros on Forms
    Creating and Using Reports
    Creating and Using Macros
    Using a Navigation Form
    Relational Database Design
    Aggregation Queries
    Sorting and Filtering
    Parameter Queries
    Formatting Tables
    DIY Forms

  • See Training Course Details...

Email us about this courses

Other Sheffield Enable Technology Training Courses

Mobile - Sheffield Web Development Training Courses
Project 2016 Sheffield Training Courses
SSAS 2017 Sheffield Training Courses
HTML - Sheffield Web Development Training Courses
Excel Advanced - Sheffield Excel Training Courses
SSRS 2005 - Sheffield SQL Server Reporting Services Training Courses

North - Possible Access Training Course Locations

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

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