Enable Technology

ACCESS RISCA TRAINING COURSES 

ACCESS TRAINING COURSES RISCA




About Enable Technology Risca Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All course participants are issued Access training manuals they can refer to after the course. 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.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite socially distanced training location in Risca. 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.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are GKN PLC, Dollond & Aitchison Limited, Carillion PLC, Birmingham City Council, Birmingham City University, Countrywide Homes Limited, Keele University and Barclays Bank PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Risca
  • 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 ...
  • Using Visual Basic Help
    Handling Errors
    Understanding Error Handling
    Using the Do...Loop Structure
    Stepping through Code
    Understanding the DoCmd Object
    Using the Immediate Window to Call Procedures
    Working with the Code Editor
    Determining the Value of Expressions
    Trapping Errors with the On Error Statement
    Calling Procedures
    Understanding the Form Object
    Understanding Collections
    Understanding Modules
    Setting Break Expressions
    Guidelines for use of Branching Structures
    Using the For...Next Structure
    Using the CacheSize Property - Optional
    Naming Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Risca
  • 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 ...
  • An Introduction to VBA
    Importing and Exporting Records
    Action Queries
    Multi Table Queries
    Working With Records
    Setting Table Relationships
    Navigation Pane Protection
    Creating and Using Macros
    Adding Records to a Table
    Data Validation
    Creating and Using Reports
    Sorting and Filtering
    Aggregation Queries
    Macro Techniques
    Understanding VBA
    Calculations in Queries
    Database Security
    Creating Queries
    Creating a Lookup Database
    Relational Database Design
    Macros on Forms

  • See Training Course Details...



Email us about this courses



Other Risca Enable Technology Training Courses

Power BI Risca Training Courses
Data Warehouse - Risca SQL Training Courses
Excel 365 Intermediate Risca Training Courses
Excel 365 Advanced Risca Training Courses
SSAS - Risca SQL Server Analysis Services Training Courses
TSQL Risca Training Courses