Enable Technology

ACCESS TEWKESBURY TRAINING COURSES 

ACCESS TRAINING COURSES TEWKESBURY




About Enable Technology Tewkesbury Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every person attending a Access course will be provided with training materials and practice files to retain 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.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a Access course at an alternative training site in Tewkesbury. 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.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City Council, Norwich Union PLC, Total Telecommunications Limited, Wolverhampton City Council, TalkTalk Direct Limited, University of Birmingham, Yell Group PLC and Norfolk Police Constabulary.




Microsoft Access

  • 2 day course
  • Location: Tewkesbury
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Importing and Exporting Records
    Relational Database Design
    Setting Table Relationships
    Multi Table Queries
    Creating and Using Reports
    DIY Forms
    Navigation Pane Protection
    Using a Navigation Form
    Querying Techniques
    Database Security
    Creating a Relational Database
    Creating Queries
    Macro Techniques
    Action Queries
    Getting to Know Access 
    Designing a Lookup Database
    Creating a Lookup Database
    Working With Records
    Modifying Table Structures
    Formatting Tables
    Calculations in Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tewkesbury
  • 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 ...
  • Organizing Code and Procedures
    Using Visual Basic Help
    Understanding Collections
    Using the With Statement
    Working with Events
    Creating a Sub Procedure
    Using the Object Browser
    Working with Variable Lifetime
    Understanding Data Types
    Working with the Application Object
    Declaring Variables
    Working with Methods
    Understanding VBA's Error Trapping Options
    Trapping Errors with the On Error Statement
    Why Program in Access?
    Introduction to Programming in Access
    Considering Variable Scope and Lifetime Together
    Creating a Standard Module

  • See Training Course Details...



Email us about this courses



Other Tewkesbury Enable Technology Training Courses

TSQL Tewkesbury Training Courses
SQL Tewkesbury Training Courses
Oracle SQL Tewkesbury Training Courses
SSAS Tabular - Tewkesbury SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Tewkesbury Excel Training Courses
Excel Power Pivot - Tewkesbury Excel Training Courses