Enable Technology

ACCESS EAST MIDLANDS TRAINING COURSES 

ACCESS TRAINING COURSES EAST MIDLANDS




About Enable Technology East Midlands Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. 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. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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 have operated primarily in the West Midlands for twenty years. Some of our clients are TalkTalk Direct Limited, Homeserve PLC, Dollond & Aitchison Limited, Fujistu PLC, Keele University, Queen's Medical Centre Nottingham, Capita Group PLC and National Power PLC.




Microsoft Access

  • 2 day course
  • Location: East Midlands
  • 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
    Relational Database Design
    Sorting and Filtering
    Modifying Table Structures
    Setting Table Relationships
    Multi Table Queries
    Creating and Using Macros
    Modifying Forms
    Formatting Tables
    Creating Queries
    Designing a Lookup Database
    DIY Forms
    Aggregation Queries
    An Introduction to VBA
    Data Validation
    Navigation Pane Protection
    Understanding VBA
    Calculations in Queries
    Creating a Lookup Database
    Working With Records
    Database Wellness

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: East Midlands
  • 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 ...
  • Understanding Recordset Cursor Properties - Optional
    Using the Do...Loop Structure
    Understanding Error Handling
    Working with Variable Lifetime
    Using the If...End If Decision Structures
    Working with Procedures and Functions
    Using the For Each...Next Structure
    Declaring Variables
    Understanding Errors
    Naming Procedures
    Working with the Code Editor
    Navigating the Access Object Hierarchy
    Handling Errors
    Why Program in Access?
    Using the For...Next Structure
    Working with Recordsets
    Considering Variable Scope and Lifetime Together
    Using the Select Case...End Select Structure
    Using Visual Basic Help

  • See Training Course Details...



Email us about this courses



Other East Midlands Enable Technology Training Courses

Excel Power Pivot East Midlands Training Courses
Report Builder - East Midlands SQL Server Reporting Services Training Courses
TSQL - East Midlands SQL Training Courses
Excel 365 Intermediate East Midlands Training Courses
PL/SQL - East Midlands SQL Training Courses
SSAS Tabular - East Midlands SQL Server Analysis Services Training Courses