Enable Technology



About Enable Technology Risca Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source 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.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. The Access course could also be scheduled at a socially distanced site near you in Risca. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.

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 team have been providing IT training primarily in the Midlands for two decades. Our clients include: Dollond & Aitchison Limited, South Staffordshire Water PLC, Nuclear Engineering Services, Vodafone Group Services, Halfords Group PLC, Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham and Carillion PLC.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Risca
  • 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 ...
  • Specifying a Recordset Cursor Location - Optional
    Why Program in Access?
    Working with Boolean Expressions
    Locking Records for Updating
    Understanding the DoCmd Object
    Understanding Classes and Objects
    Working with Variable Scope
    Understanding Errors
    Using the For Each...Next Structure
    Using Message Boxes
    Understanding the Form Object
    Using the With Statement
    Understanding Error Handling
    Working with Variable Lifetime
    Using Intrinsic Functions
    Naming Procedures
    Understanding Control-of-Flow Structures
    Understanding Modules
    Declaring Variables

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Risca
  • 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 ...
  • Creating a Lookup Database
    Creating and Using Reports
    Aggregation Queries
    Creating and Using Forms
    Action Queries
    Adding Records to a Table
    Adding Transactional Records
    Sorting and Filtering
    Modifying Forms
    Creating and Using Macros
    Understanding VBA
    An Introduction to VBA
    Parameter Queries
    Creating a Relational Database
    Navigation Pane Protection
    Importing and Exporting Records
    Modifying Table Structures
    Multi Table Queries
    Creating Queries
    Querying Techniques
    Using a Navigation Form

  • See Training Course Details...

Email us about this courses

Other Risca Enable Technology Training Courses

Excel Power Pivot Risca Training Courses
SSAS Risca Training Courses
SSRS Risca Training Courses
Power BI - Risca Microsoft Power BI Training Courses
SSIS - Risca SQL Server Integration Services Training Courses
TSQL Risca Training Courses