Enable Technology

ACCESS CANNOCK TRAINING COURSES 

ACCESS TRAINING COURSES CANNOCK




About Enable Technology Cannock Access Training Courses

We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a socially distanced local training venue in Cannock. We are happy to discuss customising the course content should you have particular Access training requirements.

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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Carillion PLC, Barclays Bank PLC, Queen's Medical Centre Nottingham, Unipart Group, Nationwide Building Society Limited, Vodafone Group Services, Aston University and Capita Group PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Cannock
  • 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 ...
  • Working with Properties
    Using Expressions, Variables, and Intrinsic Functions
    Why Program in Access?
    Using the For...Next Structure
    Trapping Errors with the On Error Statement
    Introduction to Programming in Access
    Working with Variable Lifetime
    Writing an Error-Handling Routine
    Working with Procedures and Functions
    Understanding Procedures
    Working with the Code Editor
    Controlling Program Execution
    Using the If...End If Decision Structures
    Creating a Function Procedure
    Understanding the Order of Events
    Handling Errors
    Understanding Control-of-Flow Structures
    Working with the ADODB Recordset Object
    Working with Methods

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Cannock
  • 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 ...
  • Creating and Using Macros
    Aggregation Queries
    Designing a Lookup Database
    Creating a Relational Database
    Adding Records to a Table
    An Introduction to VBA
    Understanding VBA
    Importing and Exporting Records
    Using a Navigation Form
    Modifying Forms
    Macro Techniques
    Creating and Using Forms
    Parameter Queries
    Modifying Table Structures
    Creating and Using Reports
    Action Queries
    Creating a Lookup Database
    Getting to Know Access 
    Working With Records
    Multi Table Queries
    Relational Database Design

  • See Training Course Details...



Email us about this courses



Other Cannock Enable Technology Training Courses

Excel 365 Advanced Cannock Training Courses
Excel Power Pivot Cannock Training Courses
JQuery Mobile - Cannock JavaScript Training Courses
Data Warehouse Cannock Training Courses
TSQL Cannock Training Courses
SQL - Cannock SQL Training Courses