Enable Technology

ACCESS DEWSBURY TRAINING COURSES 

ACCESS TRAINING COURSES DEWSBURY




About Enable Technology Dewsbury Access Training Courses

Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.

Courses are instructor led and groups sizes small. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a socially distanced venue near you in Dewsbury. We are happy to discuss customising the course content should you have particular Access training requirements.

Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Shell UK Oil Products Ltd, Total Telecommunications Limited, Nuclear Engineering Services, Yell Group PLC, GKN PLC, Nationwide Building Society Limited, Capita Group PLC and Aston University.




Microsoft Access

  • 2 day course
  • Location: Dewsbury
  • 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 Queries
    Modifying Table Structures
    Calculations in Queries
    Macro Techniques
    Using a Navigation Form
    Data Validation
    Parameter Queries
    Creating and Using Macros
    Database Security
    DIY Forms
    Setting Table Relationships
    Action Queries
    Importing and Exporting Records
    Understanding VBA
    Relational Database Design
    Creating and Using Reports
    Querying Techniques
    Multi Table Queries
    Formatting Tables
    Database Wellness
    Navigation Pane Protection

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dewsbury
  • Telephone on 01952 938014
  • 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 ...
  • Understanding Procedures
    Using the With Statement
    Debugging Code
    Specifying a Recordset Cursor Type
    Declaring Variables
    Using the Object Browser
    Understanding Classes and Objects
    Considering Variable Scope and Lifetime Together
    Organizing Code and Procedures
    Determining the Value of Expressions
    Working with Variable Lifetime
    Creating a Standard Module
    Guidelines for use of Branching Structures
    Working with Inline Error Handling
    Using Visual Basic Help
    Understanding Error Handling
    Understanding Errors
    Understanding the DoCmd Object
    Using the Immediate Window to Call Procedures

  • See Training Course Details...



Email us about this courses



Other Dewsbury Enable Technology Training Courses

JavaScript - Dewsbury JavaScript Training Courses
Oracle SQL - Dewsbury SQL Training Courses
DAX - Dewsbury Excel Training Courses
SQL Dewsbury Training Courses
Excel Power Pivot Dewsbury Training Courses
JQuery Mobile Dewsbury Training Courses