Enable Technology

ACCESS NUNEATON TRAINING COURSES 

ACCESS TRAINING COURSES NUNEATON




About Enable Technology Nuneaton Access Training Courses

We offer intensive two and three days Access courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a venue near you in Nuneaton. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.

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.

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Cadbury PLC, Yell Group PLC, Norfolk Police Constabulary, TalkTalk Direct Limited, DHL Express, Boots UK Limited, Royal & Sun Alliance Group PLC and GKN PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Nuneaton
  • 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 Intrinsic Constants
    Using the For Each...Next Structure
    Understanding Classes and Objects
    Understanding Errors
    Working with Procedures and Functions
    Working with the Code Editor
    Debugging Code
    Writing an Error-Handling Routine
    Using the CacheSize Property - Optional
    Working with the ADODB Recordset Object
    Setting Breakpoints
    Understanding Expressions and Statements
    Understanding the DoCmd Object
    Understanding Error Handling
    Using the For...Next Structure
    Using the Object Browser
    Using the Select Case...End Select Structure
    Working with Variable Scope
    Locking Records for Updating
    Controlling Program Execution

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Nuneaton
  • 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
    Database Security
    Adding Transactional Records
    Aggregation Queries
    Multi Table Queries
    Understanding VBA
    Creating Queries
    Creating and Using Forms
    Adding Records to a Table
    Calculations in Queries
    Database Wellness
    Working With Records
    Formatting Tables
    Relational Database Design
    Setting Table Relationships
    Getting to Know Access 
    Creating and Using Macros
    Action Queries
    Navigation Pane Protection
    Creating and Using Reports
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other Nuneaton Enable Technology Training Courses

TSQL - Nuneaton SQL Training Courses
Power BI Nuneaton Training Courses
SSIS - Nuneaton SQL Server Integration Services Training Courses
Excel 365 Basic - Nuneaton Excel Training Courses
PL/SQL - Nuneaton SQL Training Courses
SSRS - Nuneaton SQL Server Reporting Services Training Courses