Enable Technology

ACCESS HEREFORD TRAINING COURSES 

ACCESS TRAINING COURSES HEREFORD




About Enable Technology Hereford Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

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 Hereford. We are happy to discuss customising the course content should you have particular Access training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Carillion PLC, National Power PLC, Halfords Group PLC, EDF Energy PLC, Nationwide Building Society Limited, Birmingham City Council, University of Birmingham and Loughborough University.




Microsoft Access

  • 2 day course
  • Location: Hereford
  • Telephone on 01952 938014
  • 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 ...
  • Creating Queries
    Navigation Pane Protection
    Setting Table Relationships
    Creating a Relational Database
    Macro Techniques
    Database Security
    Sorting and Filtering
    An Introduction to VBA
    Creating and Using Forms
    Multi Table Queries
    Calculations in Queries
    Using a Navigation Form
    Modifying Forms
    Understanding VBA
    DIY Forms
    Modifying Table Structures
    Creating and Using Macros
    Relational Database Design
    Designing a Lookup Database
    Formatting Tables
    Macros on Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Hereford
  • 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 ...
  • Debugging Code
    Understanding Data Types
    Working with Variable Scope
    Introduction to Programming in Access
    Creating a Standard Module
    Using Visual Basic Help
    Working with Procedures and Functions
    Using Intrinsic Functions
    Using the If...End If Decision Structures
    Understanding the Development Environment
    Using the Do...Loop Structure
    Using Break Mode during Run Mode
    Organizing Code and Procedures
    Understanding Control-of-Flow Structures
    Understanding Errors
    Calling Procedures
    Using the Select Case...End Select Structure
    Handling Errors
    Working with the ADODB Recordset Object
    Why Program in Access?
    Creating a Function Procedure

  • See Training Course Details...



Email us about this courses



Other Hereford Enable Technology Training Courses

TSQL Hereford Training Courses
DAX Hereford Training Courses
JQuery Hereford Training Courses
SSRS - Hereford SQL Server Reporting Services Training Courses
SSIS Hereford Training Courses
Excel Power Pivot Hereford Training Courses