Enable Technology

ACCESS ASHTON-UNDER-LYNE TRAINING COURSES 

ACCESS TRAINING COURSES ASHTON-UNDER-LYNE




About Enable Technology Ashton-under-lyne Access Training Courses

We have a twenty year history of providing skills based Access industry training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a Access course at an alternative training site in Ashton-under-lyne. We are happy to discuss customising the course content should you have particular Access training requirements.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Shell UK Oil Products Ltd, Lloyds TSB Bank PLC, Carillion PLC, Barclays Bank PLC, Total Telecommunications Limited, University of Birmingham, Royal & Sun Alliance Group PLC and GKN PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Ashton-under-lyne
  • 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 ...
  • Using Break Mode during Run Mode
    Working with Events
    Navigating the Access Object Hierarchy
    Understanding the DoCmd Object
    Creating a Standard Module
    Understanding Collections
    Understanding Objects
    Understanding Error Handling
    Declaring and Creating Object Variables
    Understanding the Order of Events
    Understanding the Form Object
    Guidelines for use of Branching Structures
    Why Program in Access?
    Using Visual Basic Help
    Trapping Errors with the On Error Statement
    Using the For...Next Structure
    Working with the ADODB Recordset Object
    Using the Select Case...End Select Structure

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Ashton-under-lyne
  • 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 ...
  • Setting Table Relationships
    Creating a Lookup Database
    Creating and Using Forms
    Designing a Lookup Database
    Parameter Queries
    Data Validation
    Querying Techniques
    Creating and Using Macros
    Relational Database Design
    Multi Table Queries
    Sorting and Filtering
    Creating and Using Reports
    An Introduction to VBA
    Creating Queries
    Macro Techniques
    Formatting Tables
    Using a Navigation Form
    DIY Forms
    Importing and Exporting Records
    Working With Records
    Calculations in Queries

  • See Training Course Details...



Email us about this courses



Other Ashton-under-lyne Enable Technology Training Courses

JavaScript Ashton-under-lyne Training Courses
JQuery Mobile Ashton-under-lyne Training Courses
Oracle SQL Ashton-under-lyne Training Courses
TSQL - Ashton-under-lyne SQL Training Courses
Data Warehouse - Ashton-under-lyne SQL Training Courses
JQuery Ashton-under-lyne Training Courses