Enable Technology

ACCESS TEWKESBURY TRAINING COURSES 

ACCESS TRAINING COURSES TEWKESBURY




About Enable Technology Tewkesbury Access Training Courses

Enable Technology provides practical Access skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We also offer the option of scheduling of Access course at a socially distanced venue near you in Tewkesbury. We are happy to modify the Access syllabus to match your teams training requirements.

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: National Power PLC, Halfords Group PLC, South Staffordshire Water PLC, Total Telecommunications Limited, TalkTalk Direct Limited, Carillion PLC, Unipart Group and Countrywide Homes Limited.




Microsoft Access

  • 2 day course
  • Location: Tewkesbury
  • 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 ...
  • An Introduction to VBA
    Database Wellness
    Adding Records to a Table
    Creating and Using Forms
    Database Security
    Navigation Pane Protection
    Creating a Relational Database
    Working With Records
    Aggregation Queries
    Importing and Exporting Records
    Calculations in Queries
    Modifying Forms
    Macro Techniques
    Creating and Using Macros
    Designing a Lookup Database
    Action Queries
    Data Validation
    Relational Database Design
    Creating Queries
    Parameter Queries
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tewkesbury
  • Telephone on 01952 938014
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Writing an Error-Handling Routine
    Navigating the Access Object Hierarchy
    Working with Methods
    Understanding Collections
    Naming Procedures
    Declaring Variables
    Working with the ADODB Recordset Object
    Using the With Statement
    Understanding the DoCmd Object
    Working with Boolean Expressions
    Understanding the Development Environment
    Understanding Procedures
    Working with Procedures and Functions
    Creating a Sub Procedure
    Understanding Recordset Cursor Properties - Optional
    Handling Errors
    Using the Select Case...End Select Structure
    Understanding the Order of Events
    Declaring and Creating Object Variables

  • See Training Course Details...



Email us about this courses



Other Tewkesbury Enable Technology Training Courses

Power BI - Tewkesbury Microsoft Power BI Training Courses
SSIS Tewkesbury Training Courses
SSRS Tewkesbury Training Courses
Excel 365 Intermediate Tewkesbury Training Courses
PL/SQL - Tewkesbury SQL Training Courses
Data Warehouse Tewkesbury Training Courses