Home

MR0457

1. Exit Database Developed by SOPAC for the Department of Geology Mines and Water Resourc e Funding provided by the New Zealand Government a EEE usi SN Start ae n eje A Gog EH EN EN EN EN EN EN EN EN EN AN Ey EN afas axe 16 17 Z ama e Y das Exits the entire database Help Menu Forms Opens up a menu to select data entry forms for editing or adding new data viewing data and for data printouts Query Opens up a Search Form for you to find data related to Location Name Site Type Parameters and or Date interval Reports Opens up a menu to select reports for viewing and printouts SOPAC Miscellaneous Report 457 Channan 6 FORM MENU Features to note on a Form Forms are designed to be user friendly and the user should be aware of the following Fields these are the items of information to be stored in the database Each time a new record is entered on a form a new record is added to the table Navigation buttons these help the user to move or navigate through the records Combo boxes A combo box can make data entry easier quicker and more accurate by presenting a scrollable list from which to select To enter data for the different fields click on the Tabs which will show the parameters that are available for data entry Help The database has a customised Help file which tells you in simple ways how to use the database Error Messages thes
2. Page MU 1 2454 al E ali SAI II E I A MRS start BBAAECADG Elmo Geio Evan SARE Abata E switc E Search EE searc B sear LEY 11 54 ZAR GSERREY q After exporting to MS Excel this is what it will look like in your spreadsheet File Edit View Insert Format Tools Data Window Help LIEZ OSH Al 6QY S BEeO B z K SL W ara 10 B7U H 8 E D A SiteName Date 11 Sep 01 1233453 18 Sep 01 23450622 20 Sep 01 6 waila 1233453 22 Sep 01 site d 23450622 26 Sep 01 22 6 8 sited 23450622 1233453 01 Sep 01 1233453 01 Sep 01 11 waila 1233453 waila 1233453 20 Oct 01 22032316 29 Sep 01 1233453 30 Sep 01 15 gawa 12360214 01 Oct 01 16 site d 23450622 03 Oct 01 gawa 12360214 05 Oct 01 1233453 10 Oct 01 19 site b 22032316 15 Oct 01 20 waila 1233453 20 Oct 01 21 gawa 12360214 12 Nov 01 22 qawa 12360214 42 Nov 01 SOPAC Miscellaneous Report 457 Channan 21 APPENDIX Water Sample Analysis Form SOPAC Miscellaneous Report 457 Channan WATER SAMPLE ANALYSIS FORM aen of Geology Sample ID from Chain of Custody No Site Number FIELD MEASUREMENTS Conductivity Dissolved Oxygen Salinity Dis Oxygen Turbidity Clarity Colonies per 100 mL of sample Colonies per 100 mL of sample Colonies per 100 mL of sample C ms cm Project mg L PSS Sampled by Wa
3. CO o lia Qu alla o l 1233453 204 001 22032316 29 09 01 site b 1233453 30 09 01 maila GA o i V i n 12360214 01 1001 cana 23450622 03 10 01 site d LA d V 12360214 0510 01 cana 1233453 1040 01 LA Qu No o 22032316 15 1001 ho wn n o 1233453 20 10 01 te n Chemical Parameters Report Report showing all your chemical parameter data Chemical Parameters Search Result Site Number Date Alkalinity Ammania Calcium Chloride Chiorine coo DOD Madness She Name Fy mal mail ngl mail Fee Tata no maL mg L nage ng aL aa nemn a E I a T ara sear AAA I I eo imas sma Ce I I I ee 2162 net O TO a 0m e imas ze T_T ASI I he mins swn EE OT hp 2082 AAA O OOO e 1733454 0118 01 1733454 0118 01 1733454 1733454 210 01 21032316 20901 1733454 203 01 13380211 0190 01 2145062 0310 01 123360211 Edi 1733454 1010 01 22012316 15 10 01 1733454 20 01 12360214 12 11 01 172360214 12 11 01 Fedresion 14 November 2001 Gadoy Hiper ang Heer Resmiye SOPAC Miscellaneous Report 457 Channan 18 Island Report Island report can be generated with all island names and Island IDs that has been entered into the database S Water Quality Database IslandReport MEE File Edit View Tools Window Help 18 x x 5 00B oe w Ba D Island Report aa Yim nma 14 Novernte 2001 Page LIT 12 do PSA AA AAA LI A
4. EA A E ee HA Start Sea Ber Ki Grex AJExploring pata Ma 2 vanwate ES SuitchBo ES Report Ja IslandR SIS 8 57 gz BE Y Site Type Report Site Type report can be generated with all site type names and site type IDs that has been entered into the database S Water Quality Database SiteTypeReport ME ES File Edit View Tools Window Help 18 x KR 2 8 B E 100 cose W ig GC Site Type Report SiteTypelD SiteTypeName nn mono S I E DEE SUPE iz dati E e n Lr dla iaia lt page ll 7 All A A Y_Wr u Tear en EER Start BREaAAECEAG KS inbox AJExploring FE Data Ma fi vanwate EE SwitchBo ES Report B sitetyp ZENDEORNDE Y a5 SOPAC Miscellaneous Report 457 Channan 19 Site Details Report Site report can be generated with all site details that has been entered into the database S Water Quality Database SiteReport MES File Edit view Tools Window Help lej xi M BOOB Ge REI D Site Report Island ID 1 Site ID Site Type ID 1 SiteNumber IslandName Viti Levu Site Name site d SiteTypeName River Latitude ghf Longitude ghh Altitude fh Date Monitoring Started Date Monitoring Ended Location Description fhj WE Page GA rede Al A IA I A E a A a A a Start DESI EAA Eal Sjinbox na GJ Exploring iData Ma MI vanWate ES SuitchB
5. Site Name yi Dd degGef MOEM moi Sh PSs mu NTU mbs DI 12193453 110301 D 20092316 s00 a 7 O 3 358 eo 1239453 15040 1 D 23460622 aes TE os pes Ce 220801 TTT _ ken 23460522 0 2 bie a 234662 1250183 mass aa ose oa sn im ns a mn n ZS DG Gi E 1230163 mam TTT DI 12394533 rae 2 a a TT ep 2147316 220301 25 Gi E F o 1239459 30030 1 123460214 011001 2T 23450622 Doum IS Fra 12360214 osano 23 7a haa 1239453 man IS po o o Nap 22007316 noor E SR E ESO LAS So gt PE 1230453 anioni 25 __ ss __ Nap 12360214 anwar ae Last __ pa 12360214 anwar za pera qua Tuesday 13 November AUI Geolopy Jd ner gnd Water Resource Paget aft SOPAC Miscellaneous Report 457 Channan 17 Bacteriological Parameters Report Report showing all your bacteriological parameter data Bacteriological Parmeters Search Result Site Number Date Total Coliform E Coli Entercocci Site Name Yy MrvDd per100mi per 100mi per 100mi 1233453 11 09 01 maila P o o cn ho O jm tho un 22032316 15 09 01 site b 1233453 1809 01 waila 23450622 20 09 01 d n ho wn il i site d 1233453 22 09 01 maila 23450622 26 09 01 site d 23450622 site d 1233453 01 09 01 maila k 1233453 01 09 01 maila 1233453 maila LA b n maila
6. Site Type and or Site Name When selecting parameters highlighting the parameter from the list box and click on Add gt button This will move your choice of parameter into its corresponding list box Your can also select and remove unwanted parameters by clicking on lt Remove button If you need to search date intervals Type in Date from and Date To into the text box provided You can select one or a combination of any criteria fields provided depending on how you want your search result Common Error Messages LE The text you entered isn t an item in the list Choose from the Combo Box This applies to Combo Boxes when you try to enter a data that is not in the list 2 Date is not entered in the MONTH DAY YEAR format If you use a different format the results for your search will NOT be Correct 3 Message Box saying No Criteria Specified You have not entered any information for the query to run its search 4 To view the results of your search click on the FIND RECORD button The database will automatically search for what you asked it Once it has found those records then it will display it in another form for you to view the results Di If you want to make another Search Clicking the REFRESH button will clear all the text boxes so you can make the next selection for your search SOPAC Miscellaneous Report 457 Channan 15 SEARCH RESULTS To view the results of your search a form similar to the
7. alphabetical order SOPAC Miscellaneous Report 457 Channan 9 Sample Data Form This lets you into the Water Quality Database Form for you to enter your Sample data Enter Sample Data by using this form shown below Results from water testing are entered into this form Exits Data Entry Help F Combo Box drop down W i list a H SampleTable Als SiteNumber wc PHP Exit Add Location BR Cem or Custody No Name Field Measurements Bacteriological Results Chemical Results Comments deqcel Total Dissolved Solids E d msc 75 Dis Oxygen o a is o SEI Oxydation Reduction A e Potenta Turbidity io ur Clarity A mks Colonies per 100ml of Sample Tabs E Golf Colonies per 100ml of Sample Entercoccr Colonies per 100ml of Sample SOPAC Record 14 4 Di ea oF 1 Save Record SOPAC Miscellaneous Report 457 Channan 10 Steps for Sample Data Entry Enter Site Number ES SampleTable Bis Data E ntry Form SiteNumber f HELP Exit K Date 11 09 01 USER esr Month Des y i 9 DEG rr e Ge rime OU Minute Seconc P rer ste sample Depth ESTA mi Field Measurements Bacteriological Results Chemical Results Comments Each new sample data entered is given a unique number which is auto generated Take the following steps for data entry First select Island Name from the Island Name drop down list then select from Site Nam
8. SOPAC Miscellaneous Report 457 April 2002 VANUATU WATER QUALITY DATABASE USER MANUAL by Lina Channan Water Quality Officer Prepared for South Pacific Applied Geoscience Commission SOPAC 2 TABLE OF CONTENTS FOREWORD al alano 3 REQUIREMENTS eee en oe ee eee ee ee alessia 3 GETTING STARTE Lavate 4 MAIN SCREEN OR SWITCHBOARD sia ds 5 FORM MENU Features 10 Note ON FO Mia A ie 6 Belge Ee iena a 6 DATAENIRCFORMS bll 7 Bland DAt FO Macellaio 7 Site Type E Ea I ali 7 Site Deals Ge Lg acacia Steps TOF Adding New LOCANON EE 8 Sample Dat FO Mad Steps tor Sample Data ENI dada daa 10 ENT e Tnne EE 11 SAVING New EMU si EE 12 SEARCHOUYERY EE 13 Features On Search Folios 13 Steps 1Ol Dala SS ani ile 14 COMMON Error Messages src is 14 SEARCH RESULTS toa 15 REPORTS id 17 Farameter FR CDOS TT 16 17 Island Reporta aii A O alia 18 Site TYDE REDO a 18 SE WEN ee GE 19 Sample FREDO asii 19 EXPORTING DATA TO EXCELSPREADSHEE Liege eege 20 APPENDIX Water Sample Analysis FO Mia lie 21 SOPAC Miscellaneous Report 457 Channan 3 FOREWORD This manual is a user handbook for the Water Quality Database This system is based on Microsoft Access 2000 and describes how to navigate around the Water Quality Database This manual is not intended to tutor you on how to use Microsoft Access Instead it is a guide that describes how to operate and troubleshoot the Water Quality Database system and will help familiarise y
9. a from your log sheet You do not need to enter in all the parameters only those that were sampled and tested If parameter has no data fields can be left blank The following Parameter tests results can be inputted Field Parameters Temperature degrees Celsius C Conductivity milliSiemens cm mS cm Dissolved Oxygen milligrams Litre mg L pH pH units ORP Oxidation Reduction Potential millivolts mV Salinity Practical Salinity Scale PSS Depth meters m Clarity meters below surface mbs Dissolved Oxygen Total Dissolved Solids TDS g L Turbidity Nephelometric turbidity units NTU Bacteriological Total Coliform colonies per 100mL sample per 100mL E Coli colonies per 100mL sample per 100mL Entercocci colonies per 100mL sample per 100mL SOPAC Miscellaneous Report 457 Channan 12 Chemical Alkalinity mg L as CaCO Ammonia mg L NH Calcium mg L as CaCO Chloride mg L Chlorine Free mg L free Ch Chlorine Total mg L total CH COD Chemical Oxygen Demand mg L BOD Biochemical Oxygen Demand mg L Hardness mg L as CaCO Iron mg L Fe Magnesium mg L Nitrate mg L NO Nitrite mg L NO Sulphate mg L SO Phosphorus mg L PO Suspended Solids Total mg l Click on Save Record to save your data You could also preview your data in report format for printout Exi
10. e from the Site Name drop down list Once an Island Name is selected the choices for Site Names are only related to that particular Island It is important to enter in Island Name and Site Name first before entering in any other data You can also add a new site by clicking on the ADD Site button if that site is not in your list Open Site Details Form To enter in New Location Sites that are not in the list See section on Site Details Now Enter in Site Number this is your 7 digit code typed into the text box Date Year Month Day format Time Hour Minute Second format NOTE These were the required fields If these fields are not entered first then the database will not enter any other data You will get error messages SOPAC Miscellaneous Report 457 Channan 11 Entering Parameters Tabs Sample Depth n n Chain Qi Custody No Field Measurements Bacteriological Results Chemical Results Comments Standard Units Temperature es ce Total Dissolved Solids Di A Conductivity macm 75 DIS Oxygen o o Drs Oxygen mcg iL Oxy dation Reduction ei Ka pH Potential LE E ity j Ma Turbidity TU Clarity A mhs Total Coliforms Colonies per 100ml of Sample E Gab Colonies per 100ml of sample Enfercoccr Colonies per 100ml of Sample SOPAC Record 14 d de DIER oF 1 NOTE This database only accepts data for the above parameters and units Enter the required parameter dat
11. e list Do not enter in Site Type twice check the list before entering a new site type by previewing the report Site Details Forms Steps for Adding in New Location ii elp Enter in Site Details Type in Site Number Exits Data Entry Combo Box drop down Form e Esta fR nd lt a Site Number 1233453 i i Site Details ELE A Site Type Water Supply e Mee 6 21 237 Je Latttude 1 22 21 222 GQ Altitude 1223 masi Monitoring Started 12 2 00 MMDD Monitoring Ended GG Ri Location Description Site Description Purpose Of Site Other Comments marshy area New Island Data New Site Type Data Preview Site Report Lia a gt vt be Back Forward New Entering in Site Details data certain fields are required to be entered The required fields are Island ID and Island Name Site ID and Site Name Site Type and Site Number These data should be entered in first before filling in any other details Date Year Month Day format Longitude E Latitude S Altitude masi It is also very important that Sample Sites only be entered once and not repeated Before entering in any new data preview the report and check the list of data entered Suggest that an updated list be printed to review before adding a new site After you have done this Save and Close the Site Details Entry Form NOTE The new site name will be added to the drop down list for selection in your Sample Form This drop down list arranges Site Names in
12. e will come up when data has not been entered properly Record Selectors Moves to the first record Current Record Number Opens up a new entry form Number of existing records in the database Selects the last record done for data entry Selects the previous record Selects the next record entry SOPAC Miscellaneous Report 457 Channan 7 DATA ENTRY FORMS H Form Form Aa pen Edit Site Details Open Edit Data Entry Form sland Data 7 View All T Sample Data Site Type Site Details Exit to Main Switchboard Island Data Form Enter in Island Names and ID 8 IslandForm fel x lei TE SA Save HELP Exit Island Name not rl Preview Report Back Forward New A list of Island Names with sampling sites present Use the text box to type in Island Name this should only be entered in once Please check the list of Island Names before adding any new Names by previewing the report After you ve added a new Island Name click on Save Record then Exit to return to the Main Menu Site Type Form Enter in Site Types and ID 3 SiteTypeForm Of sl Es rari Pi ssf Save Record HELP Exit Site Type ID Site Type Name Preview Report Back Forward New Site Type indicates the type of water source where the sample is tested Use the text box to type in the site type SOPAC Miscellaneous Report 457 Channan 8 Enter in new Site Type for th
13. icense d to Type in Password Here My Briefcase ITU SOPAC Product ID 53488 415 0282414 51945 N 1 h DO Copyright 1992 1996 Microsoft Corporation All rights reserved ote you WI n ot see W at tl This program is protected by US and international x copyright laws as described in Help About you are typi n g a Shortcut to Microsoft Your Password will show on the screen Asa SAVYAAA BY Microsoft Word Document WIR 1950 If you have access as an Administrator type in your login name Administrator Now type in your Password If you are a user type in login name Guest After typing in the login and password Click on OK button As soon as you have entered in the correct login name and password Access will open up the database SOPAC Miscellaneous Report 457 Channan H MAIN SCREEN OR SWITCHBOARD This can be viewed as the control centre for the database from which the user can navigate their way around the different facilities of data entry querying and presentation in report form Opens Data Opens Search Previews Reports Entry Forms Form E Yanuatu Water Quality Daatabase PE a OT Arial i i 9 ip E U E Ale Zr w E SRY s Beh ES SwitchBoard SEARGH 3 REPORTS OpeivEdit Site Details View All Reports i Open Edit Data Entry Form Search for Either e 2 Location pen Forms Parameter or Date Menu related datainthe i Ren database
14. o ES Report BI SiteRep AI mY oc name 15 Sample Report Sample report can be generated with all sample data that has been entered into the database Sample Report island ID Island Name Y Site Type ID 3 Site Type Name Water Supply Site ID 1 Site Name waila Sample ID 15 Site Number Date 20 10 01 Year Month Day Time Hour Minute Second Sample Depth Total Coliforms 18 per 100ml Temp erature 27 Conductivity 50 E Coli 10 Del Um Dissolved Oxygen 6 Entercocci 8 per 100ml Dissolved Oxygen pH Salinity TDS ORP Turbidity Clarity Chemical Results Alkalinity 0 6 mg _CaCO3 Hardness CaCO mg L CaCO Mh saa wwe ni wee A hi1 RA masse ate e a a fi SOPAC Miscellaneous Report 457 Channan 20 EXPORTING DATA INTO MS EXCEL After you have previewed your data in report format this can also be exported into MS Excel Once exported you can use your data to generate graphs Select Analyze It with MS Excel File Edit view Tools Window Help LIEZ x 00m un dese Ri Da Merge It with MS Word a Ma i fal Publish It with MS Word E Analyze It with MS Excel AS Field Parameters Search Mesut Site Number Date Tempt Cond DisOxy DisOxy pH Salinity TDS ORP Turbidity Clarity Site Name Yy Mm Dd degCel mS cm mg L PSS mV NTU mbs 23450622 200901 _2 oe ed 1233453 220901 i 1233453 moso 2515 oss 49 so 717 02 o4 es oss paa e
15. one below will appear on your screen K ES searchresult Sample ID Site Type ID Time Island Name Site Name Closes Search Results Preview Report for printing Pil ES Island 1D i SteNumber 1233453 E site ID i WW Of Field Report bio WearionthiDay Custody Ho o Hour tiine Second Sump Depth di Chemical Report Viti Levu vw alle ICH IA El A eter Supply Temperature Conductivity Dis Oxygen Dis Oxygen pH Salinity TDS Alkalinity Ammonia Calcium Chloride Chlorine Free Chlorine Total COD BOD Field Parameters ORP Turbidity Clarity mMS cm mal nr Bacteriological Parameters Total Coliforms perl 0ml E Coli peri 00m Entercocci perl 004 rm Chemical Parameters moi Hardness CaCO3 MEM not moi Nitrate o NC E I I ae nat Me CT ad Phosphorus mail Pos HS Suspended TI mot Solids Total mal mgl Record 14 4 1 m l of 24 al Record Selectors Data SOPAC Miscellaneous Report 457 Channan 16 REPORTS Upon clicking the Preview Report button your screen should show a formatted report with the data resulting from your search This can be printed out for your reporting Parameter Reports Field Parameter Report Report showing all your field parameter data Field Parameters Search Resuli Site Number Date Tempt Cond Diky Gs pH Salinfiy TOS ORP O Turbidity Clarity
16. ou with all aspects of the package and provide a reference tool for questions you might have in future It is strongly recommended that the users read the appropriate user manuals for further knowledge of Microsoft Access The Water Quality Database is designed to be fast and takes full advantage of modern PCs It is easy to master and can be easily installed and run by personnel with very basic computer skills REQUIREMENTS Microsoft Office 2000 Full installation of MS Access 2000 version SOPAC Miscellaneous Report 457 Channan 4 GETTING STARTED Entering the Water Quality Database Locate the icon from the Windows 2000 screen for the above database and double click it with the left button of your mouse SOPAC Water Quality Database The database has a security system which requires access for Administrator and User Group Administrator has full access for maintenance and modification of the application Is responsible for assigning username and password to the authorised personnel The username and password is given to the water quality monitoring staff who would be entering data viewing and querying data The following prompt comes up to verify the right username and the privilege My Computer Compaq Informati Microsoft Type Login Name Here Outlook JEF Logon HR E x Setup Name o Microsofi Admin L Sa Cancel i EE Password T as ES Pe Network SOPAC e Neighborhood f This product is l
17. t to the Form Menu when required Saving a New Entry Once entries have been made into the fields save the record Clicking the Save Record button located on the form Clicking the Close button will exit the entry form and take you back to the Form Menu SOPAC Miscellaneous Report 457 Channan 13 SEARCH QUERY To search the records of data inputted click on the Search button with the binoculars icon This can be accessed from the database switchboard Clicking Search button binoculars icon opens a form Features on Search Form Clears field for next Searches for Closes Search search Record Choose from the List for Location Site Type and Parameter Island Name Help P Choose Island Name Site Type and or Site Name from List ES Search site Type Site Name Temperature Conductraty Dissolved Oxygen H pH List Box showing parameters Select Total Coliforms selected Parameters E from List Coli l Boxes and M ercocci Add for querying To deselect parameters select from Alkalinity ZER list and click Ammonia Remove Calcium Chloride Type in Date MONTA DAY TEAR format Date From IO Date To II Type into text box date month day year interval SOPAC Miscellaneous Report 457 Channan 14 Steps for Data Search In searching for data it is not necessary to fill in all of the fields Select from the drop down list Island Name
18. ter Source O Coastal O Borehole g L mV O Water Supply O Spring O Effluent O Private ntu mbs Bacteriological Results Total Coliforms Chemical Analysis Alkalinity Chiorine Free Chiorine Total COD TA ECH ECH RECH RECH RECH Hardness os coco a a Comments Suspended Solids Total Entered into Water Quality Database by rae on Ed

MR0457

Contents

Download Pdf Manuals

Related Search

Related Contents