Enable Technology

ACCESS KIRKBY TRAINING COURSES 

ACCESS TRAINING COURSES KIRKBY




About Enable Technology Kirkby Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology training courses are delivered as instructor led courses. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We also offer the option of scheduling of Access course at a socially distanced venue near you in Kirkby. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

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. Our clients include: Canadian High Commission, Shell UK Oil Products Ltd, Birmingham City University, Wolverhampton City Council, West Bromwich Building Society, Homeserve PLC, Fujistu PLC and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Kirkby
  • 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 VBA's Error Trapping Options
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Procedures
    Setting Break Expressions
    Navigating the Access Object Hierarchy
    Specifying a Recordset Cursor Type
    Working with the ADODB Recordset Object
    Stepping through Code
    Working with Procedures and Functions
    Working with Events
    Understanding the Form Object
    Working with Inline Error Handling
    Working with Properties
    Using Intrinsic Functions
    Creating a Standard Module
    Specifying a Recordset Cursor Location - Optional
    Understanding Recordset Cursor Properties - Optional
    Writing an Error-Handling Routine

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Kirkby
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Navigation Pane Protection
    DIY Forms
    Working With Records
    Querying Techniques
    Adding Transactional Records
    Modifying Table Structures
    Getting to Know Access 
    Using a Navigation Form
    Adding Records to a Table
    Macros on Forms
    Action Queries
    Importing and Exporting Records
    Database Wellness
    Modifying Forms
    Database Security
    Formatting Tables
    Sorting and Filtering
    Creating a Lookup Database
    Parameter Queries
    Designing a Lookup Database
    Calculations in Queries

  • See Training Course Details...



Email us about this courses



Other Kirkby Enable Technology Training Courses

DAX Kirkby Training Courses
SSRS - Kirkby SQL Server Reporting Services Training Courses
SSAS Tabular Kirkby Training Courses
Power Query Kirkby Training Courses
Power BI Kirkby Training Courses
Excel Power Pivot Kirkby Training Courses