Enable Technology

ACCESS CHESTER TRAINING COURSES 

ACCESS TRAINING COURSES CHESTER




About Enable Technology Chester Access Training Courses

Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post training. 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 Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Chester. 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.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Norfolk Police Constabulary, Royal & Sun Alliance Group PLC, West Bromwich Building Society, Homeserve PLC, Dollond & Aitchison Limited, EDF Energy PLC and GKN PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Chester
  • 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 ...
  • Using Debugging Tools
    Specifying a Recordset Cursor Type
    Guidelines for use of Branching Structures
    Debugging Code
    Declaring Variables
    Handling Errors
    Working with Variable Lifetime
    Using the If...End If Decision Structures
    Understanding Procedures
    Working with Methods
    Using the CacheSize Property - Optional
    Understanding Constants
    Using the For Each...Next Structure
    Understanding the Order of Events
    Using Break Mode during Run Mode
    Understanding the Development Environment
    Using Message Boxes
    Writing an Error-Handling Routine

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Chester
  • 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 ...
  • Using a Navigation Form
    Action Queries
    Multi Table Queries
    Working With Records
    Data Validation
    Understanding VBA
    Database Security
    Adding Records to a Table
    Modifying Table Structures
    Creating a Relational Database
    Creating a Lookup Database
    Macros on Forms
    Getting to Know Access 
    Querying Techniques
    Setting Table Relationships
    Parameter Queries
    Creating and Using Forms
    Modifying Forms
    Calculations in Queries
    Creating Queries
    Aggregation Queries

  • See Training Course Details...



Email us about this courses



Other Chester Enable Technology Training Courses

SSAS Tabular Chester Training Courses
SSIS - Chester SQL Server Integration Services Training Courses
TSQL - Chester SQL Training Courses
Excel 365 Basic Chester Training Courses
Data Warehouse Chester Training Courses
SQL Chester Training Courses