Enable Technology



About Enable Technology Crosby Access Training Courses

We are company which specialises in short, two and three day intensive Access technology training courses. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.

Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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 local training venue in Crosby. The Access syllabus can be modified to accommodate your specific training needs.

We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: GKN PLC, Aston University, Keele University, Shell UK Oil Products Ltd, Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, West Bromwich Building Society and Nationwide Building Society Limited.

Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Crosby
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using the For...Next Structure
    Using Debugging Tools
    Using the If...End If Decision Structures
    Understanding Recordset Cursor Properties - Optional
    Working with the Application Object
    Understanding Procedures
    Using the Immediate Window to Call Procedures
    Why Program in Access?
    Debugging Code
    Understanding Error Handling
    Creating a Sub Procedure
    Using the With Statement
    Declaring Variables
    Introduction to Programming in Access
    Using Break Mode during Run Mode
    Understanding the Form Object
    Working with Methods
    Working with Properties
    Working with the ADODB Recordset Object
    Understanding the DoCmd Object
    Using Message Boxes

  • See Training Course Details...

Microsoft Access

  • 2 day course
  • Location: Crosby
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.

  • Some of the training topics covered include ...
  • Creating and Using Reports
    Creating a Lookup Database
    Calculations in Queries
    Modifying Forms
    Adding Records to a Table
    Getting to Know Access 
    Querying Techniques
    Setting Table Relationships
    Database Wellness
    Macro Techniques
    Creating and Using Forms
    Importing and Exporting Records
    Modifying Table Structures
    DIY Forms
    Designing a Lookup Database
    Aggregation Queries
    An Introduction to VBA
    Multi Table Queries
    Navigation Pane Protection
    Action Queries
    Data Validation

  • See Training Course Details...

Email us about this courses

Other Crosby Enable Technology Training Courses

Excel 365 Advanced Crosby Training Courses
SSAS Tabular - Crosby SQL Server Analysis Services Training Courses
Oracle SQL Crosby Training Courses
SQL - Crosby SQL Training Courses
Excel 365 Intermediate - Crosby Excel Training Courses
TSQL Crosby Training Courses