Enable Technology

ACCESS GATESHEAD TRAINING COURSES 

ACCESS TRAINING COURSES GATESHEAD




About Enable Technology Gateshead 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. 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. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a Access course at an alternative training site in Gateshead. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Capita Group PLC, Countrywide Homes Limited, Royal & Sun Alliance Group PLC, TalkTalk Direct Limited, Halfords Group PLC, Vodafone Group Services and Royal Air Force.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gateshead
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Declaring Variables
    Calling Procedures
    Understanding Objects
    Using the For...Next Structure
    Working with the Code Editor
    Using the If...End If Decision Structures
    Considering Variable Scope and Lifetime Together
    Understanding Collections
    Using the For Each...Next Structure
    Using Intrinsic Functions
    Working with the ADODB Recordset Object
    Using the Immediate Window to Call Procedures
    Trapping Errors with the On Error Statement
    Introduction to Programming in Access
    Handling Errors
    Using the Select Case...End Select Structure
    Working with Properties
    Creating a Sub Procedure
    Working with Variable Lifetime
    Creating a Standard Module

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Gateshead
  • 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 ...
  • Creating a Lookup Database
    Relational Database Design
    Designing a Lookup Database
    Importing and Exporting Records
    Parameter Queries
    An Introduction to VBA
    Working With Records
    Querying Techniques
    Adding Records to a Table
    Navigation Pane Protection
    Calculations in Queries
    Action Queries
    Database Wellness
    Understanding VBA
    Macro Techniques
    Modifying Forms
    Formatting Tables
    Sorting and Filtering
    Setting Table Relationships
    Creating and Using Reports
    DIY Forms

  • See Training Course Details...



Email us about this courses



Other Gateshead Enable Technology Training Courses

SQL - Gateshead SQL Training Courses
Report Builder - Gateshead SQL Server Reporting Services Training Courses
JQuery - Gateshead JavaScript Training Courses
Excel 365 Intermediate - Gateshead Excel Training Courses
JQuery Mobile - Gateshead JavaScript Training Courses
DAX Gateshead Training Courses