Enable Technology

ACCESS HEREFORDSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES HEREFORDSHIRE




About Enable Technology Herefordshire Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver Access training courses onsite at your premises. If delivery onsite is an issue we will organise a socially distanced venue near you in Herefordshire. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

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 Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Queen's Medical Centre Nottingham, Keele University, Nuclear Engineering Services, Vodafone Group Services, Royal & Sun Alliance Group PLC, Canadian High Commission, Unipart Group and Norwich Union PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Herefordshire
  • 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 Control-of-Flow Structures
    Using the Do...Loop Structure
    Using Intrinsic Functions
    Declaring and Creating Object Variables
    Understanding Data Types
    Using Debugging Tools
    Creating a Function Procedure
    Creating a Sub Procedure
    Setting Break Expressions
    Understanding Modules
    Declaring Variables
    Using Message Boxes
    Understanding the Form Object
    Understanding Errors
    Considering Variable Scope and Lifetime Together
    Locking Records for Updating
    Setting Breakpoints
    Working with the Application Object
    Working with Methods

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Herefordshire
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Aggregation Queries
    Using a Navigation Form
    Understanding VBA
    Action Queries
    Adding Records to a Table
    Macro Techniques
    Formatting Tables
    Modifying Table Structures
    Navigation Pane Protection
    Database Wellness
    Creating and Using Macros
    DIY Forms
    Relational Database Design
    Creating a Relational Database
    Creating and Using Forms
    Getting to Know Access 
    Parameter Queries
    Querying Techniques
    Macros on Forms
    Sorting and Filtering
    Adding Transactional Records

  • See Training Course Details...



Email us about this courses



Other Herefordshire Enable Technology Training Courses

SSRS - Herefordshire SQL Server Reporting Services Training Courses
Excel 365 Intermediate Herefordshire Training Courses
VBA - Herefordshire Excel Training Courses
SSAS - Herefordshire SQL Server Analysis Services Training Courses
SSIS Herefordshire Training Courses
DAX - Herefordshire Excel Training Courses