Enable Technology

ACCESS RHYL TRAINING COURSES 

ACCESS TRAINING COURSES RHYL




About Enable Technology Rhyl Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with Access training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Access courses are taught by a Microsoft Certified Solutions Expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a venue near you in Rhyl. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training 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 been delivering technical training in the Midlands for twenty years. Our clients include: Canadian High Commission, Barclays Bank PLC, EDF Energy PLC, Birmingham City Council, Vodafone Group Services, Shell UK Oil Products Ltd, Birmingham City University and Cadbury PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rhyl
  • 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 ...
  • Understanding Recordset Cursor Properties - Optional
    Creating a Sub Procedure
    Using Visual Basic Help
    Guidelines for use of Branching Structures
    Why Program in Access?
    Trapping Errors with the On Error Statement
    Understanding Data Types
    Understanding Error Handling
    Using Message Boxes
    Writing an Error-Handling Routine
    Using the For Each...Next Structure
    Working with Procedures and Functions
    Understanding the Order of Events
    Understanding Expressions and Statements
    Understanding the Err Object
    Working with the ADODB Recordset Object
    Using Intrinsic Functions
    Understanding Errors
    Working with Boolean Expressions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Rhyl
  • 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 ...
  • Data Validation
    Navigation Pane Protection
    Creating and Using Macros
    Querying Techniques
    Creating a Relational Database
    Creating a Lookup Database
    Creating and Using Forms
    An Introduction to VBA
    Adding Records to a Table
    Understanding VBA
    Macro Techniques
    Parameter Queries
    Getting to Know Access 
    Working With Records
    Formatting Tables
    Creating and Using Reports
    Modifying Table Structures
    Adding Transactional Records
    Sorting and Filtering
    DIY Forms
    Designing a Lookup Database

  • See Training Course Details...



Email us about this courses



Other Rhyl Enable Technology Training Courses

Power BI - Rhyl Microsoft Power BI Training Courses
Excel 365 Advanced Rhyl Training Courses
TSQL - Rhyl SQL Training Courses
JavaScript Rhyl Training Courses
Power Query - Rhyl Excel Training Courses
Excel Power Pivot - Rhyl Excel Training Courses