Enable Technology

ACCESS ASHTON-UNDER-LYNE TRAINING COURSES 

ACCESS TRAINING COURSES ASHTON-UNDER-LYNE




About Enable Technology Ashton-under-lyne Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. We also offer the option of scheduling of Access course at a socially distanced venue near you in Ashton-under-lyne. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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.

We have operated primarily in the West Midlands for twenty years. Some of our clients are Cadbury PLC, Homeserve PLC, Royal & Sun Alliance Group PLC, Capita Group PLC, Keele University, Queen's Medical Centre Nottingham, South Staffordshire Water PLC and EDF Energy PLC.




Microsoft Access

  • 2 day course
  • Location: Ashton-under-lyne
  • Telephone on 01952 305730
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Designing a Lookup Database
    Database Wellness
    Getting to Know Access 
    Calculations in Queries
    Creating a Lookup Database
    Multi Table Queries
    Creating Queries
    Setting Table Relationships
    Importing and Exporting Records
    Working With Records
    Macro Techniques
    Data Validation
    Parameter Queries
    Creating a Relational Database
    Formatting Tables
    Creating and Using Macros
    Relational Database Design
    An Introduction to VBA
    Macros on Forms
    Adding Transactional Records
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ashton-under-lyne
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Understanding Constants
    Using the For Each...Next Structure
    Using Break Mode during Run Mode
    Using the For...Next Structure
    Understanding Expressions and Statements
    Understanding the Form Object
    Understanding Data Types
    Naming Procedures
    Understanding VBA's Error Trapping Options
    Creating a Sub Procedure
    Using Intrinsic Functions
    Working with Inline Error Handling
    Working with Recordsets
    Working with the Application Object
    Using the Do...Loop Structure
    Understanding Recordset Cursor Properties - Optional
    Specifying a Recordset Cursor Type
    Debugging Code
    Writing an Error-Handling Routine
    Using the Immediate Window to Call Procedures
    Working with Properties

  • See Training Course Details...



Email us about this courses



Other Ashton-under-lyne Enable Technology Training Courses

Oracle SQL - Ashton-under-lyne SQL Training Courses
Excel Intermediate - Ashton-under-lyne Excel Training Courses
SSAS 2017 Ashton-under-lyne Training Courses
PL/SQL - Ashton-under-lyne SQL Training Courses
SQL - Ashton-under-lyne SQL Training Courses
Project 2016 L1 - Ashton-under-lyne Microsoft Project Training Courses