Enable Technology

ACCESS NORTHHAMPTON TRAINING COURSES 

ACCESS TRAINING COURSES NORTHHAMPTON




About Enable Technology Northhampton Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 Northhampton. 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.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Lloyds TSB Bank PLC, EDF Energy PLC, Halfords Group PLC, Fujistu PLC, West Bromwich Building Society, Capita Group PLC, Shell UK Oil Products Ltd and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Northhampton
  • 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 ...
  • Creating a Lookup Database
    Creating and Using Forms
    Database Security
    Modifying Table Structures
    Action Queries
    Adding Transactional Records
    Relational Database Design
    Creating Queries
    Creating a Relational Database
    Macros on Forms
    Importing and Exporting Records
    Working With Records
    Creating and Using Macros
    An Introduction to VBA
    Database Wellness
    Parameter Queries
    Sorting and Filtering
    DIY Forms
    Modifying Forms
    Navigation Pane Protection
    Data Validation

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Northhampton
  • 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 ...
  • Locking Records for Updating
    Creating a Sub Procedure
    Using Intrinsic Constants
    Using Intrinsic Functions
    Using the For...Next Structure
    Working with Boolean Expressions
    Declaring Variables
    Understanding Modules
    Writing an Error-Handling Routine
    Understanding Recordset Cursor Properties - Optional
    Using Message Boxes
    Debugging Code
    Setting Break Expressions
    Using Debugging Tools
    Working with Procedures and Functions
    Using Input Boxes
    Understanding the DoCmd Object
    Using the With Statement
    Understanding Collections
    Using Visual Basic Help
    Working with Methods

  • See Training Course Details...



Email us about this courses



Other Northhampton Enable Technology Training Courses

VBA - Northhampton Excel Training Courses
Power BI - Northhampton Microsoft Power BI Training Courses
Excel Power Pivot Northhampton Training Courses
SSAS Tabular - Northhampton SQL Server Analysis Services Training Courses
SSAS - Northhampton SQL Server Analysis Services Training Courses
SSIS - Northhampton SQL Server Integration Services Training Courses