Enable Technology



About Enable Technology Milford Haven Access Training Courses

Enable Technology provides practical Access skills based technology training. 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. 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 offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Milford Haven. We are happy to modify the Access syllabus to match your teams training 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. Some of our clients are Unipart Group, Loughborough University, Yell Group PLC, Wolverhampton City Council, West Bromwich Building Society, Birmingham Heartlands Hospital, Birmingham City University and Royal Air Force.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Milford Haven
  • 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 For...Next Structure
    Understanding the Development Environment
    Setting Breakpoints
    Understanding the Err Object
    Working with Recordsets
    Using the If...End If Decision Structures
    Declaring and Creating Object Variables
    Considering Variable Scope and Lifetime Together
    Naming Procedures
    Understanding Errors
    Writing an Error-Handling Routine
    Setting Break Expressions
    Navigating the Access Object Hierarchy
    Creating a Function Procedure
    Understanding the Order of Events
    Understanding Classes and Objects
    Debugging Code
    Creating a Sub Procedure
    Why Program in Access?
    Working with Boolean Expressions

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Milford Haven
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating and Using Forms
    Formatting Tables
    Creating Queries
    Database Wellness
    An Introduction to VBA
    Database Security
    Understanding VBA
    Calculations in Queries
    Setting Table Relationships
    Designing a Lookup Database
    DIY Forms
    Importing and Exporting Records
    Navigation Pane Protection
    Macros on Forms
    Adding Transactional Records
    Action Queries
    Modifying Forms
    Creating and Using Reports
    Getting to Know Access 
    Adding Records to a Table
    Aggregation Queries

  • See Training Course Details...

Email us about this courses

Other Milford Haven Enable Technology Training Courses

TSQL Milford Haven Training Courses
JavaScript Milford Haven Training Courses
Excel 365 Intermediate - Milford Haven Excel Training Courses
Report Builder - Milford Haven SQL Server Reporting Services Training Courses
SSIS - Milford Haven SQL Server Integration Services Training Courses
DAX - Milford Haven Excel Training Courses