Enable Technology

ACCESS WILTSHIRE TRAINING COURSES 

ACCESS TRAINING COURSES WILTSHIRE




About Enable Technology Wiltshire Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Wiltshire. The Access syllabus can be adjusted and additional topics incorporated if helpful.

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

We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are TalkTalk Direct Limited, Barclays Bank PLC, Aston University, Nuclear Engineering Services, GKN PLC, South Staffordshire Water PLC, Boots UK Limited and Loughborough University.




Microsoft Access

  • 2 day course
  • Location: Wiltshire
  • 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 ...
  • Database Wellness
    Sorting and Filtering
    Calculations in Queries
    Parameter Queries
    Modifying Table Structures
    Creating a Lookup Database
    Macro Techniques
    Understanding VBA
    Formatting Tables
    Setting Table Relationships
    Working With Records
    Multi Table Queries
    Macros on Forms
    Importing and Exporting Records
    Querying Techniques
    Getting to Know Access 
    Navigation Pane Protection
    Creating and Using Forms
    Adding Transactional Records
    Creating and Using Macros
    Action Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Wiltshire
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Using Intrinsic Constants
    Understanding VBA's Error Trapping Options
    Understanding the Development Environment
    Stepping through Code
    Calling Procedures
    Working with Inline Error Handling
    Working with Events
    Organizing Code and Procedures
    Working with the Code Editor
    Naming Procedures
    Working with Methods
    Working with Boolean Expressions
    Using Input Boxes
    Using the Immediate Window to Call Procedures
    Working with the Application Object
    Using the Do...Loop Structure
    Trapping Errors with the On Error Statement
    Debugging Code
    Understanding the DoCmd Object

  • See Training Course Details...



Email us about this courses



Other Wiltshire Enable Technology Training Courses

JQuery Mobile Wiltshire Training Courses
Excel Power Pivot - Wiltshire Excel Training Courses
Power BI - Wiltshire Microsoft Power BI Training Courses
VBA - Wiltshire Excel Training Courses
SSAS Wiltshire Training Courses
JQuery Wiltshire Training Courses