Enable Technology

ACCESS ASHTON-UNDER-LYNE TRAINING COURSES 

ACCESS TRAINING COURSES ASHTON-UNDER-LYNE




About Enable Technology Ashton-under-lyne Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and Access course resources that can be referenced post 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.

Courses are instructor led and groups sizes small. 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. Another way we could deliver the Access course is at a local socially distanced training site. We are more than happy to incorporate additional topics to accommodate your organisations Access training 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 operated primarily in the West Midlands for twenty years. Some of our clients are Lloyds TSB Bank PLC, Total Telecommunications Limited, Norfolk Police Constabulary, Halfords Group PLC, Birmingham City University, West Bromwich Building Society, Royal Air Force and National Power PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ashton-under-lyne
  • Telephone on 01952 305730
  • 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 Select Case...End Select Structure
    Understanding the Order of Events
    Working with Variable Scope
    Stepping through Code
    Specifying a Recordset Cursor Location - Optional
    Handling Errors
    Using Intrinsic Constants
    Calling Procedures
    Understanding Recordset Cursor Properties - Optional
    Using Input Boxes
    Understanding Constants
    Creating a Function Procedure
    Controlling Program Execution
    Understanding the Form Object
    Using Expressions, Variables, and Intrinsic Functions
    Working with Events
    Working with the ADODB Recordset Object
    Working with Methods
    Creating a Sub Procedure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Ashton-under-lyne
  • Telephone on 01952 305730
  • 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 ...
  • Adding Transactional Records
    DIY Forms
    Action Queries
    Creating a Lookup Database
    Modifying Table Structures
    Navigation Pane Protection
    Querying Techniques
    Creating and Using Macros
    Creating and Using Reports
    Getting to Know Access 
    Designing a Lookup Database
    Data Validation
    Modifying Forms
    Sorting and Filtering
    An Introduction to VBA
    Database Wellness
    Using a Navigation Form
    Aggregation Queries
    Importing and Exporting Records
    Formatting Tables
    Relational Database Design

  • See Training Course Details...



Email us about this courses



Other Ashton-under-lyne Enable Technology Training Courses

SSRS 2016 Ashton-under-lyne Training Courses
SSRS 2005 Ashton-under-lyne Training Courses
Power BI Ashton-under-lyne Training Courses
Excel Power Pivot - Ashton-under-lyne Excel Training Courses
Excel Advanced - Ashton-under-lyne Excel Training Courses
Excel Intermediate - Ashton-under-lyne Excel Training Courses