Enable Technology

ACCESS OSWESTRY TRAINING COURSES 

ACCESS TRAINING COURSES OSWESTRY




About Enable Technology Oswestry Access Training Courses

We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. Every course participant is given Access courseware which they can refer to after the training. 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 can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a course at a local venue in Oswestry. The Access syllabus can be adjusted and additional topics incorporated if helpful.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have operated primarily in the West Midlands for twenty years. Our clients include: Vodafone Group Services, Halfords Group PLC, Carillion PLC, Total Telecommunications Limited, EDF Energy PLC, Norfolk Police Constabulary, South Staffordshire Water PLC and Wolverhampton City Council.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Oswestry
  • 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 ...
  • Navigating the Access Object Hierarchy
    Working with Variable Lifetime
    Using the Immediate Window to Call Procedures
    Using the With Statement
    Working with Events
    Handling Errors
    Working with the ADODB Recordset Object
    Working with Variable Scope
    Understanding Expressions and Statements
    Working with Recordsets
    Understanding the Development Environment
    Introduction to Programming in Access
    Using Intrinsic Functions
    Using the For Each...Next Structure
    Working with Procedures and Functions
    Guidelines for use of Branching Structures
    Understanding Classes and Objects
    Working with the Code Editor
    Naming Procedures

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Oswestry
  • 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 ...
  • Relational Database Design
    DIY Forms
    Macros on Forms
    Querying Techniques
    Creating and Using Reports
    Macro Techniques
    Importing and Exporting Records
    Designing a Lookup Database
    Action Queries
    Creating and Using Forms
    Database Wellness
    Getting to Know Access 
    Sorting and Filtering
    Parameter Queries
    Understanding VBA
    Multi Table Queries
    Creating a Relational Database
    Database Security
    Setting Table Relationships
    Modifying Table Structures
    Data Validation

  • See Training Course Details...



Email us about this courses



Other Oswestry Enable Technology Training Courses

SSAS Oswestry Training Courses
Excel 365 Basic - Oswestry Excel Training Courses
Data Warehouse Oswestry Training Courses
JQuery Mobile Oswestry Training Courses
PL/SQL Oswestry Training Courses
SQL - Oswestry SQL Training Courses