Enable Technology



About Enable Technology Bryn Pydew Access Training Courses

Enable Technology specialise in succinct skills based Access training. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Bryn Pydew. We are happy to discuss customising the course content should you have particular Access training requirements.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Boots UK Limited, Countrywide Homes Limited, Yell Group PLC, DHL Express, Loughborough University, Nationwide Building Society Limited, Vodafone Group Services and Wolverhampton City Council.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Bryn Pydew
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Introduction to Programming in Access
    Understanding Classes and Objects
    Understanding the DoCmd Object
    Organizing Code and Procedures
    Trapping Errors with the On Error Statement
    Working with Variable Lifetime
    Using the Select Case...End Select Structure
    Working with Procedures and Functions
    Specifying a Recordset Cursor Type
    Using Expressions, Variables, and Intrinsic Functions
    Setting Breakpoints
    Understanding Data Types
    Using Visual Basic Help
    Using the Do...Loop Structure
    Understanding Constants
    Working with the Application Object
    Using Intrinsic Functions
    Writing an Error-Handling Routine
    Calling Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Bryn Pydew
  • 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 ...
  • Understanding VBA
    Importing and Exporting Records
    Creating and Using Forms
    Modifying Forms
    Creating a Lookup Database
    Using a Navigation Form
    Adding Transactional Records
    Multi Table Queries
    Parameter Queries
    Sorting and Filtering
    Querying Techniques
    Creating and Using Macros
    Macro Techniques
    DIY Forms
    Database Wellness
    Aggregation Queries
    An Introduction to VBA
    Action Queries
    Creating a Relational Database
    Modifying Table Structures
    Navigation Pane Protection

  • See Training Course Details...

Email us about this courses

Other Bryn Pydew Enable Technology Training Courses

Report Builder Bryn Pydew Training Courses
Power BI Bryn Pydew Training Courses
Data Warehouse - Bryn Pydew SQL Training Courses
JQuery Bryn Pydew Training Courses
SSRS Bryn Pydew Training Courses
SSIS - Bryn Pydew SQL Server Integration Services Training Courses