Enable Technology

ACCESS POWYS TRAINING COURSES 

ACCESS TRAINING COURSES POWYS




About Enable Technology Powys Access Training Courses

Enable Technology offer short intensive skills based Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We are set up to deliver Access training courses onsite at your premises. Another way we could deliver the Access course is at a local socially distanced training site. 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. Some of our clients are Norwich Union PLC, Nuclear Engineering Services, National Power PLC, Shell UK Oil Products Ltd, Dollond & Aitchison Limited, Aston University, Yell Group PLC and Fujistu PLC.




Microsoft Access

  • 2 day course
  • Location: Powys
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Using a Navigation Form
    Creating and Using Forms
    Creating and Using Macros
    Creating a Lookup Database
    Designing a Lookup Database
    Calculations in Queries
    Creating Queries
    Macro Techniques
    Creating and Using Reports
    Importing and Exporting Records
    Getting to Know Access 
    Formatting Tables
    An Introduction to VBA
    Relational Database Design
    Modifying Table Structures
    Database Wellness
    Action Queries
    Understanding VBA
    Data Validation
    Sorting and Filtering
    Macros on Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Powys
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Why Program in Access?
    Considering Variable Scope and Lifetime Together
    Understanding the Development Environment
    Using Message Boxes
    Calling Procedures
    Using the Object Browser
    Working with Variable Lifetime
    Working with Procedures and Functions
    Handling Errors
    Debugging Code
    Using Debugging Tools
    Understanding Error Handling
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Constants
    Working with Recordsets
    Controlling Program Execution
    Understanding Collections
    Determining the Value of Expressions
    Using the Immediate Window to Call Procedures

  • See Training Course Details...



Email us about this courses



Other Powys Enable Technology Training Courses

SQL Powys Training Courses
JQuery Mobile Powys Training Courses
SSAS - Powys SQL Server Analysis Services Training Courses
JQuery Powys Training Courses
Report Builder - Powys SQL Server Reporting Services Training Courses
Excel Power Pivot Powys Training Courses