Enable Technology

ACCESS ASHTON-UNDER-LYNE TRAINING COURSES 

ACCESS TRAINING COURSES ASHTON-UNDER-LYNE




About Enable Technology Ashton-under-lyne Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. The Access course could also be scheduled at a socially distanced site near you in Ashton-under-lyne. Every Access course can be modified to meet your bespoke requirements.

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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Aston University, Barclays Bank PLC, Birmingham City Council, Total Telecommunications Limited, Norfolk Police Constabulary, Canadian High Commission, Carillion PLC and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: Ashton-under-lyne
  • 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 ...
  • Importing and Exporting Records
    Parameter Queries
    An Introduction to VBA
    Designing a Lookup Database
    Database Wellness
    Action Queries
    Understanding VBA
    Multi Table Queries
    Database Security
    Sorting and Filtering
    Formatting Tables
    Creating and Using Forms
    Querying Techniques
    Adding Records to a Table
    Aggregation Queries
    Getting to Know Access 
    DIY Forms
    Creating and Using Reports
    Data Validation
    Relational Database Design
    Macro Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ashton-under-lyne
  • Telephone on 01952 938014
  • 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 ...
  • Using the Object Browser
    Using the For Each...Next Structure
    Creating a Standard Module
    Stepping through Code
    Understanding Error Handling
    Guidelines for use of Branching Structures
    Using the Do...Loop Structure
    Understanding Expressions and Statements
    Declaring Variables
    Working with Inline Error Handling
    Working with Events
    Debugging Code
    Understanding Control-of-Flow Structures
    Handling Errors
    Organizing Code and Procedures
    Navigating the Access Object Hierarchy
    Understanding the Err Object
    Using Expressions, Variables, and Intrinsic Functions
    Using Input Boxes
    Using Intrinsic Functions
    Using the With Statement

  • See Training Course Details...



Email us about this courses



Other Ashton-under-lyne Enable Technology Training Courses

Excel 365 Basic Ashton-under-lyne Training Courses
Power Query - Ashton-under-lyne Excel Training Courses
Excel 365 Advanced - Ashton-under-lyne Excel Training Courses
PL/SQL Ashton-under-lyne Training Courses
JQuery Mobile Ashton-under-lyne Training Courses
SSAS Ashton-under-lyne Training Courses