Enable Technology



About Enable Technology Atherstone Access Training Courses

Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. Each course participant will be issued with training Access resources which they can continue to use after the training. 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Atherstone. The Access syllabus can be adjusted and additional topics incorporated if helpful.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Unipart Group, Carillion PLC, Royal & Sun Alliance Group PLC, Queen's Medical Centre Nottingham, Norwich Union PLC, Nationwide Building Society Limited, Nuclear Engineering Services and West Bromwich Building Society.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Atherstone
  • Telephone on 01952 938014
  • 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 ...
  • Why Program in Access?
    Declaring and Creating Object Variables
    Understanding Errors
    Understanding Control-of-Flow Structures
    Declaring Variables
    Understanding Objects
    Understanding the Development Environment
    Working with the Code Editor
    Using Break Mode during Run Mode
    Using the For...Next Structure
    Using Intrinsic Functions
    Working with Properties
    Working with Variable Scope
    Controlling Program Execution
    Specifying a Recordset Cursor Type
    Understanding Recordset Cursor Properties - Optional
    Using Expressions, Variables, and Intrinsic Functions
    Using Debugging Tools
    Using Message Boxes
    Handling Errors
    Using the Immediate Window to Call Procedures

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Atherstone
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Calculations in Queries
    Database Security
    Creating Queries
    Getting to Know Access 
    Creating a Relational Database
    Creating and Using Forms
    Parameter Queries
    Working With Records
    Querying Techniques
    An Introduction to VBA
    Adding Transactional Records
    Macros on Forms
    Importing and Exporting Records
    Multi Table Queries
    Modifying Table Structures
    Action Queries
    Data Validation
    DIY Forms
    Sorting and Filtering
    Creating a Lookup Database
    Database Wellness

  • See Training Course Details...

Email us about this courses

Other Atherstone Enable Technology Training Courses

Power Query - Atherstone Excel Training Courses
Excel Power Pivot - Atherstone Excel Training Courses
Excel 365 Advanced Atherstone Training Courses
TSQL - Atherstone SQL Training Courses
SQL - Atherstone SQL Training Courses
JQuery - Atherstone JavaScript Training Courses