Enable Technology

ACCESS DORCHESTER TRAINING COURSES 

ACCESS TRAINING COURSES DORCHESTER




About Enable Technology Dorchester Access Training Courses

We are a company that provides short intensive Access training courses. 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. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.

Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Dorchester. We are happy to discuss customising the course content should you have particular Access training requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have operated primarily in the West Midlands for twenty years. Our clients include: Loughborough University, Homeserve PLC, National Power PLC, Carillion PLC, Wolverhampton City Council, Shell UK Oil Products Ltd, TalkTalk Direct Limited and Keele University.




Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dorchester
  • 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 the DoCmd Object
    Understanding Collections
    Understanding Data Types
    Declaring and Creating Object Variables
    Guidelines for use of Branching Structures
    Controlling Program Execution
    Understanding Recordset Cursor Properties - Optional
    Understanding Expressions and Statements
    Working with Procedures and Functions
    Creating a Sub Procedure
    Understanding the Development Environment
    Using Expressions, Variables, and Intrinsic Functions
    Trapping Errors with the On Error Statement
    Understanding Procedures
    Working with Events
    Understanding Classes and Objects
    Locking Records for Updating
    Declaring Variables
    Writing an Error-Handling Routine
    Creating a Standard Module

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Dorchester
  • 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 ...
  • Using a Navigation Form
    Database Wellness
    Database Security
    Macro Techniques
    Calculations in Queries
    Understanding VBA
    Aggregation Queries
    Adding Records to a Table
    Getting to Know Access 
    Action Queries
    Navigation Pane Protection
    Creating and Using Forms
    Parameter Queries
    Setting Table Relationships
    Creating a Relational Database
    Formatting Tables
    DIY Forms
    Querying Techniques
    Creating Queries
    Working With Records
    Sorting and Filtering

  • See Training Course Details...



Email us about this courses



Other Dorchester Enable Technology Training Courses

PL/SQL Dorchester Training Courses
SSAS - Dorchester SQL Server Analysis Services Training Courses
JavaScript - Dorchester JavaScript Training Courses
Excel Power Pivot - Dorchester Excel Training Courses
Power Query - Dorchester Excel Training Courses
Excel 365 Basic - Dorchester Excel Training Courses