Enable Technology

ACCESS YORK TRAINING COURSES 

ACCESS TRAINING COURSES YORK




About Enable Technology York Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.

We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The Access course could also be scheduled at a socially distanced site near you in York. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.

This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Total Telecommunications Limited, Unipart Group, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Nationwide Building Society Limited, University of Birmingham, Countrywide Homes Limited and Wolverhampton City Council.




Microsoft Access

  • 2 day course
  • Location: York
  • Telephone on 01952 938014
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Setting Table Relationships
    Parameter Queries
    Creating and Using Reports
    Multi Table Queries
    Sorting and Filtering
    Creating and Using Forms
    DIY Forms
    Understanding VBA
    Creating Queries
    Modifying Forms
    Designing a Lookup Database
    An Introduction to VBA
    Querying Techniques
    Macro Techniques
    Working With Records
    Database Wellness
    Adding Transactional Records
    Aggregation Queries
    Data Validation
    Formatting Tables
    Relational Database Design

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: York
  • 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 ...
  • Naming Procedures
    Calling Procedures
    Organizing Code and Procedures
    Understanding Recordset Cursor Properties - Optional
    Using the For...Next Structure
    Using Debugging Tools
    Guidelines for use of Branching Structures
    Creating a Function Procedure
    Understanding the Form Object
    Considering Variable Scope and Lifetime Together
    Declaring and Creating Object Variables
    Using the For Each...Next Structure
    Using the Do...Loop Structure
    Creating a Sub Procedure
    Navigating the Access Object Hierarchy
    Working with Recordsets
    Using Intrinsic Constants
    Handling Errors

  • See Training Course Details...



Email us about this courses



Other York Enable Technology Training Courses

SQL York Training Courses
VBA York Training Courses
SSAS - York SQL Server Analysis Services Training Courses
JQuery Mobile York Training Courses
Power Query - York Excel Training Courses
DAX - York Excel Training Courses