Enable Technology

ACCESS GWENT TRAINING COURSES 

ACCESS TRAINING COURSES GWENT




About Enable Technology Gwent Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based 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 all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Gwent. All Access courses can be customised to meet your particular requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Dollond & Aitchison Limited, Homeserve PLC, Fujistu PLC, Loughborough University, National Power PLC, Yell Group PLC, Royal & Sun Alliance Group PLC and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: Gwent
  • Telephone on 01952 938014
  • Course Outline
  • In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.

  • Some of the training topics covered include ...
  • Aggregation Queries
    Working With Records
    Macros on Forms
    Creating a Relational Database
    Parameter Queries
    Action Queries
    Multi Table Queries
    Formatting Tables
    Importing and Exporting Records
    Creating and Using Forms
    DIY Forms
    Understanding VBA
    Adding Records to a Table
    Querying Techniques
    Calculations in Queries
    Navigation Pane Protection
    Sorting and Filtering
    Database Wellness
    An Introduction to VBA
    Setting Table Relationships
    Creating and Using Reports

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Gwent
  • 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 ...
  • Using the For Each...Next Structure
    Setting Break Expressions
    Determining the Value of Expressions
    Using Message Boxes
    Understanding Collections
    Creating a Function Procedure
    Understanding Data Types
    Locking Records for Updating
    Using the With Statement
    Using the Do...Loop Structure
    Declaring and Creating Object Variables
    Working with Procedures and Functions
    Understanding the Form Object
    Using Input Boxes
    Debugging Code
    Working with Variable Scope
    Understanding Expressions and Statements
    Writing an Error-Handling Routine
    Specifying a Recordset Cursor Location - Optional

  • See Training Course Details...



Email us about this courses



Other Gwent Enable Technology Training Courses

Power BI - Gwent Microsoft Power BI Training Courses
Excel 365 Advanced - Gwent Excel Training Courses
SSIS Gwent Training Courses
Report Builder - Gwent SQL Server Reporting Services Training Courses
Excel Power Pivot - Gwent Excel Training Courses
PL/SQL - Gwent SQL Training Courses