Enable Technology

ACCESS EXETER TRAINING COURSES 

ACCESS TRAINING COURSES EXETER




About Enable Technology Exeter Access Training Courses

Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.

Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Exeter. We are happy to discuss customising the course content should you have particular Access training requirements.

Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Norfolk Police Constabulary, Birmingham Heartlands Hospital, Royal Air Force, Birmingham City University, Norwich Union PLC, Queen's Medical Centre Nottingham, Barclays Bank PLC and EDF Energy PLC.




Microsoft Access

  • 2 day course
  • Location: Exeter
  • 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 ...
  • Aggregation Queries
    DIY Forms
    Parameter Queries
    Creating Queries
    Navigation Pane Protection
    Data Validation
    An Introduction to VBA
    Modifying Table Structures
    Calculations in Queries
    Adding Records to a Table
    Macros on Forms
    Relational Database Design
    Understanding VBA
    Formatting Tables
    Importing and Exporting Records
    Querying Techniques
    Creating and Using Reports
    Sorting and Filtering
    Adding Transactional Records
    Action Queries
    Macro Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Exeter
  • Telephone on 01952 938014
  • Course Outline
  • This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.

  • Some of the training topics covered include ...
  • Using Intrinsic Constants
    Using the For Each...Next Structure
    Creating a Sub Procedure
    Using the Do...Loop Structure
    Understanding the Form Object
    Setting Break Expressions
    Working with Events
    Understanding Classes and Objects
    Working with Procedures and Functions
    Guidelines for use of Branching Structures
    Working with Properties
    Using Message Boxes
    Locking Records for Updating
    Using the Object Browser
    Creating a Function Procedure
    Working with Boolean Expressions
    Handling Errors
    Working with the Code Editor
    Creating a Standard Module
    Stepping through Code
    Using Expressions, Variables, and Intrinsic Functions

  • See Training Course Details...



Email us about this courses



Other Exeter Enable Technology Training Courses

SQL - Exeter SQL Training Courses
Excel Power Pivot Exeter Training Courses
TSQL Exeter Training Courses
SSAS Tabular - Exeter SQL Server Analysis Services Training Courses
Oracle SQL Exeter Training Courses
DAX Exeter Training Courses