Enable Technology

ACCESS SCUNTHORPE TRAINING COURSES 

ACCESS TRAINING COURSES SCUNTHORPE




About Enable Technology Scunthorpe Access Training Courses

We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Scunthorpe. 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.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Cadbury PLC, Wolverhampton City Council, Total Telecommunications Limited, Lloyds TSB Bank PLC, Carillion PLC, Norfolk Police Constabulary, Halfords Group PLC and National Power PLC.




Microsoft Access

  • 2 day course
  • Location: Scunthorpe
  • 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 ...
  • DIY Forms
    Database Wellness
    Relational Database Design
    Modifying Forms
    Getting to Know Access 
    Macro Techniques
    Aggregation Queries
    Adding Transactional Records
    Creating and Using Forms
    Setting Table Relationships
    An Introduction to VBA
    Creating and Using Reports
    Importing and Exporting Records
    Using a Navigation Form
    Creating a Relational Database
    Querying Techniques
    Designing a Lookup Database
    Formatting Tables
    Modifying Table Structures
    Creating a Lookup Database
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Scunthorpe
  • 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 ...
  • Creating a Sub Procedure
    Debugging Code
    Understanding Errors
    Using Break Mode during Run Mode
    Understanding the Err Object
    Locking Records for Updating
    Using Input Boxes
    Naming Procedures
    Using Expressions, Variables, and Intrinsic Functions
    Using Message Boxes
    Using the Select Case...End Select Structure
    Understanding the Order of Events
    Working with Variable Scope
    Understanding the Development Environment
    Working with the ADODB Recordset Object
    Guidelines for use of Branching Structures
    Working with Events
    Creating a Standard Module
    Using the With Statement

  • See Training Course Details...



Email us about this courses



Other Scunthorpe Enable Technology Training Courses

JavaScript Scunthorpe Training Courses
Excel Power Pivot - Scunthorpe Excel Training Courses
Power BI Scunthorpe Training Courses
SSRS Scunthorpe Training Courses
VBA - Scunthorpe Excel Training Courses
PL/SQL - Scunthorpe SQL Training Courses