Enable Technology

ACCESS MOLD TRAINING COURSES 

ACCESS TRAINING COURSES MOLD




About Enable Technology Mold Access Training Courses

Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. 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. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are University of Birmingham, Fujistu PLC, Birmingham City Council, Cadbury PLC, Queen's Medical Centre Nottingham, Halfords Group PLC, GKN PLC and Dollond & Aitchison Limited.




Microsoft Access

  • 2 day course
  • Location: Mold
  • 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 ...
  • Modifying Table Structures
    Querying Techniques
    Macro Techniques
    Working With Records
    Importing and Exporting Records
    Parameter Queries
    Adding Records to a Table
    Aggregation Queries
    Multi Table Queries
    Database Security
    Macros on Forms
    Creating a Relational Database
    Designing a Lookup Database
    Creating a Lookup Database
    Calculations in Queries
    Creating and Using Reports
    Adding Transactional Records
    Action Queries
    DIY Forms
    Sorting and Filtering
    Data Validation

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Mold
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Using the With Statement
    Working with Boolean Expressions
    Trapping Errors with the On Error Statement
    Using the If...End If Decision Structures
    Introduction to Programming in Access
    Understanding Collections
    Understanding the Form Object
    Declaring Variables
    Using the Object Browser
    Using Intrinsic Functions
    Creating a Sub Procedure
    Using the For...Next Structure
    Understanding Data Types
    Why Program in Access?
    Handling Errors
    Understanding Errors
    Understanding Constants
    Working with Variable Lifetime
    Understanding Classes and Objects

  • See Training Course Details...



Email us about this courses



Other Mold Enable Technology Training Courses

VBA Mold Training Courses
SSAS - Mold SQL Server Analysis Services Training Courses
Oracle SQL Mold Training Courses
Power Query - Mold Excel Training Courses
Excel 365 Basic Mold Training Courses
PL/SQL Mold Training Courses