Enable Technology



About Enable Technology Wallasey Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

We provide instructor led training coupled with hands on training. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a course at a local socially distanced venue in Wallasey. All Access courses can be customised to meet your particular requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are DHL Express, Fujistu PLC, Wolverhampton City Council, Nationwide Building Society Limited, TalkTalk Direct Limited, EDF Energy PLC, Canadian High Commission and Birmingham City University.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wallasey
  • 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 Break Mode during Run Mode
    Specifying a Recordset Cursor Type
    Understanding Procedures
    Calling Procedures
    Introduction to Programming in Access
    Working with Variable Scope
    Working with the Application Object
    Setting Break Expressions
    Understanding Objects
    Handling Errors
    Understanding the DoCmd Object
    Understanding Classes and Objects
    Understanding Control-of-Flow Structures
    Considering Variable Scope and Lifetime Together
    Using the With Statement
    Naming Procedures
    Working with Procedures and Functions
    Working with Events
    Understanding Error Handling

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Wallasey
  • 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 a Relational Database
    Using a Navigation Form
    Creating Queries
    Creating a Lookup Database
    Multi Table Queries
    Adding Transactional Records
    Understanding VBA
    Querying Techniques
    Designing a Lookup Database
    Relational Database Design
    Parameter Queries
    Creating and Using Forms
    Modifying Table Structures
    Data Validation
    Action Queries
    Macro Techniques
    Adding Records to a Table
    DIY Forms
    Formatting Tables
    Sorting and Filtering
    Working With Records

  • See Training Course Details...

Email us about this courses

Other Wallasey Enable Technology Training Courses

Excel 365 Intermediate Wallasey Training Courses
VBA Wallasey Training Courses
Data Warehouse - Wallasey SQL Training Courses
SSAS - Wallasey SQL Server Analysis Services Training Courses
Excel 365 Basic Wallasey Training Courses
Oracle SQL - Wallasey SQL Training Courses