Enable Technology

ACCESS TAUNTON TRAINING COURSES 

ACCESS TRAINING COURSES TAUNTON




About Enable Technology Taunton Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. We will issue each Access training participant with learning resources which they can refer to post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a socially distanced training location in Taunton. Every Access course can be modified to meet your bespoke requirements.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham City University, Royal Air Force, Yell Group PLC, Nuclear Engineering Services, National Power PLC, Dollond & Aitchison Limited, West Bromwich Building Society and GKN PLC.




Microsoft Access

  • 2 day course
  • Location: Taunton
  • 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 ...
  • Macro Techniques
    Navigation Pane Protection
    Relational Database Design
    Importing and Exporting Records
    Multi Table Queries
    Adding Transactional Records
    Creating Queries
    An Introduction to VBA
    Data Validation
    Sorting and Filtering
    Action Queries
    Database Wellness
    Creating a Lookup Database
    Parameter Queries
    Using a Navigation Form
    Adding Records to a Table
    Formatting Tables
    Working With Records
    Creating and Using Reports
    Querying Techniques
    Creating and Using Macros

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Taunton
  • 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 ...
  • Handling Errors
    Debugging Code
    Using the For Each...Next Structure
    Working with Inline Error Handling
    Understanding Recordset Cursor Properties - Optional
    Using the CacheSize Property - Optional
    Setting Break Expressions
    Using the With Statement
    Using Intrinsic Functions
    Working with Methods
    Working with Variable Scope
    Guidelines for use of Branching Structures
    Using Message Boxes
    Why Program in Access?
    Working with Variable Lifetime
    Controlling Program Execution
    Organizing Code and Procedures
    Understanding Collections
    Understanding Modules

  • See Training Course Details...



Email us about this courses



Other Taunton Enable Technology Training Courses

SSIS - Taunton SQL Server Integration Services Training Courses
Excel 365 Advanced - Taunton Excel Training Courses
PL/SQL - Taunton SQL Training Courses
Excel 365 Intermediate Taunton Training Courses
SSAS Taunton Training Courses
TSQL Taunton Training Courses