Enable Technology

ACCESS SOUTH SHIELDS TRAINING COURSES 

ACCESS TRAINING COURSES SOUTH SHIELDS




About Enable Technology South Shields Access Training Courses

Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local socially distanced training site. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: GKN PLC, Birmingham City Council, Nuclear Engineering Services, Nationwide Building Society Limited, West Bromwich Building Society, TalkTalk Direct Limited, Birmingham Heartlands Hospital and Canadian High Commission.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: South Shields
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding the Form Object
    Using the Object Browser
    Understanding Collections
    Understanding Error Handling
    Handling Errors
    Working with the Application Object
    Guidelines for use of Branching Structures
    Understanding Recordset Cursor Properties - Optional
    Creating a Standard Module
    Considering Variable Scope and Lifetime Together
    Understanding Constants
    Understanding Objects
    Using the CacheSize Property - Optional
    Introduction to Programming in Access
    Determining the Value of Expressions
    Working with Properties
    Creating a Function Procedure
    Navigating the Access Object Hierarchy
    Understanding VBA's Error Trapping Options

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: South Shields
  • 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 ...
  • Using a Navigation Form
    Creating a Relational Database
    Understanding VBA
    Relational Database Design
    Adding Transactional Records
    Creating and Using Forms
    Creating and Using Macros
    Designing a Lookup Database
    Database Wellness
    Database Security
    An Introduction to VBA
    Modifying Table Structures
    Setting Table Relationships
    Adding Records to a Table
    Getting to Know Access 
    Querying Techniques
    Macros on Forms
    DIY Forms
    Calculations in Queries
    Sorting and Filtering
    Creating a Lookup Database

  • See Training Course Details...



Email us about this courses



Other South Shields Enable Technology Training Courses

SSAS - South Shields SQL Server Analysis Services Training Courses
Power BI South Shields Training Courses
Power Query South Shields Training Courses
SSIS - South Shields SQL Server Integration Services Training Courses
DAX South Shields Training Courses
TSQL - South Shields SQL Training Courses