Enable Technology

ACCESS CHESHIRE TRAINING COURSES 

ACCESS TRAINING COURSES CHESHIRE




About Enable Technology Cheshire Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Access resources which they can continue to use after the 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 offers instructor led training taught by technology specialists. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a venue near you in Cheshire. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Total Telecommunications Limited, Aston University, Fujistu PLC, West Bromwich Building Society, Birmingham City University, GKN PLC, Norfolk Police Constabulary and Nuclear Engineering Services.




Microsoft Access

  • 2 day course
  • Location: Cheshire
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Creating and Using Macros
    Database Wellness
    Multi Table Queries
    Calculations in Queries
    Formatting Tables
    Action Queries
    Designing a Lookup Database
    Database Security
    Creating and Using Reports
    Getting to Know Access 
    Working With Records
    Setting Table Relationships
    Navigation Pane Protection
    Creating a Relational Database
    Creating and Using Forms
    Understanding VBA
    Parameter Queries
    Creating Queries
    Using a Navigation Form
    Modifying Table Structures
    Aggregation Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cheshire
  • 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 ...
  • Declaring and Creating Object Variables
    Understanding Control-of-Flow Structures
    Working with Variable Lifetime
    Understanding Constants
    Navigating the Access Object Hierarchy
    Using the Object Browser
    Creating a Standard Module
    Working with Variable Scope
    Understanding the Form Object
    Debugging Code
    Understanding Objects
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Classes and Objects
    Setting Break Expressions
    Working with the ADODB Recordset Object
    Working with the Application Object
    Working with Recordsets
    Controlling Program Execution
    Using Input Boxes

  • See Training Course Details...



Email us about this courses



Other Cheshire Enable Technology Training Courses

Excel Power Pivot - Cheshire Excel Training Courses
TSQL Cheshire Training Courses
Oracle SQL Cheshire Training Courses
Power BI - Cheshire Microsoft Power BI Training Courses
SSRS Cheshire Training Courses
JavaScript - Cheshire JavaScript Training Courses