Enable Technology



About Enable Technology Preston Access Training Courses

Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a socially distanced local training venue in Preston. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Wolverhampton City Council, Queen's Medical Centre Nottingham, DHL Express, Total Telecommunications Limited, Shell UK Oil Products Ltd, Canadian High Commission, GKN PLC and Capita Group PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Preston
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Working with Boolean Expressions
    Creating a Function Procedure
    Navigating the Access Object Hierarchy
    Working with Methods
    Using the Object Browser
    Using Debugging Tools
    Understanding Constants
    Specifying a Recordset Cursor Type
    Working with Variable Lifetime
    Using Visual Basic Help
    Understanding Modules
    Using the CacheSize Property - Optional
    Understanding the Development Environment
    Understanding the Err Object
    Stepping through Code
    Understanding VBA's Error Trapping Options
    Using Input Boxes
    Declaring Variables
    Organizing Code and Procedures
    Specifying a Recordset Cursor Location - Optional
    Calling Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Preston
  • 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 ...
  • Action Queries
    Creating and Using Macros
    Calculations in Queries
    Designing a Lookup Database
    Understanding VBA
    Parameter Queries
    Multi Table Queries
    Macro Techniques
    Aggregation Queries
    Modifying Forms
    DIY Forms
    Sorting and Filtering
    Working With Records
    Using a Navigation Form
    Database Security
    Adding Records to a Table
    Creating and Using Reports
    Data Validation
    Getting to Know Access 
    Navigation Pane Protection
    Creating a Relational Database

  • See Training Course Details...

Email us about this courses

Other Preston Enable Technology Training Courses

Excel 365 Intermediate - Preston Excel Training Courses
Power BI - Preston Microsoft Power BI Training Courses
SQL Preston Training Courses
VBA Preston Training Courses
DAX - Preston Excel Training Courses
Excel Power Pivot Preston Training Courses