Enable Technology

ACCESS DYFED TRAINING COURSES 

ACCESS TRAINING COURSES DYFED




About Enable Technology Dyfed Access Training Courses

We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local socially distanced venue in Dyfed. The Access syllabus can be modified to accommodate your specific training needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: National Power PLC, Keele University, Royal & Sun Alliance Group PLC, Norwich Union PLC, University of Birmingham, Dollond & Aitchison Limited, GKN PLC and Total Telecommunications Limited.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dyfed
  • 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 ...
  • Creating a Function Procedure
    Working with the Code Editor
    Considering Variable Scope and Lifetime Together
    Working with Properties
    Using Debugging Tools
    Working with the Application Object
    Using Input Boxes
    Specifying a Recordset Cursor Type
    Guidelines for use of Branching Structures
    Understanding Objects
    Naming Procedures
    Understanding VBA's Error Trapping Options
    Using Visual Basic Help
    Understanding the Err Object
    Understanding Error Handling
    Understanding Collections
    Understanding Procedures
    Understanding Control-of-Flow Structures
    Using Intrinsic Functions
    Specifying a Recordset Cursor Location - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Dyfed
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Creating a Relational Database
    Modifying Table Structures
    Formatting Tables
    Creating Queries
    Getting to Know Access 
    Understanding VBA
    Data Validation
    Creating and Using Macros
    Modifying Forms
    Navigation Pane Protection
    Multi Table Queries
    Database Security
    Querying Techniques
    Aggregation Queries
    Setting Table Relationships
    Relational Database Design
    Adding Transactional Records
    Calculations in Queries
    Adding Records to a Table
    Creating and Using Reports
    Importing and Exporting Records

  • See Training Course Details...



Email us about this courses



Other Dyfed Enable Technology Training Courses

Data Warehouse Dyfed Training Courses
JavaScript - Dyfed JavaScript Training Courses
JQuery Dyfed Training Courses
Oracle SQL - Dyfed SQL Training Courses
DAX - Dyfed Excel Training Courses
SSAS Tabular Dyfed Training Courses