Enable Technology

ACCESS RHYL TRAINING COURSES 

ACCESS TRAINING COURSES RHYL




About Enable Technology Rhyl Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Access resources which they can continue to use 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.

We provide instructor led training coupled with hands on training. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Rhyl. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Keele University, Capita Group PLC, Loughborough University, Nationwide Building Society Limited, Canadian High Commission, GKN PLC, EDF Energy PLC and Lloyds TSB Bank PLC.




Microsoft Access

  • 2 day course
  • Location: Rhyl
  • 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 ...
  • Action Queries
    Setting Table Relationships
    Creating and Using Forms
    Navigation Pane Protection
    Adding Transactional Records
    Formatting Tables
    Getting to Know Access 
    Sorting and Filtering
    Creating and Using Reports
    Data Validation
    Macro Techniques
    Calculations in Queries
    Aggregation Queries
    DIY Forms
    Importing and Exporting Records
    Working With Records
    Creating a Relational Database
    Database Wellness
    Macros on Forms
    Querying Techniques
    Adding Records to a Table

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rhyl
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Creating a Sub Procedure
    Using the Immediate Window to Call Procedures
    Using Break Mode during Run Mode
    Introduction to Programming in Access
    Using the With Statement
    Understanding Constants
    Using Message Boxes
    Creating a Function Procedure
    Understanding the Development Environment
    Understanding the Err Object
    Understanding Modules
    Handling Errors
    Using the If...End If Decision Structures
    Using the Select Case...End Select Structure
    Understanding the Form Object
    Understanding Control-of-Flow Structures
    Trapping Errors with the On Error Statement
    Calling Procedures

  • See Training Course Details...



Email us about this courses



Other Rhyl Enable Technology Training Courses

Oracle SQL - Rhyl SQL Training Courses
SSIS Rhyl Training Courses
SQL - Rhyl SQL Training Courses
DAX Rhyl Training Courses
JavaScript Rhyl Training Courses
Excel 365 Intermediate - Rhyl Excel Training Courses