Enable Technology

ACCESS NEWCASTLE UNDER LYME TRAINING COURSES 

ACCESS TRAINING COURSES NEWCASTLE UNDER LYME




About Enable Technology Newcastle Under Lyme Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

Enable Technology training courses are delivered as instructor led courses. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a socially distanced venue near you in Newcastle Under Lyme. 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.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Halfords Group PLC, Shell UK Oil Products Ltd, DHL Express, Canadian High Commission, Nuclear Engineering Services, Yell Group PLC, Dollond & Aitchison Limited and Aston University.




Microsoft Access

  • 2 day course
  • Location: Newcastle Under Lyme
  • 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 ...
  • Macro Techniques
    Setting Table Relationships
    Creating a Relational Database
    Data Validation
    Multi Table Queries
    Importing and Exporting Records
    Getting to Know Access 
    Creating and Using Macros
    Calculations in Queries
    Adding Transactional Records
    Creating a Lookup Database
    Formatting Tables
    Parameter Queries
    Working With Records
    Aggregation Queries
    Designing a Lookup Database
    Action Queries
    DIY Forms
    Understanding VBA
    Relational Database Design
    Using a Navigation Form

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Newcastle Under Lyme
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Naming Procedures
    Working with Boolean Expressions
    Guidelines for use of Branching Structures
    Understanding the Development Environment
    Understanding Error Handling
    Understanding the Form Object
    Trapping Errors with the On Error Statement
    Creating a Standard Module
    Declaring Variables
    Writing an Error-Handling Routine
    Using Break Mode during Run Mode
    Using the For...Next Structure
    Understanding the Order of Events
    Using the Immediate Window to Call Procedures
    Specifying a Recordset Cursor Type
    Working with Methods
    Understanding Modules

  • See Training Course Details...



Email us about this courses



Other Newcastle Under Lyme Enable Technology Training Courses

Data Warehouse - Newcastle Under Lyme SQL Training Courses
Report Builder - Newcastle Under Lyme SQL Server Reporting Services Training Courses
SQL Newcastle Under Lyme Training Courses
JQuery - Newcastle Under Lyme JavaScript Training Courses
PL/SQL - Newcastle Under Lyme SQL Training Courses
Excel 365 Intermediate Newcastle Under Lyme Training Courses