Enable Technology

ACCESS CAERPHILLY TRAINING COURSES 

ACCESS TRAINING COURSES CAERPHILLY




About Enable Technology Caerphilly Access Training Courses

We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away Access courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Enable Technology offers instructor led training taught by technology specialists. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Unipart Group, Halfords Group PLC, National Power PLC, Queen's Medical Centre Nottingham, Homeserve PLC, Fujistu PLC, Aston University and TalkTalk Direct Limited.




Microsoft Access

  • 2 day course
  • Location: Caerphilly
  • 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 ...
  • An Introduction to VBA
    Multi Table Queries
    Navigation Pane Protection
    Sorting and Filtering
    Importing and Exporting Records
    Modifying Table Structures
    Adding Records to a Table
    Action Queries
    Macro Techniques
    Using a Navigation Form
    Creating and Using Forms
    DIY Forms
    Querying Techniques
    Working With Records
    Parameter Queries
    Creating Queries
    Creating a Relational Database
    Creating and Using Macros
    Designing a Lookup Database
    Calculations in Queries
    Relational Database Design

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Caerphilly
  • 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 ...
  • Determining the Value of Expressions
    Understanding the Err Object
    Working with Events
    Declaring and Creating Object Variables
    Working with Methods
    Using the For Each...Next Structure
    Understanding the Development Environment
    Creating a Function Procedure
    Understanding Recordset Cursor Properties - Optional
    Calling Procedures
    Using the Do...Loop Structure
    Specifying a Recordset Cursor Location - Optional
    Understanding Error Handling
    Writing an Error-Handling Routine
    Using Intrinsic Constants
    Understanding Collections
    Understanding Expressions and Statements
    Working with the ADODB Recordset Object
    Understanding Classes and Objects

  • See Training Course Details...



Email us about this courses



Other Caerphilly Enable Technology Training Courses

VBA Caerphilly Training Courses
Power BI Caerphilly Training Courses
Excel 365 Advanced - Caerphilly Excel Training Courses
JQuery Caerphilly Training Courses
Excel 365 Basic - Caerphilly Excel Training Courses
PL/SQL - Caerphilly SQL Training Courses