Enable Technology



About Enable Technology Harrogate Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a Access course at an alternative training site in Harrogate. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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: Boots UK Limited, University of Birmingham, Fujistu PLC, Barclays Bank PLC, Nationwide Building Society Limited, Yell Group PLC, EDF Energy PLC and Carillion PLC.

Microsoft Access

  • 2 day course
  • Location: Harrogate
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Formatting Tables
    Database Security
    Calculations in Queries
    Working With Records
    Creating Queries
    Creating a Relational Database
    Understanding VBA
    Macro Techniques
    Creating and Using Forms
    Multi Table Queries
    Relational Database Design
    Navigation Pane Protection
    Creating and Using Macros
    Action Queries
    Adding Transactional Records
    Querying Techniques
    Data Validation
    Importing and Exporting Records
    An Introduction to VBA
    Modifying Table Structures
    Using a Navigation Form

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Harrogate
  • Telephone on 01952 305730
  • 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 ...
  • Using the Immediate Window to Call Procedures
    Guidelines for use of Branching Structures
    Using Input Boxes
    Working with Events
    Understanding the Order of Events
    Understanding VBA's Error Trapping Options
    Working with the Application Object
    Organizing Code and Procedures
    Using Intrinsic Functions
    Understanding Errors
    Working with Inline Error Handling
    Declaring and Creating Object Variables
    Using the For Each...Next Structure
    Understanding Procedures
    Understanding the Err Object
    Using the If...End If Decision Structures
    Working with Variable Scope

  • See Training Course Details...

Email us about this courses

Other Harrogate Enable Technology Training Courses

PL/SQL - Harrogate SQL Training Courses
TSQL - Harrogate SQL Training Courses
SSAS 2014 Harrogate Training Courses
SSRS 2008 Harrogate Training Courses
Report Builder - Harrogate SQL Server Reporting Services Training Courses
Crystal 2013 Harrogate Training Courses

North - Possible Access Training Course Locations

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

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