Enable Technology

ACCESS SOUTH GLAMORGAN TRAINING COURSES 

ACCESS TRAINING COURSES SOUTH GLAMORGAN




About Enable Technology South Glamorgan Access Training Courses

Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. All course participants are issued Access training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a venue near you in South Glamorgan. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: TalkTalk Direct Limited, Shell UK Oil Products Ltd, National Power PLC, Queen's Medical Centre Nottingham, Barclays Bank PLC, Fujistu PLC, Wolverhampton City Council and Lloyds TSB Bank PLC.




Microsoft Access

  • 2 day course
  • Location: South Glamorgan
  • 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 ...
  • Parameter Queries
    Querying Techniques
    DIY Forms
    An Introduction to VBA
    Database Security
    Formatting Tables
    Data Validation
    Sorting and Filtering
    Using a Navigation Form
    Modifying Table Structures
    Multi Table Queries
    Macro Techniques
    Creating a Relational Database
    Creating a Lookup Database
    Importing and Exporting Records
    Adding Records to a Table
    Adding Transactional Records
    Designing a Lookup Database
    Creating and Using Reports
    Getting to Know Access 
    Creating and Using Macros

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: South Glamorgan
  • 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 ...
  • Handling Errors
    Understanding the Err Object
    Working with Methods
    Guidelines for use of Branching Structures
    Understanding Procedures
    Calling Procedures
    Using the CacheSize Property - Optional
    Understanding Errors
    Stepping through Code
    Specifying a Recordset Cursor Location - Optional
    Using Input Boxes
    Using the Do...Loop Structure
    Working with the ADODB Recordset Object
    Understanding Recordset Cursor Properties - Optional
    Using Intrinsic Functions
    Using the For Each...Next Structure
    Setting Breakpoints
    Using Visual Basic Help
    Working with Variable Scope

  • See Training Course Details...



Email us about this courses



Other South Glamorgan Enable Technology Training Courses

JQuery Mobile South Glamorgan Training Courses
SSAS - South Glamorgan SQL Server Analysis Services Training Courses
Data Warehouse South Glamorgan Training Courses
SQL - South Glamorgan SQL Training Courses
Excel 365 Basic South Glamorgan Training Courses
Excel Power Pivot South Glamorgan Training Courses