Enable Technology

ACCESS EAST MIDLANDS TRAINING COURSES 

ACCESS TRAINING COURSES EAST MIDLANDS




About Enable Technology East Midlands Access Training Courses

Enable Technology specialise in succinct skills based Access training. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in East Midlands. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Unipart Group, Birmingham City University, Shell UK Oil Products Ltd, Total Telecommunications Limited, Aston University, Yell Group PLC, University of Birmingham and Homeserve PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: East Midlands
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Working with Recordsets
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Data Types
    Using Debugging Tools
    Creating a Function Procedure
    Considering Variable Scope and Lifetime Together
    Using Message Boxes
    Calling Procedures
    Using Input Boxes
    Creating a Sub Procedure
    Understanding the Form Object
    Understanding Collections
    Introduction to Programming in Access
    Working with Variable Lifetime
    Understanding Procedures
    Using Break Mode during Run Mode
    Understanding Expressions and Statements
    Using the CacheSize Property - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: East Midlands
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • DIY Forms
    Importing and Exporting Records
    Querying Techniques
    Action Queries
    Navigation Pane Protection
    Aggregation Queries
    Parameter Queries
    Using a Navigation Form
    Formatting Tables
    Designing a Lookup Database
    Creating a Relational Database
    Creating and Using Macros
    Macro Techniques
    Database Wellness
    Calculations in Queries
    Getting to Know Access 
    Macros on Forms
    Multi Table Queries
    Modifying Table Structures
    Adding Transactional Records
    An Introduction to VBA

  • See Training Course Details...



Email us about this courses



Other East Midlands Enable Technology Training Courses

Excel Power Pivot East Midlands Training Courses
DAX East Midlands Training Courses
Excel 365 Intermediate East Midlands Training Courses
SSRS - East Midlands SQL Server Reporting Services Training Courses
SSAS Tabular East Midlands Training Courses
Oracle SQL - East Midlands SQL Training Courses