Enable Technology

ACCESS ABERTILLERY TRAINING COURSES 

ACCESS TRAINING COURSES ABERTILLERY




About Enable Technology Abertillery Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the 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.

Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

We have operated primarily in the West Midlands for twenty years. Our clients include: Aston University, Birmingham City University, Unipart Group, DHL Express, Total Telecommunications Limited, Keele University, Nationwide Building Society Limited and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: Abertillery
  • 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 ...
  • Multi Table Queries
    Macros on Forms
    Designing a Lookup Database
    Relational Database Design
    Navigation Pane Protection
    Database Security
    Creating Queries
    Modifying Forms
    Understanding VBA
    Calculations in Queries
    Modifying Table Structures
    Data Validation
    Creating and Using Forms
    Creating and Using Macros
    Getting to Know Access 
    Setting Table Relationships
    Importing and Exporting Records
    Creating a Relational Database
    Adding Records to a Table
    Working With Records
    Sorting and Filtering

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Abertillery
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Calling Procedures
    Understanding the Err Object
    Understanding VBA's Error Trapping Options
    Setting Break Expressions
    Using the If...End If Decision Structures
    Using Visual Basic Help
    Guidelines for use of Branching Structures
    Working with the Application Object
    Understanding the Development Environment
    Using the Immediate Window to Call Procedures
    Understanding Recordset Cursor Properties - Optional
    Introduction to Programming in Access
    Working with Recordsets
    Specifying a Recordset Cursor Location - Optional
    Declaring and Creating Object Variables
    Naming Procedures
    Understanding Collections
    Specifying a Recordset Cursor Type

  • See Training Course Details...



Email us about this courses



Other Abertillery Enable Technology Training Courses

PL/SQL - Abertillery SQL Training Courses
JavaScript - Abertillery JavaScript Training Courses
Power BI Abertillery Training Courses
Excel 365 Advanced - Abertillery Excel Training Courses
Excel 365 Intermediate - Abertillery Excel Training Courses
SQL - Abertillery SQL Training Courses