## Exporting data in Microsoft Access format

You can export data from the HelicsWin.Net database files as a zipped Access .mdb file.

Before you start, make sure that the survey start and end dates are defined in the Hospital data form for each hospital for which you want to export data.

To export data in Microsoft Access format:

• Click Data export in the main menu.

The Export form opens, by default in the Access database tab.

CDI

ICU

PPS

• Click the Open button (to the right of the Path field), to locate the folder to which you want to send the exported file, and then click OK.

For example, to use the folder C:\HWN2\Export, go to the folder C:\HWN2, and create the folder Export manually.

• CDI and PPS: In the data grid, select the code(s) and survey dates for the hospital-survey(s) for which you are exporting the data. You can select more than one hospital-survey by holding down the control button, and then clicking on each hospital code you wish to select or select all hospitals by clicking the Select all.

Make sure that the CDI / PPS start and end dates are defined in the Hospital data form.

• ICU: The entire selected surveillance year for the current hospital will be exported.

• Optionally, use the checkboxes to choose whether to include additional sets of variables in the exported files. These are data entered relating to:

a. Validation studies (not for CDI)

b. Users

c. Hospital names

d. Internal patient codes (for both primary and validation data).

As some of these may contain confidential information, they are not exported by default.

If a checkbox is left unchecked, the corresponding variables will be empty in the export file.

For the pilot study of the HAI-Net ICU protocol v2.0, user variables include the feasibility questionnaire data and need to be included in the export.

To preserve patient confidentiality in compliance with Data Protection principles, the internal patient code data must not be included in the export file sent to the regional, national or EU level, and must not be included in any data sent to ECDC/TESSy.

• Click Export the Access database.

HNW generates a ZIP file containing the exported database file HelicsWinNet_export.mdb or HelicsWinNetICU_export_yyyymmdd_hhmmss.mdb

The ZIP file is date and time stamped with the file name having the format: HWN_yyyymmdd_hhmmss.zip (PPS) or HWN_ICU_yyyymmdd_hhmmss.zip

• In the Access database form, click Open to view the contents of the folder you have exported your file to.

• ICU pilot: attach the exported zip file containing the Access database to an email and send it to your national HAI surveillance coordinator.

More:

Exporting data to TESSy CSV format

HelicsWin.Net v2.2 Online User Guide v20160330
© European Centre for Disease Prevention and Control, 2016
Reproduction is authorised, provided the source is acknowledged