Enable Technology



About Enable Technology Rotherham Access Training Courses

We are a company that provides short intensive Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local socially distanced training site in Rotherham. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Aston University, National Power PLC, Nuclear Engineering Services, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Wolverhampton City Council, EDF Energy PLC and University of Birmingham.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rotherham
  • Telephone on 01952 938014
  • 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
    Understanding Data Types
    Navigating the Access Object Hierarchy
    Using the Object Browser
    Understanding Recordset Cursor Properties - Optional
    Working with Recordsets
    Understanding the Err Object
    Trapping Errors with the On Error Statement
    Declaring and Creating Object Variables
    Working with Methods
    Using Visual Basic Help
    Understanding Modules
    Controlling Program Execution
    Understanding VBA's Error Trapping Options
    Understanding Constants
    Working with Variable Scope
    Specifying a Recordset Cursor Type
    Using Break Mode during Run Mode

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Rotherham
  • Telephone on 01952 938014
  • 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 ...
  • Sorting and Filtering
    Creating Queries
    Creating a Lookup Database
    Designing a Lookup Database
    Querying Techniques
    Macros on Forms
    Navigation Pane Protection
    Action Queries
    Importing and Exporting Records
    Macro Techniques
    Relational Database Design
    Formatting Tables
    Database Security
    Modifying Table Structures
    Modifying Forms
    Getting to Know Access 
    Creating and Using Reports
    Using a Navigation Form
    Understanding VBA
    An Introduction to VBA
    DIY Forms

  • See Training Course Details...

Email us about this courses

Other Rotherham Enable Technology Training Courses

SQL - Rotherham SQL Training Courses
JQuery Rotherham Training Courses
SSAS Rotherham Training Courses
SSIS - Rotherham SQL Server Integration Services Training Courses
SSAS Tabular - Rotherham SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Rotherham Excel Training Courses