Enable Technology

ACCESS DEWSBURY TRAINING COURSES 

ACCESS TRAINING COURSES DEWSBURY




About Enable Technology Dewsbury 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). We will issue each Access training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.

Courses are instructor led and groups sizes small. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Dewsbury. 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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Barclays Bank PLC, Loughborough University, Aston University, Fujistu PLC, Boots UK Limited, South Staffordshire Water PLC, Keele University and Canadian High Commission.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dewsbury
  • 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 ...
  • Understanding the Form Object
    Using Intrinsic Functions
    Working with Inline Error Handling
    Specifying a Recordset Cursor Type
    Naming Procedures
    Working with the Application Object
    Declaring and Creating Object Variables
    Understanding the Development Environment
    Understanding the Order of Events
    Writing an Error-Handling Routine
    Specifying a Recordset Cursor Location - Optional
    Using the Do...Loop Structure
    Working with the Code Editor
    Locking Records for Updating
    Working with Variable Lifetime
    Understanding Data Types
    Setting Breakpoints

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Dewsbury
  • 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 ...
  • Working With Records
    DIY Forms
    Setting Table Relationships
    Creating and Using Reports
    Macro Techniques
    Understanding VBA
    Database Wellness
    Sorting and Filtering
    Formatting Tables
    Action Queries
    Getting to Know Access 
    Calculations in Queries
    Creating a Lookup Database
    Data Validation
    Adding Records to a Table
    Creating and Using Macros
    Parameter Queries
    Importing and Exporting Records
    Relational Database Design
    Querying Techniques
    Multi Table Queries

  • See Training Course Details...



Email us about this courses



Other Dewsbury Enable Technology Training Courses

SQL Dewsbury Training Courses
Excel 365 Intermediate - Dewsbury Excel Training Courses
Excel Power Pivot Dewsbury Training Courses
JQuery Dewsbury Training Courses
DAX - Dewsbury Excel Training Courses
Excel 365 Advanced Dewsbury Training Courses