Enable Technology



About Enable Technology Rotherham Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local socially distanced training site. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can 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. Some of our clients are Wolverhampton City Council, Lloyds TSB Bank PLC, DHL Express, Boots UK Limited, South Staffordshire Water PLC, GKN PLC, Canadian High Commission and Keele University.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rotherham
  • 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 ...
  • Specifying a Recordset Cursor Type
    Understanding Errors
    Working with Boolean Expressions
    Using Intrinsic Functions
    Navigating the Access Object Hierarchy
    Working with the Code Editor
    Using Input Boxes
    Using Intrinsic Constants
    Using Visual Basic Help
    Locking Records for Updating
    Using the Do...Loop Structure
    Understanding Procedures
    Setting Break Expressions
    Naming Procedures
    Handling Errors
    Using the Immediate Window to Call Procedures
    Understanding Expressions and Statements
    Calling Procedures
    Using the Select Case...End Select Structure

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Rotherham
  • 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 ...
  • Database Wellness
    Creating a Lookup Database
    Database Security
    Creating a Relational Database
    Adding Records to a Table
    Creating and Using Forms
    Modifying Table Structures
    Calculations in Queries
    Macros on Forms
    Getting to Know Access 
    Sorting and Filtering
    Multi Table Queries
    An Introduction to VBA
    Modifying Forms
    Understanding VBA
    Importing and Exporting Records
    Aggregation Queries
    Formatting Tables
    Querying Techniques
    Action Queries
    Adding Transactional Records

  • See Training Course Details...

Email us about this courses

Other Rotherham Enable Technology Training Courses

SSIS 2005 - Rotherham SQL Server Integration Services Training Courses
SSRS 2014 - Rotherham SQL Server Reporting Services Training Courses
CSS - Rotherham Web Development Training Courses
SSAS 2005 Rotherham Training Courses
Crystal 2013 Rotherham Training Courses
SSAS Tabular Rotherham Training Courses

North - Possible Access Training Course Locations

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

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