Enable Technology

ACCESS YOEVIL TRAINING COURSES 

ACCESS TRAINING COURSES YOEVIL




About Enable Technology Yoevil Access Training Courses

We have a twenty year history of providing skills based Access industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Yoevil. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Barclays Bank PLC, Shell UK Oil Products Ltd, Yell Group PLC, University of Birmingham, Vodafone Group Services, Loughborough University, Nuclear Engineering Services and National Power PLC.




Microsoft Access

  • 2 day course
  • Location: Yoevil
  • 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 ...
  • Adding Records to a Table
    Designing a Lookup Database
    Understanding VBA
    Modifying Table Structures
    Calculations in Queries
    Sorting and Filtering
    Using a Navigation Form
    Database Wellness
    Action Queries
    Creating a Relational Database
    Setting Table Relationships
    Aggregation Queries
    Importing and Exporting Records
    Multi Table Queries
    DIY Forms
    Data Validation
    Navigation Pane Protection
    Creating and Using Reports
    Modifying Forms
    Adding Transactional Records
    Working With Records

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Yoevil
  • 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 ...
  • Controlling Program Execution
    Working with the ADODB Recordset Object
    Using the Select Case...End Select Structure
    Understanding Constants
    Creating a Standard Module
    Working with Methods
    Using Visual Basic Help
    Using the With Statement
    Creating a Sub Procedure
    Using the Immediate Window to Call Procedures
    Considering Variable Scope and Lifetime Together
    Using the For Each...Next Structure
    Understanding Expressions and Statements
    Using Message Boxes
    Why Program in Access?
    Using the CacheSize Property - Optional
    Working with Events
    Trapping Errors with the On Error Statement
    Understanding Error Handling

  • See Training Course Details...



Email us about this courses



Other Yoevil Enable Technology Training Courses

SSIS Yoevil Training Courses
Excel 365 Advanced - Yoevil Excel Training Courses
DAX Yoevil Training Courses
SSAS Tabular - Yoevil SQL Server Analysis Services Training Courses
Excel Power Pivot Yoevil Training Courses
Power Query Yoevil Training Courses