Enable Technology

ACCESS LEEK TRAINING COURSES 

ACCESS TRAINING COURSES LEEK




About Enable Technology Leek Access Training Courses

Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.

Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a socially distanced training location in Leek. Every Access course can be modified to meet your bespoke requirements.

This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Norwich Union PLC, Dollond & Aitchison Limited, EDF Energy PLC, Loughborough University, Carillion PLC, West Bromwich Building Society and Total Telecommunications Limited.




Microsoft Access

  • 2 day course
  • Location: Leek
  • Telephone on 01952 938014
  • Course Outline
  • A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.

  • Some of the training topics covered include ...
  • Data Validation
    Database Security
    Getting to Know Access 
    Multi Table Queries
    Creating and Using Forms
    Relational Database Design
    Working With Records
    Calculations in Queries
    Creating Queries
    Creating a Lookup Database
    Sorting and Filtering
    An Introduction to VBA
    Action Queries
    Parameter Queries
    Aggregation Queries
    Navigation Pane Protection
    Querying Techniques
    Setting Table Relationships
    Modifying Forms
    Importing and Exporting Records
    Creating a Relational Database

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Leek
  • 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 ...
  • Naming Procedures
    Using the CacheSize Property - Optional
    Specifying a Recordset Cursor Type
    Writing an Error-Handling Routine
    Working with Methods
    Working with the Code Editor
    Using Intrinsic Constants
    Using the If...End If Decision Structures
    Navigating the Access Object Hierarchy
    Working with the ADODB Recordset Object
    Why Program in Access?
    Understanding Errors
    Introduction to Programming in Access
    Working with Recordsets
    Handling Errors
    Working with Variable Lifetime
    Using Visual Basic Help
    Understanding Constants

  • See Training Course Details...



Email us about this courses



Other Leek Enable Technology Training Courses

JQuery Mobile - Leek JavaScript Training Courses
SSAS Tabular - Leek SQL Server Analysis Services Training Courses
SQL - Leek SQL Training Courses
Report Builder - Leek SQL Server Reporting Services Training Courses
Oracle SQL Leek Training Courses
DAX Leek Training Courses