Enable Technology

ACCESS YSTRAD MYNACH TRAINING COURSES 

ACCESS TRAINING COURSES YSTRAD MYNACH




About Enable Technology Ystrad Mynach Access Training Courses

Enable Technology offer short intensive skills based Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Access courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Birmingham City Council, Birmingham Heartlands Hospital, Countrywide Homes Limited, Barclays Bank PLC, Lloyds TSB Bank PLC, Keele University, GKN PLC and Norfolk Police Constabulary.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ystrad Mynach
  • 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 ...
  • Working with Variable Lifetime
    Specifying a Recordset Cursor Location - Optional
    Creating a Sub Procedure
    Naming Procedures
    Navigating the Access Object Hierarchy
    Introduction to Programming in Access
    Understanding Error Handling
    Understanding Classes and Objects
    Controlling Program Execution
    Using the CacheSize Property - Optional
    Understanding the Form Object
    Using the Select Case...End Select Structure
    Working with Properties
    Working with the Application Object
    Using the Object Browser
    Understanding Expressions and Statements
    Using the With Statement
    Working with the ADODB Recordset Object
    Guidelines for use of Branching Structures
    Handling Errors
    Creating a Standard Module

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Ystrad Mynach
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

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

  • See Training Course Details...



Email us about this courses



Other Ystrad Mynach Enable Technology Training Courses

SSIS Ystrad Mynach Training Courses
SSRS Ystrad Mynach Training Courses
Excel 365 Basic Ystrad Mynach Training Courses
Data Warehouse Ystrad Mynach Training Courses
SQL Ystrad Mynach Training Courses
VBA - Ystrad Mynach Excel Training Courses