Enable Technology



About Enable Technology Macclesfield Access Training Courses

Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a socially distanced local training venue in Macclesfield. All Access courses can be customised to meet your particular requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Birmingham City University, National Power PLC, Royal Air Force, Capita Group PLC, Birmingham City Council, Nuclear Engineering Services, Aston University and Total Telecommunications Limited.

Microsoft Access

  • 2 day course
  • Location: Macclesfield
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Database Security
    Understanding VBA
    Relational Database Design
    Aggregation Queries
    Using a Navigation Form
    Creating a Lookup Database
    Data Validation
    Modifying Forms
    Calculations in Queries
    Creating and Using Macros
    Creating and Using Reports
    Macros on Forms
    Sorting and Filtering
    Parameter Queries
    An Introduction to VBA
    Action Queries
    Database Wellness
    DIY Forms
    Formatting Tables
    Adding Records to a Table
    Adding Transactional Records

  • See Training Course Details...

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Macclesfield
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Understanding Data Types
    Understanding Recordset Cursor Properties - Optional
    Stepping through Code
    Navigating the Access Object Hierarchy
    Working with Variable Lifetime
    Creating a Function Procedure
    Using the For...Next Structure
    Working with Properties
    Working with Boolean Expressions
    Understanding the Form Object
    Understanding Constants
    Using the Immediate Window to Call Procedures
    Creating a Sub Procedure
    Locking Records for Updating
    Understanding the Development Environment
    Using the Do...Loop Structure
    Specifying a Recordset Cursor Location - Optional
    Understanding Classes and Objects
    Using Visual Basic Help

  • See Training Course Details...

Email us about this courses

Other Macclesfield Enable Technology Training Courses

SSAS Tabular Macclesfield Training Courses
Excel 365 Advanced - Macclesfield Excel Training Courses
SSRS - Macclesfield SQL Server Reporting Services Training Courses
Power Query Macclesfield Training Courses
Oracle SQL Macclesfield Training Courses
VBA - Macclesfield Excel Training Courses