Enable Technology

ACCESS MERTHYR TYDFIL TRAINING COURSES 

ACCESS TRAINING COURSES MERTHYR TYDFIL




About Enable Technology Merthyr Tydfil Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Merthyr Tydfil. All Access courses can be customised to meet your particular requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Our clients include: Shell UK Oil Products Ltd, Birmingham City Council, Capita Group PLC, Wolverhampton City Council, Boots UK Limited, EDF Energy PLC, Birmingham Heartlands Hospital and Homeserve PLC.




Microsoft Access

  • 2 day course
  • Location: Merthyr Tydfil
  • 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 a Relational Database
    Getting to Know Access 
    Querying Techniques
    Calculations in Queries
    Sorting and Filtering
    Setting Table Relationships
    Formatting Tables
    Modifying Forms
    Creating a Lookup Database
    Action Queries
    Adding Transactional Records
    Importing and Exporting Records
    Macro Techniques
    Adding Records to a Table
    Understanding VBA
    Relational Database Design
    Aggregation Queries
    Creating and Using Macros
    Data Validation
    Macros on Forms
    Creating and Using Reports

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Merthyr Tydfil
  • Telephone on 01952 938014
  • 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 ...
  • Working with the ADODB Recordset Object
    Understanding the Order of Events
    Understanding Data Types
    Creating a Function Procedure
    Determining the Value of Expressions
    Using the Object Browser
    Debugging Code
    Understanding Error Handling
    Using the Do...Loop Structure
    Understanding the DoCmd Object
    Working with Properties
    Guidelines for use of Branching Structures
    Navigating the Access Object Hierarchy
    Understanding Constants
    Organizing Code and Procedures
    Naming Procedures
    Why Program in Access?

  • See Training Course Details...



Email us about this courses



Other Merthyr Tydfil Enable Technology Training Courses

Power Query Merthyr Tydfil Training Courses
SSRS - Merthyr Tydfil SQL Server Reporting Services Training Courses
Excel 365 Advanced - Merthyr Tydfil Excel Training Courses
VBA Merthyr Tydfil Training Courses
Excel 365 Intermediate Merthyr Tydfil Training Courses
SQL - Merthyr Tydfil SQL Training Courses