Enable Technology



About Enable Technology Kidsgrove Access Training Courses

We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

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. The Access course could also be scheduled at a socially distanced site near you in Kidsgrove. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham Heartlands Hospital, Nuclear Engineering Services, Aston University, Royal Air Force, Norfolk Police Constabulary, Countrywide Homes Limited, GKN PLC and West Bromwich Building Society.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Kidsgrove
  • 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 Modules
    Determining the Value of Expressions
    Creating a Sub Procedure
    Understanding Control-of-Flow Structures
    Understanding the Development Environment
    Debugging Code
    Introduction to Programming in Access
    Working with Recordsets
    Stepping through Code
    Working with Methods
    Using Expressions, Variables, and Intrinsic Functions
    Guidelines for use of Branching Structures
    Working with the ADODB Recordset Object
    Using Input Boxes
    Using Debugging Tools
    Working with Events
    Specifying a Recordset Cursor Location - Optional
    Using the With Statement

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Kidsgrove
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating a Relational Database
    Database Wellness
    Action Queries
    Modifying Forms
    DIY Forms
    Querying Techniques
    Macros on Forms
    Relational Database Design
    Working With Records
    Adding Records to a Table
    Creating a Lookup Database
    Creating Queries
    Data Validation
    Multi Table Queries
    Aggregation Queries
    Calculations in Queries
    An Introduction to VBA
    Setting Table Relationships
    Importing and Exporting Records
    Macro Techniques
    Adding Transactional Records

  • See Training Course Details...

Email us about this courses

Other Kidsgrove Enable Technology Training Courses

JQuery Kidsgrove Training Courses
Data Warehouse - Kidsgrove SQL Training Courses
JQuery Mobile - Kidsgrove JavaScript Training Courses
Power BI - Kidsgrove Microsoft Power BI Training Courses
Excel 365 Basic Kidsgrove Training Courses
JavaScript - Kidsgrove JavaScript Training Courses