Enable Technology

ACCESS LLANTRISANT TRAINING COURSES 

ACCESS TRAINING COURSES LLANTRISANT




About Enable Technology Llantrisant Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If you prefer we can offer an offsite socially distanced training location in Llantrisant. 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.

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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Capita Group PLC, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Yell Group PLC, Nuclear Engineering Services, Unipart Group, Birmingham Heartlands Hospital and Canadian High Commission.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Llantrisant
  • 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 Classes and Objects
    Using Intrinsic Functions
    Locking Records for Updating
    Organizing Code and Procedures
    Understanding Expressions and Statements
    Understanding Data Types
    Using the If...End If Decision Structures
    Using the Object Browser
    Using the With Statement
    Working with Methods
    Specifying a Recordset Cursor Type
    Using Message Boxes
    Understanding the Order of Events
    Using Expressions, Variables, and Intrinsic Functions
    Using the Select Case...End Select Structure
    Controlling Program Execution
    Understanding the Err Object
    Using Debugging Tools
    Understanding Recordset Cursor Properties - Optional

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Llantrisant
  • 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
    Adding Transactional Records
    Macro Techniques
    Creating a Relational Database
    Adding Records to a Table
    Querying Techniques
    Importing and Exporting Records
    Calculations in Queries
    Parameter Queries
    Getting to Know Access 
    Creating Queries
    DIY Forms
    Data Validation
    Modifying Forms
    Aggregation Queries
    Working With Records
    Multi Table Queries
    Modifying Table Structures
    Creating and Using Macros
    Sorting and Filtering
    Creating and Using Forms

  • See Training Course Details...



Email us about this courses



Other Llantrisant Enable Technology Training Courses

JQuery - Llantrisant JavaScript Training Courses
Excel Power Pivot - Llantrisant Excel Training Courses
SSRS - Llantrisant SQL Server Reporting Services Training Courses
TSQL - Llantrisant SQL Training Courses
SQL Llantrisant Training Courses
Excel 365 Basic - Llantrisant Excel Training Courses