Datasheet

Meteo_Hourly : Table
Datalogger-ID
5
5
5
5
5!
200195
?001 9
21101 9 !r-1
2001 9 5
?OW 9 5
T.,001 9 F,
2001 9 F.,
2001 9
?OW 9
T)001 9 F,
W] h
Record: H
4
I i*I of 186
L
1500
-
27.541 2.253
1800 25.86
2.239
1700
25.76 2.222
1800
24.41 2.137
1900 23.05 2.185
2000
21.6 2.179
2100
20 .i.J 4
2.232
2200
20.84
2.196
23001 20.15 2.089
2400 19.86 2.059
1 -J..36
.L.1_11 _1b
Avg-T
/11 Avg-VP
Year
Time
Microsoft Access
.1 File
1 Edit
Insert Format Records Tools Window Help
Dj4K1cantUr1dp Ctrl+Zr.
' ' - Yo Y=1
g cut
ink Copy
e Paste
Delete
it4 Find...
Go To
19(
Der-'-
Select Record
Select All Records
Ctrl+X
Ctrl+C
Ctr1+11
Del
Delete Record
Ctrl+A
Ctrl+F
,_b7-777-14
MM-DD
195
95
95
2.253
95
95
95
95
95
75y7L-L
*xloia.
Avg -VP
2.239
2.222
2.137
2.185
2.179
2.232
2.196
2.089
2.059
2.006
Time Avg -T
1500 27.54
1600 25.86
1700 25.76
1800 24.41
1900 23.05
2000
21.6
2100 20.94
2200 20.64
2300
20.15
2400 19.86
100 1
7:61
N
bc)
II
1 I+l of 186
Record:
11
42
Data Retrieval, Processing and Final Storage in the Nile Basin Database
Data Processing in MS Access and Final Storage into the NBD
In the above screen, the Meteo_Hourly table still contains data from a previous transfer exercise. Although primary
key setting in the final NBD tables do not allow for data duplication, it is good policy to delete all records from the
auxiliary tables, in this case Meteo_Hourly, prior to a processing new data set. To this end, continue with step 3.
Step D3: Select all records by simultaneously keying CTRL and A, or clicking Select All Records in the Edit menu.
The complete record set is now highlighted.
Step D4: Delete all records by choosing Delete Records from the Edit menu, or by pressing the ‘Delete’ key as
shown on the following screen: