Enable Technology

ACCESS PRESTWICH TRAINING COURSES 

ACCESS TRAINING COURSES PRESTWICH




About Enable Technology Prestwich Access Training Courses

Enable Technology provides practical Access skills based technology training. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a Access course at an alternative training site in Prestwich. All Access courses can be customised to meet your particular requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: South Staffordshire Water PLC, Norwich Union PLC, Birmingham City Council, Loughborough University, Nuclear Engineering Services, Shell UK Oil Products Ltd, Yell Group PLC and Dollond & Aitchison Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Prestwich
  • 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 the Application Object
    Understanding VBA's Error Trapping Options
    Setting Breakpoints
    Using the For...Next Structure
    Understanding Constants
    Handling Errors
    Using Expressions, Variables, and Intrinsic Functions
    Using the If...End If Decision Structures
    Understanding Objects
    Using Intrinsic Functions
    Understanding the Order of Events
    Creating a Function Procedure
    Using the Do...Loop Structure
    Working with Inline Error Handling
    Using Input Boxes
    Writing an Error-Handling Routine
    Determining the Value of Expressions
    Understanding the Err Object
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Prestwich
  • 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 ...
  • Parameter Queries
    Setting Table Relationships
    Querying Techniques
    Getting to Know Access 
    Modifying Table Structures
    Importing and Exporting Records
    Database Security
    DIY Forms
    Understanding VBA
    Creating a Lookup Database
    Action Queries
    Adding Records to a Table
    Adding Transactional Records
    Modifying Forms
    Formatting Tables
    Using a Navigation Form
    Calculations in Queries
    Navigation Pane Protection
    Data Validation
    Creating and Using Macros
    Macros on Forms

  • See Training Course Details...



Email us about this courses



Other Prestwich Enable Technology Training Courses

Excel 365 Intermediate - Prestwich Excel Training Courses
Excel 365 Advanced Prestwich Training Courses
SSIS - Prestwich SQL Server Integration Services Training Courses
PL/SQL - Prestwich SQL Training Courses
SSAS Tabular - Prestwich SQL Server Analysis Services Training Courses
Excel 365 Basic - Prestwich Excel Training Courses