Enable Technology



About Enable Technology Sunderland Access Training Courses

Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

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. We can also deliver the Access course at a socially distanced local training venue in Sunderland. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Barclays Bank PLC, Aston University, Homeserve PLC, Birmingham City University, GKN PLC, Keele University, South Staffordshire Water PLC and National Power PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sunderland
  • 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 ...
  • Handling Errors
    Declaring Variables
    Understanding Errors
    Working with Boolean Expressions
    Creating a Function Procedure
    Understanding Recordset Cursor Properties - Optional
    Understanding Modules
    Controlling Program Execution
    Using Message Boxes
    Using Intrinsic Functions
    Using Input Boxes
    Understanding Objects
    Determining the Value of Expressions
    Creating a Standard Module
    Working with Variable Lifetime
    Working with Inline Error Handling
    Understanding Error Handling
    Working with Properties
    Using the For...Next Structure
    Navigating the Access Object Hierarchy

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Sunderland
  • Telephone on 01952 938014
  • 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 ...
  • Creating Queries
    Modifying Forms
    Creating and Using Reports
    Multi Table Queries
    Macro Techniques
    Sorting and Filtering
    Action Queries
    Working With Records
    Creating a Relational Database
    Macros on Forms
    Parameter Queries
    Creating a Lookup Database
    Designing a Lookup Database
    Aggregation Queries
    Navigation Pane Protection
    Setting Table Relationships
    Relational Database Design
    Adding Transactional Records
    Importing and Exporting Records
    DIY Forms
    Data Validation

  • See Training Course Details...

Email us about this courses

Other Sunderland Enable Technology Training Courses

JQuery Mobile - Sunderland JavaScript Training Courses
VBA Sunderland Training Courses
TSQL - Sunderland SQL Training Courses
PL/SQL Sunderland Training Courses
JQuery - Sunderland JavaScript Training Courses
SSIS Sunderland Training Courses