Enable Technology

ACCESS DORSET TRAINING COURSES 

ACCESS TRAINING COURSES DORSET




About Enable Technology Dorset Access Training Courses

We are a company that provides short intensive Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Dorset. We will work with you prior to the course to tailor the Access syllabus to match your 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 team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Homeserve PLC, Loughborough University, Birmingham City Council, Fujistu PLC, University of Birmingham, GKN PLC, Barclays Bank PLC and West Bromwich Building Society.




Microsoft Access

  • 2 day course
  • Location: Dorset
  • 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 ...
  • Parameter Queries
    Formatting Tables
    Action Queries
    Getting to Know Access 
    Database Security
    Setting Table Relationships
    Modifying Forms
    Creating Queries
    Creating and Using Macros
    Aggregation Queries
    Sorting and Filtering
    Relational Database Design
    Creating a Lookup Database
    Using a Navigation Form
    Navigation Pane Protection
    Querying Techniques
    Adding Transactional Records
    Importing and Exporting Records
    DIY Forms
    Multi Table Queries
    An Introduction to VBA

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Dorset
  • Telephone on 01952 938014
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Creating a Function Procedure
    Using the Object Browser
    Using the For Each...Next Structure
    Why Program in Access?
    Using Debugging Tools
    Working with the Application Object
    Understanding the DoCmd Object
    Introduction to Programming in Access
    Understanding Collections
    Working with the Code Editor
    Using the For...Next Structure
    Using Message Boxes
    Using the If...End If Decision Structures
    Working with Boolean Expressions
    Working with Properties
    Working with Methods
    Understanding Data Types
    Understanding Error Handling
    Using Input Boxes

  • See Training Course Details...



Email us about this courses



Other Dorset Enable Technology Training Courses

JQuery Dorset Training Courses
JavaScript Dorset Training Courses
SQL - Dorset SQL Training Courses
Excel 365 Basic - Dorset Excel Training Courses
SSAS - Dorset SQL Server Analysis Services Training Courses
PL/SQL Dorset Training Courses