Enable Technology

ACCESS GLOUCESTERSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES GLOUCESTERSHIRE




About Enable Technology Gloucestershire Access Training Courses

We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We also offer the option of scheduling of Access course at a socially distanced venue near you in Gloucestershire. 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.

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

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Cadbury PLC, Queen's Medical Centre Nottingham, Homeserve PLC, Birmingham City University, Shell UK Oil Products Ltd, National Power PLC, Canadian High Commission and Carillion PLC.




Microsoft Access

  • 2 day course
  • Location: Gloucestershire
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Parameter Queries
    Using a Navigation Form
    Understanding VBA
    Database Security
    Adding Transactional Records
    Macro Techniques
    Action Queries
    Sorting and Filtering
    Creating Queries
    Data Validation
    Adding Records to a Table
    Importing and Exporting Records
    Database Wellness
    Calculations in Queries
    Formatting Tables
    Creating and Using Macros
    Relational Database Design
    Multi Table Queries
    Aggregation Queries
    Designing a Lookup Database
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gloucestershire
  • 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 ...
  • Understanding Recordset Cursor Properties - Optional
    Understanding Objects
    Working with Procedures and Functions
    Using the For Each...Next Structure
    Working with the Code Editor
    Using Input Boxes
    Using the Object Browser
    Understanding VBA's Error Trapping Options
    Understanding the Order of Events
    Determining the Value of Expressions
    Using Break Mode during Run Mode
    Understanding Classes and Objects
    Creating a Sub Procedure
    Working with Properties
    Declaring and Creating Object Variables
    Working with Boolean Expressions
    Working with Methods
    Stepping through Code

  • See Training Course Details...



Email us about this courses



Other Gloucestershire Enable Technology Training Courses

SSAS - Gloucestershire SQL Server Analysis Services Training Courses
JQuery Mobile - Gloucestershire JavaScript Training Courses
PL/SQL - Gloucestershire SQL Training Courses
JQuery Gloucestershire Training Courses
Excel 365 Intermediate Gloucestershire Training Courses
Excel 365 Advanced Gloucestershire Training Courses