Enable Technology

ACCESS LANCASHIRE TRAINING COURSES 

ACCESS TRAINING COURSES LANCASHIRE




About Enable Technology Lancashire Access Training Courses

We have a twenty year history of providing skills based Access industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

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. The Access course could also be scheduled at a socially distanced site near you in Lancashire. The Access syllabus can be modified to accommodate your specific training needs.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: TalkTalk Direct Limited, Barclays Bank PLC, Capita Group PLC, Norfolk Police Constabulary, Keele University, Nationwide Building Society Limited, Nuclear Engineering Services and Aston University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Lancashire
  • Telephone on 01952 938014
  • Course Outline
  • A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Introduction to Programming in Access
    Creating a Sub Procedure
    Using Intrinsic Constants
    Understanding Errors
    Calling Procedures
    Specifying a Recordset Cursor Type
    Understanding Constants
    Understanding the Order of Events
    Understanding Recordset Cursor Properties - Optional
    Understanding the DoCmd Object
    Understanding Classes and Objects
    Guidelines for use of Branching Structures
    Creating a Standard Module
    Handling Errors
    Creating a Function Procedure
    Using the CacheSize Property - Optional
    Understanding Modules
    Working with Boolean Expressions
    Working with Properties

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Lancashire
  • 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 ...
  • Working With Records
    Understanding VBA
    Creating Queries
    Creating a Lookup Database
    Adding Records to a Table
    Designing a Lookup Database
    Aggregation Queries
    Formatting Tables
    Relational Database Design
    Navigation Pane Protection
    Creating and Using Forms
    Importing and Exporting Records
    Calculations in Queries
    Parameter Queries
    Action Queries
    Creating and Using Reports
    Getting to Know Access 
    Querying Techniques
    Using a Navigation Form
    Database Wellness
    Macros on Forms

  • See Training Course Details...



Email us about this courses



Other Lancashire Enable Technology Training Courses

SSAS Tabular - Lancashire SQL Server Analysis Services Training Courses
PL/SQL Lancashire Training Courses
SSRS - Lancashire SQL Server Reporting Services Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
VBA Lancashire Training Courses
TSQL - Lancashire SQL Training Courses