Datasheet

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: