Enable Technology

ACCESS SHROPSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES SHROPSHIRE




About Enable Technology Shropshire Access Training Courses

Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain 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 provide instructor led training coupled with hands on training. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local socially distanced training site in Shropshire. We are happy to modify the Access syllabus to match your teams training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Unipart Group, Yell Group PLC, Countrywide Homes Limited, Queen's Medical Centre Nottingham, Royal Air Force, Dollond & Aitchison Limited, West Bromwich Building Society and TalkTalk Direct Limited.




Microsoft Access

  • 2 day course
  • Location: Shropshire
  • Telephone on 01952 938014
  • 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 ...
  • Navigation Pane Protection
    Parameter Queries
    Creating a Relational Database
    Creating and Using Reports
    Understanding VBA
    Macro Techniques
    Sorting and Filtering
    Setting Table Relationships
    Database Security
    Getting to Know Access 
    Multi Table Queries
    Creating Queries
    Database Wellness
    Macros on Forms
    Designing a Lookup Database
    Adding Records to a Table
    Modifying Table Structures
    DIY Forms
    Formatting Tables
    Using a Navigation Form
    Aggregation Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Shropshire
  • 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 ...
  • Understanding the DoCmd Object
    Using the Select Case...End Select Structure
    Using Expressions, Variables, and Intrinsic Functions
    Working with Variable Lifetime
    Working with the Code Editor
    Understanding Procedures
    Using Message Boxes
    Declaring Variables
    Working with Properties
    Understanding the Development Environment
    Navigating the Access Object Hierarchy
    Understanding Errors
    Understanding VBA's Error Trapping Options
    Using the Immediate Window to Call Procedures
    Using the CacheSize Property - Optional
    Handling Errors
    Considering Variable Scope and Lifetime Together
    Writing an Error-Handling Routine
    Using the For...Next Structure
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...



Email us about this courses



Other Shropshire Enable Technology Training Courses

Report Builder Shropshire Training Courses
Oracle SQL - Shropshire SQL Training Courses
JQuery - Shropshire JavaScript Training Courses
DAX Shropshire Training Courses
Data Warehouse Shropshire Training Courses
Excel 365 Intermediate Shropshire Training Courses