Datasheet

[1:112pien

Vtg, Design

Nev..' X

Objects

&IMP'

For

Reports

Pages

Macros

Modules

*-15-

- 4-4-

Create query in C:iesign

Create query by usinq

Meteo_5minRain AW5

AWS

Meteo_Hourly

ITN NBD_Pre Processing : Database

Data Retrieval, Processing and Final Storage in the Nile Basin Database

Data Processing in MS Access and Final Storage into the NBD

Table 4 presents the input and output tables for each of the above queries. AWS stands for Automatic Weather

Station, which have been established in the region within the GCP/RAF/304/JPN and GCP/INT/752/ITA Projects.

For reference purposes, the general query design is presented in Annex 5. The function and design of the

ID-Converter table, included in the various queries, is discussed in Annex 6.

Input Auxiliary MS Access

Table

Meteo_5minRain

Meteo_Hourly

Meteo_Daily

Query for Data Processing and

Final Transfer into NBD

Meteo_5minRain AWS

Meteo_Hourly AWS

Meteo_Daily AWS

Final NBD Destination Table

AWS Meteo_5min Rain Data

AWS Meteo_Hourly Data

AWS Meteo_Daily Data

Table 4: Designated Input and Destination tables for each pre-defined append query.

Continue the data processing exercise by performing step 13.

Step D13: Finalize data processing by activating the appropriate query. For example, highlight the “Meteo_Hourly

AWS” append query to process the newly imported data set from the “Meteo_Hourly” auxiliary MS Access table to the

final “AWS Meteo_Hourly Data”. Click Open. By this operation data records in “Meteo_Hourly” table will be processed

as appropriate and final results will be automatically stored/appended into the final NBD destination table “AWS

Meteo_Hourly Data” table.

The following message box pops up.