EXPOFACTS
Exposure Factors Sourcebook for Europe
User Manual
8.6.2006
This document is a part of ExpoFacts, the exposure factors sourcebook for Europe.

Contents

1. Database access

2. Search results

2.1 Selecting visible fields
2.2 Sorting the search results
2.3 Filtering the search results
2.4 Printing the search results
2.5 Saving the search results as CSV or XLS
2.6 Viewing the additional information
2.7 Viewing the table references & info

3. Phrase search


1. Database access

The database access screen allows user to search data from the ExpoFacts database. There are four steps to go through in order to get search results:

  1. Select the country of the data.
  2. Select the category of tables to be listed.
  3. Select the desired table.
  4. Select the desired time period or leave selections unchanged to search from all years.
After completing these selections press the Execute search-button and the search results screen will appear.


Figure 1. Database access screen.


2. Search results

The search results screen displays the data of the selected table and provides some useful tools for sorting, filtering, printing and downloading that data. The data is displayed in a table where columns represent table fields. First row of this table consists of field headers. Field descriptions can be shown by taking mouse cursor over field headers or data values. With large data sets this is especially handy feature. Search results screen can be accessed from database access or phrase search page. Back to selections-button takes user back to the page from where the results page was accessed.


Figure 2. Search results screen.

Following sub-chapters describe the features and usage of the search results screen.

2.1 Selecting visible fields

By default all fields (columns) of the selected table are visible. This can be changed by pressing Select fields -button which can be found from inside the View-box.


Figure 3. 'Select fields'-button.

The field selection window includes check box for each field (column) of the selected table. Checked box means that the field is visible on search results screen. Unchecking the box hides the field. Reset-button checks all check boxes (makes all fields visible). Apply-button applies the changes to field visibility at results screen and closes the window. Close-button closes the window without applying any changes to field visibility.


Figure 4. Field selection window.

2.2 Sorting the search results

By default the search results are being sorted by table's key fields (data year, country, ...). Sometimes it can be useful to modify this default criteria and it can be done by pressing the Sort-button, which can be found from inside the View-box.


Figure 5. 'Sort'-button.

The sorting criteria window includes as many selection boxes as there are fields in the selected table. Each of these selections include all field headers of the selected table. This makes it possible to sort data on multiple columns (fields). Multiple column sort has an order that is marked with numbers before each selection box. Besides this there is a check box after each selection box. This check box can be used to apply descending sorting order for the column. Reset-button clears all selections and checkings. Apply-button closes the window and applies the selected sorting criteria to search results view. If all selections are empty while pressing the Apply-button then the default sorting criteria will be applied. Cancel-button closes the window without modifying the current sorting criteria.


Figure 6. Sorting criteria window.

2.3 Filtering the search results

Search results can be filtered by any value of any field (or fields) of the selected table. This is done by pressing the Filter-button, which can be found from inside the View-box.


Figure 7. 'Filter'-button.

The filter criteria window includes a selection box for each field (column) of the selected table. Each selection includes all values of the field. If a value or values are selected and applied then the search result screen shows only those rows that include selected value or values. Filtering is restricted so that only one value per field can be selected. Reset-button clears all selections. Apply-button applies the selected filter criteria to the search results screen and closes the filter window. Cancel-button closes the window without making any changes to the current filter criteria.


Figure 8. Filter criteria window.

2.4 Printing the search results

Search results can be displayed in more printer friendly format by pressing the Print-button which can be found from inside the View-box. This will open a new window that shows selected table's data, field descriptions and references. The table data in print view is formatted equally to search results screen (filtering, sorting etc...). Actual printing can be done by activating the window and pressing CTRL & P or by selecting Print... from the window's File-menu.


Figure 9. 'Print'-button.

2.5 Saving the search results as CSV or XLS

Search results can be downloaded and saved as CSV (comma separated values) or XLS (Excel) file. This is done by pressing the CSV or Excel button, which can be found from inside the Save as-box. Downloaded table data is formatted equally to search results screen (filtering, sorting etc...) containing also field descriptions and references.


Figure 10. Saving buttons.

2.6 Viewing the additional information

Besides the actual data, a table in ExpoFacts database may have some links to additional information. This information can be pictures, charts, articles... If any links to additional information are available then they will be listed below Additional information-title next to the View-box.

Note: If the results page was entered from the database access page then only links for the selected country (or countries) will be displayed.


Figure 11. Additional information links.

2.7 Viewing the table references & info

Complete listing of the table's references (sources, urls, copyrights), field descriptions and other information can be viewed by pressing the References & info-button.


Figure 12. 'References & info'-button.

3. Phrase search

Phrase search is an alternative way to access the ExpoFacts database. Phrases can be searched from table names, field descriptions and table sources. User has ability to choose which of those targets are included into phrase search. This can be done by checking the desired targets below the Search from-title. The actual phrase needs to be entered into the text field below the Phrase-title. Finally search can be executed by pressing the Search-button.


Figure 13. Phrase search tools.

Phrase search ouputs a table of the tables that match the search criteria. First column of the table contains the names of the matching tables. The cells after each table name tells from where the searched phrase was found. Matching targets are marked with green check mark. The data of a table in the name list can be viewed by clicking on its name which opens the search results page.


Figure 14. Phrase search result table.