Enable Technology



About Enable Technology Walsall Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to post training. 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.

Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Walsall. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are GKN PLC, Loughborough University, Boots UK Limited, Aston University, Vodafone Group Services, Fujistu PLC, South Staffordshire Water PLC and University of Birmingham.

Microsoft Access

  • 2 day course
  • Location: Walsall
  • 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 ...
  • Modifying Forms
    Calculations in Queries
    Creating and Using Reports
    Adding Records to a Table
    Adding Transactional Records
    Navigation Pane Protection
    An Introduction to VBA
    Creating Queries
    Setting Table Relationships
    Macros on Forms
    Database Wellness
    Parameter Queries
    Macro Techniques
    Formatting Tables
    Creating a Relational Database
    Querying Techniques
    Importing and Exporting Records
    Relational Database Design
    Aggregation Queries
    DIY Forms
    Sorting and Filtering

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Walsall
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Understanding Procedures
    Understanding Constants
    Using the For...Next Structure
    Understanding Collections
    Specifying a Recordset Cursor Type
    Declaring and Creating Object Variables
    Using Debugging Tools
    Working with Procedures and Functions
    Using the If...End If Decision Structures
    Using the Select Case...End Select Structure
    Writing an Error-Handling Routine
    Using Intrinsic Constants
    Understanding Recordset Cursor Properties - Optional
    Understanding Objects
    Using the Do...Loop Structure
    Handling Errors
    Creating a Sub Procedure
    Working with the Application Object
    Working with Properties

  • See Training Course Details...

Email us about this courses

Other Walsall Enable Technology Training Courses

SSIS - Walsall SQL Server Integration Services Training Courses
DAX Walsall Training Courses
SSAS Tabular Walsall Training Courses
SSAS - Walsall SQL Server Analysis Services Training Courses
Excel 365 Intermediate Walsall Training Courses
JavaScript Walsall Training Courses