Enable Technology

ACCESS ACCRINGTON TRAINING COURSES 

ACCESS TRAINING COURSES ACCRINGTON




About Enable Technology Accrington Access Training Courses

We have a twenty year history of providing skills based Access industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.

Enable Technology training courses are delivered as instructor led courses. 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 Access course at an alternative training site in Accrington. Every Access course can be modified to meet your bespoke requirements.

We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: TalkTalk Direct Limited, Carillion PLC, University of Birmingham, Royal & Sun Alliance Group PLC, Royal Air Force, Dollond & Aitchison Limited, Vodafone Group Services and Barclays Bank PLC.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Accrington
  • 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 ...
  • Understanding Control-of-Flow Structures
    Working with Events
    Using Input Boxes
    Creating a Standard Module
    Stepping through Code
    Debugging Code
    Why Program in Access?
    Understanding Data Types
    Working with Inline Error Handling
    Determining the Value of Expressions
    Using Expressions, Variables, and Intrinsic Functions
    Calling Procedures
    Understanding Collections
    Using Break Mode during Run Mode
    Using Debugging Tools
    Creating a Function Procedure
    Using the Immediate Window to Call Procedures
    Declaring Variables
    Understanding the Order of Events

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Accrington
  • 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 ...
  • Database Security
    Creating and Using Forms
    Creating Queries
    Formatting Tables
    Understanding VBA
    Modifying Forms
    Creating a Relational Database
    Creating and Using Reports
    Working With Records
    Action Queries
    Aggregation Queries
    Macro Techniques
    Creating and Using Macros
    Data Validation
    Adding Transactional Records
    Parameter Queries
    DIY Forms
    Modifying Table Structures
    Relational Database Design
    Adding Records to a Table
    Setting Table Relationships

  • See Training Course Details...



Email us about this courses



Other Accrington Enable Technology Training Courses

SQL Accrington Training Courses
SSAS Accrington Training Courses
JavaScript Accrington Training Courses
Excel Power Pivot Accrington Training Courses
Power Query Accrington Training Courses
SSRS Accrington Training Courses