Enable Technology

ACCESS ROWLEY TRAINING COURSES 

ACCESS TRAINING COURSES ROWLEY




About Enable Technology Rowley Access Training Courses

Enable Technology specialise in succinct skills based Access training. 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.

Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a socially distanced local training venue in Rowley. Every Access course can be modified to meet your bespoke 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

We have operated primarily in the West Midlands for twenty years. Our clients include: TalkTalk Direct Limited, Keele University, Unipart Group, Cadbury PLC, Barclays Bank PLC, University of Birmingham, Total Telecommunications Limited and South Staffordshire Water PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Rowley
  • 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 ...
  • Using the Do...Loop Structure
    Understanding Constants
    Declaring and Creating Object Variables
    Working with the ADODB Recordset Object
    Using the Object Browser
    Understanding the Order of Events
    Understanding Control-of-Flow Structures
    Debugging Code
    Stepping through Code
    Understanding Modules
    Using the CacheSize Property - Optional
    Understanding Data Types
    Using the With Statement
    Navigating the Access Object Hierarchy
    Using the Select Case...End Select Structure
    Using the If...End If Decision Structures
    Considering Variable Scope and Lifetime Together
    Setting Break Expressions
    Declaring Variables
    Working with Inline Error Handling

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Rowley
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Importing and Exporting Records
    An Introduction to VBA
    Adding Transactional Records
    Creating and Using Macros
    Setting Table Relationships
    Database Security
    Data Validation
    Creating and Using Reports
    Macro Techniques
    Macros on Forms
    Calculations in Queries
    Multi Table Queries
    Sorting and Filtering
    Database Wellness
    Working With Records
    Creating and Using Forms
    Querying Techniques
    Creating a Relational Database
    Action Queries
    Modifying Table Structures
    Aggregation Queries

  • See Training Course Details...



Email us about this courses



Other Rowley Enable Technology Training Courses

DAX - Rowley Excel Training Courses
VBA Rowley Training Courses
PL/SQL Rowley Training Courses
SSRS Rowley Training Courses
Power BI - Rowley Microsoft Power BI Training Courses
Excel 365 Intermediate Rowley Training Courses