Enable Technology

ACCESS CARLISLE TRAINING COURSES 

ACCESS TRAINING COURSES CARLISLE




About Enable Technology Carlisle Access Training Courses

Enable Technology specialise in succinct skills based Access training. 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. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Carlisle. All Access courses can be customised to meet your particular requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham Heartlands Hospital, University of Birmingham, Nationwide Building Society Limited, Aston University, Countrywide Homes Limited, Canadian High Commission, Unipart Group and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Carlisle
  • 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 and Using Reports
    Macros on Forms
    Macro Techniques
    Relational Database Design
    Calculations in Queries
    Creating a Relational Database
    Creating a Lookup Database
    Database Wellness
    Modifying Forms
    Creating and Using Forms
    Modifying Table Structures
    Querying Techniques
    Adding Transactional Records
    Multi Table Queries
    Data Validation
    Action Queries
    Creating Queries
    Formatting Tables
    Creating and Using Macros
    Navigation Pane Protection
    Working With Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Carlisle
  • 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 ...
  • Determining the Value of Expressions
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Working with Properties
    Considering Variable Scope and Lifetime Together
    Understanding Constants
    Using Message Boxes
    Working with Variable Lifetime
    Understanding Errors
    Understanding the Form Object
    Using the For...Next Structure
    Understanding the Err Object
    Introduction to Programming in Access
    Controlling Program Execution
    Using the Select Case...End Select Structure
    Using the With Statement
    Understanding the Order of Events
    Setting Break Expressions
    Handling Errors

  • See Training Course Details...



Email us about this courses



Other Carlisle Enable Technology Training Courses

SSAS - Carlisle SQL Server Analysis Services Training Courses
Power Query Carlisle Training Courses
TSQL Carlisle Training Courses
PL/SQL Carlisle Training Courses
JQuery Mobile Carlisle Training Courses
Excel 365 Basic - Carlisle Excel Training Courses