Enable Technology

ACCESS GORSEINON TRAINING COURSES 

ACCESS TRAINING COURSES GORSEINON




About Enable Technology Gorseinon Access Training Courses

We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to 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.

Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a socially distanced local training venue in Gorseinon. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

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.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Canadian High Commission, Barclays Bank PLC, West Bromwich Building Society, Nationwide Building Society Limited, Queen's Medical Centre Nottingham, Birmingham City University, Boots UK Limited and Total Telecommunications Limited.




Microsoft Access

  • 2 day course
  • Location: Gorseinon
  • 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 ...
  • Macros on Forms
    DIY Forms
    Database Security
    Designing a Lookup Database
    Working With Records
    Database Wellness
    Formatting Tables
    Creating and Using Macros
    Modifying Forms
    Parameter Queries
    Modifying Table Structures
    Action Queries
    Multi Table Queries
    Sorting and Filtering
    Calculations in Queries
    Navigation Pane Protection
    Relational Database Design
    Using a Navigation Form
    Aggregation Queries
    Creating a Relational Database
    Creating and Using Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gorseinon
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Why Program in Access?
    Using the CacheSize Property - Optional
    Understanding Objects
    Understanding the Err Object
    Considering Variable Scope and Lifetime Together
    Organizing Code and Procedures
    Stepping through Code
    Navigating the Access Object Hierarchy
    Using Visual Basic Help
    Working with Events
    Declaring and Creating Object Variables
    Using the Select Case...End Select Structure
    Handling Errors
    Determining the Value of Expressions
    Writing an Error-Handling Routine
    Understanding Constants
    Naming Procedures
    Using the Immediate Window to Call Procedures

  • See Training Course Details...



Email us about this courses



Other Gorseinon Enable Technology Training Courses

SQL Gorseinon Training Courses
PL/SQL - Gorseinon SQL Training Courses
SSIS - Gorseinon SQL Server Integration Services Training Courses
SSRS Gorseinon Training Courses
Excel 365 Advanced - Gorseinon Excel Training Courses
Excel 365 Intermediate Gorseinon Training Courses