Enable Technology

ACCESS HYDE TRAINING COURSES 

ACCESS TRAINING COURSES HYDE




About Enable Technology Hyde Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Hyde. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Dollond & Aitchison Limited, Wolverhampton City Council, DHL Express, Royal Air Force, GKN PLC, Royal & Sun Alliance Group PLC, Canadian High Commission and Unipart Group.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Hyde
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Handling Errors
    Understanding the Err Object
    Understanding the Development Environment
    Using the For Each...Next Structure
    Using Input Boxes
    Declaring and Creating Object Variables
    Working with Methods
    Working with the ADODB Recordset Object
    Creating a Sub Procedure
    Using the If...End If Decision Structures
    Considering Variable Scope and Lifetime Together
    Specifying a Recordset Cursor Type
    Naming Procedures
    Working with Properties
    Guidelines for use of Branching Structures
    Understanding Error Handling
    Understanding Modules
    Why Program in Access?

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Hyde
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Adding Records to a Table
    Setting Table Relationships
    Creating Queries
    Macro Techniques
    Creating a Lookup Database
    Creating and Using Forms
    An Introduction to VBA
    Using a Navigation Form
    Aggregation Queries
    Multi Table Queries
    Working With Records
    Importing and Exporting Records
    Understanding VBA
    Formatting Tables
    DIY Forms
    Parameter Queries
    Getting to Know Access 
    Sorting and Filtering
    Navigation Pane Protection
    Data Validation
    Adding Transactional Records

  • See Training Course Details...



Email us about this courses



Other Hyde Enable Technology Training Courses

Oracle SQL - Hyde SQL Training Courses
PL/SQL Hyde Training Courses
Data Warehouse Hyde Training Courses
JQuery Mobile Hyde Training Courses
Excel 365 Advanced Hyde Training Courses
SSIS - Hyde SQL Server Integration Services Training Courses