ECCAIRS 5 Introduction Course

An introductory course in using the ECCAIRS 5 browser

2 DaysCrawley£580.00+VAT

The European Coordination Centre for Accident and Incident Reporting Systems (ECCAIRS) assists national and European transport entities in collecting, sharing and analysing air safety-related data.

Using the ECCAIRS 5 browser, we show everything from entering and modifying occurrence data, to creating both simple and complex queries and performing basic reporting and exporting of occurrences.

If you already have some experience in handling and entering air safety-related data into a central database, this introductory training course will enhance your current skills and knowledge and give you a general overview of ECCAIRS.

Course Detail

What you’ll learn

By the end of the programme you’ll be able to:

  • Follow the ECCAIRS data entry standards
  • Enter and modify data in the ECCAIRS Repository
  • Retrieve data using a range of query techniques
  • Produce reports and export data

What’s covered

Background to ECCAIRS

  • What does it mean?
  • What does it do?
  • What are the objectives of ECCAIRS?
  • Taxonomy and terminology

ECCAIRS system overview

  • Login and using the ECCAIRS browser
  • Topic tree and topic data
  • Occurrence list
  • Browser appearance options
  • Populating the occurrence list
  • Batches
  • Finding text in the occurrence list
  • Filtering and sorting the occurrence list
  • Editing an occurrence
  • Occurrence list options

Data entry standards

  • Starting a new record
  • Viewing the topic tree
  • Types of attribute controls
  • Saving
  • Tooltips
  • Mandatory attributes

Data entry

  • Creating a new occurrence
  • Adding a new “parent” topic
  • Adding a new “child” topic

Entering events and factors

  • Adding an event
  • Adding a descriptive factor
  • Managing links

Retrieving data

  • Refreshing a query
  • Recently used queries
  • Showing the definition of the current query

Queries by example

  • Creating a query by example
  • Query by example results
  • Viewing details of a single record
  • Printing a record
  • Printing the occurrence list

Query libraries

  • Organising a query library
  • Creating a query library
  • Closing a library
  • Opening a library
  • Locking a library
  • Unlocking a library

Creating and running queries

  • Creating queries
  • Starting a new query
  • Using an attribute ID
  • Finding an attribute ID
  • Creating a “has value” query
  • Creating an “equal to” query
  • Creating date queries
  • Creating a “contains” query
  • Attribute layout
  • Counting the number of records found by a query
  • Running a query

More advanced queries

  • Query descriptions
  • Copying a query

Modifying a query

  • Using AND in query criteria
  • Using OR in query criteria
  • Grouping in query criteria
  • Copying query syntax

Parameter queries

  • Creating a parameter query
  • Running a parameter query

Sub query and global filter

  • Creating a query with a sub query
  • Creating a global filter
  • Enabling and disabling global filters
  • Deleting the global filter

Reporting and exporting data

  • Generating a report from a template
  • Single record reporting
  • Reporting using a query
  • Exporting data to Excel
2 DaysCrawley£580.00+VAT