Enable Technology

ACCESS TREDEGAR TRAINING COURSES 

ACCESS TRAINING COURSES TREDEGAR




About Enable Technology Tredegar Access Training Courses

We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued Access training manuals they can refer to after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. If delivery onsite is an issue we will organise a socially distanced venue near you in Tredegar. 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.

Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City University, Nuclear Engineering Services, Lloyds TSB Bank PLC, Loughborough University, South Staffordshire Water PLC, Total Telecommunications Limited, West Bromwich Building Society and GKN PLC.




Microsoft Access

  • 2 day course
  • Location: Tredegar
  • Telephone on 01952 938014
  • Course Outline
  • This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.

  • Some of the training topics covered include ...
  • Aggregation Queries
    Understanding VBA
    Sorting and Filtering
    Creating a Relational Database
    Adding Records to a Table
    Creating Queries
    Querying Techniques
    Creating a Lookup Database
    Calculations in Queries
    Importing and Exporting Records
    Modifying Table Structures
    Adding Transactional Records
    Creating and Using Reports
    Multi Table Queries
    Creating and Using Macros
    Parameter Queries
    Designing a Lookup Database
    Macros on Forms
    Data Validation
    An Introduction to VBA
    Macro Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Tredegar
  • 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 ...
  • Understanding Errors
    Considering Variable Scope and Lifetime Together
    Using the Object Browser
    Using the CacheSize Property - Optional
    Using Break Mode during Run Mode
    Working with Variable Lifetime
    Understanding Constants
    Using the For Each...Next Structure
    Creating a Function Procedure
    Using Input Boxes
    Understanding VBA's Error Trapping Options
    Working with Recordsets
    Working with the Code Editor
    Creating a Sub Procedure
    Understanding Collections
    Understanding Modules
    Working with Boolean Expressions
    Understanding Expressions and Statements
    Using Visual Basic Help
    Handling Errors

  • See Training Course Details...



Email us about this courses



Other Tredegar Enable Technology Training Courses

SSIS Tredegar Training Courses
PL/SQL Tredegar Training Courses
Power BI Tredegar Training Courses
JQuery Mobile - Tredegar JavaScript Training Courses
DAX Tredegar Training Courses
TSQL Tredegar Training Courses