Enable Technology

ACCESS BLACKBURN TRAINING COURSES 

ACCESS TRAINING COURSES BLACKBURN




About Enable Technology Blackburn Access Training Courses

We have a twenty year history of providing skills based Access industry training. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.

Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. The Access course could also be scheduled at a socially distanced site near you in Blackburn. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Aston University, Shell UK Oil Products Ltd, Royal Air Force, Cadbury PLC, Loughborough University, Boots UK Limited, University of Birmingham and Capita Group PLC.




Microsoft Access

  • 2 day course
  • Location: Blackburn
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Data Validation
    Adding Transactional Records
    Database Security
    Macro Techniques
    Sorting and Filtering
    DIY Forms
    Aggregation Queries
    Creating and Using Macros
    Adding Records to a Table
    Database Wellness
    Creating and Using Forms
    Using a Navigation Form
    Querying Techniques
    Designing a Lookup Database
    Creating Queries
    Getting to Know Access 
    Creating a Lookup Database
    Importing and Exporting Records
    Creating a Relational Database
    Understanding VBA
    Creating and Using Reports

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Blackburn
  • 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 Control-of-Flow Structures
    Using the For Each...Next Structure
    Understanding the Development Environment
    Stepping through Code
    Understanding Objects
    Using Message Boxes
    Considering Variable Scope and Lifetime Together
    Declaring and Creating Object Variables
    Trapping Errors with the On Error Statement
    Using Intrinsic Constants
    Understanding Error Handling
    Understanding Modules
    Working with Variable Scope
    Understanding Classes and Objects
    Understanding Collections
    Organizing Code and Procedures
    Creating a Sub Procedure
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...



Email us about this courses



Other Blackburn Enable Technology Training Courses

SSIS Blackburn Training Courses
Power Query - Blackburn Excel Training Courses
Report Builder Blackburn Training Courses
SSRS Blackburn Training Courses
DAX - Blackburn Excel Training Courses
JQuery Mobile - Blackburn JavaScript Training Courses