Enable Technology



About Enable Technology Halifax Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Every person attending a Access course will be provided with training materials and practice files to retain after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local socially distanced training site. We are happy to modify the Access syllabus to match your teams training requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Norwich Union PLC, Boots UK Limited, Fujistu PLC, Wolverhampton City Council, Birmingham Heartlands Hospital, Keele University, Dollond & Aitchison Limited and Total Telecommunications Limited.

Microsoft Access

  • 2 day course
  • Location: Halifax
  • Telephone on 01952 305730
  • 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 ...
  • Creating Queries
    Getting to Know Access 
    Parameter Queries
    Navigation Pane Protection
    Sorting and Filtering
    Working With Records
    Creating a Lookup Database
    Database Wellness
    Macros on Forms
    Creating and Using Macros
    An Introduction to VBA
    Data Validation
    Relational Database Design
    Creating and Using Forms
    Adding Transactional Records
    Multi Table Queries
    Aggregation Queries
    Setting Table Relationships
    Formatting Tables
    Querying Techniques
    Using a Navigation Form

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Halifax
  • 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 ...
  • Understanding the DoCmd Object
    Working with Procedures and Functions
    Working with the Application Object
    Using the Select Case...End Select Structure
    Working with the Code Editor
    Navigating the Access Object Hierarchy
    Understanding VBA's Error Trapping Options
    Using Message Boxes
    Locking Records for Updating
    Calling Procedures
    Using Intrinsic Constants
    Working with Recordsets
    Using the For Each...Next Structure
    Handling Errors
    Understanding the Order of Events
    Using Input Boxes
    Working with Variable Scope
    Using the If...End If Decision Structures
    Understanding Objects
    Writing an Error-Handling Routine

  • See Training Course Details...

Email us about this courses

Other Halifax Enable Technology Training Courses

SSIS 2014 Halifax Training Courses
Crystal 2013 - Halifax Crystal Reports Training Courses
JQuery - Halifax JavaScript Training Courses
Power Graphics Halifax Training Courses
Excel Advanced - Halifax Excel Training Courses
Excel Power Pivot - Halifax Excel Training Courses

North - Possible Access Training Course Locations

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

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