Enable Technology

ACCESS SHEFFIELD TRAINING COURSES 

ACCESS TRAINING COURSES SHEFFIELD




About Enable Technology Sheffield Access Training Courses

Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. All course participants are issued Access training manuals they can refer to 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.

Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If you prefer we can offer an offsite socially distanced training location in Sheffield. We are happy to modify the Access syllabus to match your teams training requirements.

We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.

The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: National Power PLC, Birmingham Heartlands Hospital, Fujistu PLC, Nationwide Building Society Limited, Loughborough University, Aston University, Capita Group PLC and DHL Express.




Microsoft Access

  • 2 day course
  • Location: Sheffield
  • 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 ...
  • Working With Records
    Modifying Forms
    Parameter Queries
    Creating and Using Reports
    Action Queries
    Understanding VBA
    DIY Forms
    Getting to Know Access 
    Creating and Using Forms
    Aggregation Queries
    Querying Techniques
    Database Security
    Designing a Lookup Database
    Setting Table Relationships
    Creating a Relational Database
    Using a Navigation Form
    Formatting Tables
    Sorting and Filtering
    Creating Queries
    Adding Transactional Records
    Macros on Forms

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Sheffield
  • Telephone on 01952 938014
  • Course Outline
  • This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.

  • Some of the training topics covered include ...
  • Understanding Recordset Cursor Properties - Optional
    Introduction to Programming in Access
    Working with Properties
    Writing an Error-Handling Routine
    Understanding Data Types
    Understanding the Order of Events
    Considering Variable Scope and Lifetime Together
    Working with the Code Editor
    Handling Errors
    Working with Procedures and Functions
    Understanding Objects
    Trapping Errors with the On Error Statement
    Understanding Control-of-Flow Structures
    Guidelines for use of Branching Structures
    Understanding Procedures
    Using the If...End If Decision Structures
    Creating a Standard Module
    Understanding Collections
    Using Input Boxes
    Stepping through Code

  • See Training Course Details...



Email us about this courses



Other Sheffield Enable Technology Training Courses

SQL - Sheffield SQL Training Courses
JavaScript - Sheffield JavaScript Training Courses
PL/SQL Sheffield Training Courses
SSAS Tabular Sheffield Training Courses
SSAS Sheffield Training Courses
VBA Sheffield Training Courses