Enable Technology

ACCESS STOURBRIDGE TRAINING COURSES 

ACCESS TRAINING COURSES STOURBRIDGE




About Enable Technology Stourbridge Access Training Courses

We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a venue near you in Stourbridge. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Royal Air Force, Fujistu PLC, Aston University, Queen's Medical Centre Nottingham, Nationwide Building Society Limited, Vodafone Group Services, Unipart Group and Cadbury PLC.




Microsoft Access

  • 2 day course
  • Location: Stourbridge
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Sorting and Filtering
    Database Security
    Macro Techniques
    Creating a Relational Database
    Getting to Know Access 
    An Introduction to VBA
    Modifying Forms
    Multi Table Queries
    Setting Table Relationships
    Using a Navigation Form
    Macros on Forms
    Navigation Pane Protection
    Adding Transactional Records
    Creating Queries
    Creating and Using Macros
    Aggregation Queries
    Data Validation
    Calculations in Queries
    Adding Records to a Table
    Creating and Using Forms
    Parameter Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Stourbridge
  • 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 the CacheSize Property - Optional
    Understanding the Form Object
    Creating a Sub Procedure
    Using the For Each...Next Structure
    Understanding the DoCmd Object
    Using the Select Case...End Select Structure
    Using the Immediate Window to Call Procedures
    Understanding Recordset Cursor Properties - Optional
    Using the With Statement
    Using the Object Browser
    Why Program in Access?
    Using Intrinsic Constants
    Understanding Error Handling
    Trapping Errors with the On Error Statement
    Setting Break Expressions
    Using Break Mode during Run Mode
    Using the For...Next Structure
    Using Expressions, Variables, and Intrinsic Functions
    Working with the Application Object
    Understanding Data Types

  • See Training Course Details...



Email us about this courses



Other Stourbridge Enable Technology Training Courses

SSRS - Stourbridge SQL Server Reporting Services Training Courses
Excel 365 Basic Stourbridge Training Courses
SSIS Stourbridge Training Courses
Power BI Stourbridge Training Courses
Power Query Stourbridge Training Courses
VBA Stourbridge Training Courses