Enable Technology

ACCESS SKELMERSDALE TRAINING COURSES 

ACCESS TRAINING COURSES SKELMERSDALE




About Enable Technology Skelmersdale Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

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. We are also more than happy to organise a local course at a training location in Skelmersdale. Every Access course can be modified to meet your bespoke 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 group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Barclays Bank PLC, Norwich Union PLC, Loughborough University, Carillion PLC, TalkTalk Direct Limited, Dollond & Aitchison Limited, Fujistu PLC and Lloyds TSB Bank PLC.




Microsoft Access

  • 2 day course
  • Location: Skelmersdale
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Modifying Forms
    Adding Transactional Records
    Using a Navigation Form
    Relational Database Design
    Macro Techniques
    Working With Records
    Creating a Relational Database
    Formatting Tables
    Creating and Using Reports
    An Introduction to VBA
    Creating and Using Macros
    Database Security
    Understanding VBA
    Creating Queries
    Sorting and Filtering
    DIY Forms
    Action Queries
    Multi Table Queries
    Data Validation
    Setting Table Relationships
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Skelmersdale
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Working with the ADODB Recordset Object
    Working with the Application Object
    Specifying a Recordset Cursor Type
    Stepping through Code
    Declaring Variables
    Working with Recordsets
    Understanding the DoCmd Object
    Specifying a Recordset Cursor Location - Optional
    Guidelines for use of Branching Structures
    Using the With Statement
    Understanding Data Types
    Working with Events
    Using the For Each...Next Structure
    Understanding the Development Environment
    Understanding Recordset Cursor Properties - Optional
    Understanding the Order of Events
    Trapping Errors with the On Error Statement
    Why Program in Access?

  • See Training Course Details...



Email us about this courses



Other Skelmersdale Enable Technology Training Courses

DAX - Skelmersdale Excel Training Courses
PL/SQL - Skelmersdale SQL Training Courses
Power BI Skelmersdale Training Courses
JQuery - Skelmersdale JavaScript Training Courses
Oracle SQL Skelmersdale Training Courses
JQuery Mobile Skelmersdale Training Courses