Enable Technology

ACCESS LEIGH TRAINING COURSES 

ACCESS TRAINING COURSES LEIGH




About Enable Technology Leigh Access Training Courses

We offer intensive two and three days Access courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Leigh. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Homeserve PLC, Norfolk Police Constabulary, TalkTalk Direct Limited, Loughborough University, Total Telecommunications Limited, Birmingham City Council, Halfords Group PLC and Capita Group PLC.




Microsoft Access

  • 2 day course
  • Location: Leigh
  • 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
    Action Queries
    Working With Records
    Creating and Using Macros
    Calculations in Queries
    Modifying Table Structures
    Creating Queries
    Creating a Relational Database
    Creating and Using Forms
    Adding Transactional Records
    Data Validation
    An Introduction to VBA
    Creating a Lookup Database
    Designing a Lookup Database
    Importing and Exporting Records
    Multi Table Queries
    Database Wellness
    Aggregation Queries
    Creating and Using Reports
    Adding Records to a Table
    Sorting and Filtering

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leigh
  • 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 ...
  • Using Message Boxes
    Working with Properties
    Using Break Mode during Run Mode
    Specifying a Recordset Cursor Type
    Using Input Boxes
    Working with Recordsets
    Understanding VBA's Error Trapping Options
    Understanding the Err Object
    Calling Procedures
    Using Visual Basic Help
    Using the If...End If Decision Structures
    Declaring Variables
    Working with Events
    Writing an Error-Handling Routine
    Controlling Program Execution
    Understanding Modules
    Understanding Data Types
    Understanding the DoCmd Object
    Understanding the Form Object
    Working with Variable Lifetime

  • See Training Course Details...



Email us about this courses



Other Leigh Enable Technology Training Courses

VBA - Leigh Excel Training Courses
Excel 365 Basic - Leigh Excel Training Courses
JQuery Mobile - Leigh JavaScript Training Courses
Oracle SQL Leigh Training Courses
Report Builder - Leigh SQL Server Reporting Services Training Courses
Excel 365 Intermediate Leigh Training Courses