Enable Technology



About Enable Technology Rhosllanerchrugog Access Training Courses

Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Rhosllanerchrugog. We will work with you prior to the course to tailor the Access syllabus to match your requirements.

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 been delivering technical training in the Midlands for twenty years. Our clients include: Royal & Sun Alliance Group PLC, Homeserve PLC, Capita Group PLC, Norwich Union PLC, DHL Express, Royal Air Force, Canadian High Commission and Norfolk Police Constabulary.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rhosllanerchrugog
  • 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 ...
  • Understanding VBA's Error Trapping Options
    Using the Immediate Window to Call Procedures
    Understanding Classes and Objects
    Understanding Objects
    Working with Recordsets
    Setting Breakpoints
    Using the Object Browser
    Working with Boolean Expressions
    Writing an Error-Handling Routine
    Determining the Value of Expressions
    Using Intrinsic Constants
    Introduction to Programming in Access
    Declaring and Creating Object Variables
    Navigating the Access Object Hierarchy
    Using Message Boxes
    Working with Methods
    Understanding the DoCmd Object
    Debugging Code
    Using Intrinsic Functions
    Creating a Function Procedure
    Using the Do...Loop Structure

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Rhosllanerchrugog
  • 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 ...
  • Database Security
    Macro Techniques
    Modifying Table Structures
    Adding Records to a Table
    Modifying Forms
    Adding Transactional Records
    Sorting and Filtering
    Formatting Tables
    Multi Table Queries
    Creating a Lookup Database
    Calculations in Queries
    Macros on Forms
    Relational Database Design
    Aggregation Queries
    Creating Queries
    Creating a Relational Database
    Creating and Using Reports
    Understanding VBA
    Designing a Lookup Database
    Importing and Exporting Records
    An Introduction to VBA

  • See Training Course Details...

Email us about this courses

Other Rhosllanerchrugog Enable Technology Training Courses

Excel 365 Basic - Rhosllanerchrugog Excel Training Courses
SSAS Tabular - Rhosllanerchrugog SQL Server Analysis Services Training Courses
Excel 365 Advanced Rhosllanerchrugog Training Courses
Report Builder - Rhosllanerchrugog SQL Server Reporting Services Training Courses
Excel 365 Intermediate Rhosllanerchrugog Training Courses
TSQL Rhosllanerchrugog Training Courses