Enable Technology

ACCESS HALESOWEN TRAINING COURSES 

ACCESS TRAINING COURSES HALESOWEN




About Enable Technology Halesowen Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in Halesowen. The Access syllabus can be adjusted and additional topics incorporated if helpful.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal Air Force, Birmingham City Council, South Staffordshire Water PLC, University of Birmingham, Birmingham Heartlands Hospital, Countrywide Homes Limited, Cadbury PLC and Canadian High Commission.




Microsoft Access

  • 2 day course
  • Location: Halesowen
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Data Validation
    Working With Records
    Creating and Using Reports
    DIY Forms
    Macros on Forms
    Designing a Lookup Database
    Creating and Using Forms
    An Introduction to VBA
    Parameter Queries
    Navigation Pane Protection
    Understanding VBA
    Formatting Tables
    Setting Table Relationships
    Aggregation Queries
    Adding Records to a Table
    Importing and Exporting Records
    Database Wellness
    Creating a Lookup Database
    Creating Queries
    Modifying Forms
    Using a Navigation Form

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Halesowen
  • 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 the Object Browser
    Working with the Code Editor
    Using Debugging Tools
    Working with Inline Error Handling
    Using the Do...Loop Structure
    Using the Select Case...End Select Structure
    Writing an Error-Handling Routine
    Using Intrinsic Functions
    Debugging Code
    Understanding Collections
    Understanding Procedures
    Understanding Error Handling
    Working with Properties
    Stepping through Code
    Understanding Recordset Cursor Properties - Optional
    Trapping Errors with the On Error Statement
    Using the For Each...Next Structure
    Declaring Variables
    Guidelines for use of Branching Structures
    Working with the Application Object

  • See Training Course Details...



Email us about this courses



Other Halesowen Enable Technology Training Courses

Report Builder - Halesowen SQL Server Reporting Services Training Courses
Power BI - Halesowen Microsoft Power BI Training Courses
SSRS - Halesowen SQL Server Reporting Services Training Courses
DAX - Halesowen Excel Training Courses
Oracle SQL - Halesowen SQL Training Courses
SSAS - Halesowen SQL Server Analysis Services Training Courses