Vanuatu Mineral Resources Database. User manual.
Contents
1. 12 735226 11 8223845 12 1407 APP1 16727 E 1621S 58S 7617436 35 8190751 19 7614436 35 8205947 34 7624436 35 8205947 34 7624436 35 8195947 34 7614436 35 8195947 34 The last transformation is to put back all these coordinates into Geodetic WGS84 The Geographic Calculator is used to perform this task East1 North1 East2 North2 East3 North3 East4 North4 Longi Lati Long2 Lat2 Long3 Lat3 Long4 217073 329 8058484 42 227073 329 8058484 42 227073 329 8048484 42 217073 329 8048484 42 168 335004 17 542144 168 429127 17 543389 168 427849 17 633687 168 333679 735226 11 8233845 12 745226 11 8233845 12 745226 11 8223845 12 735226 11 8223845 12 7614436 35 8205947 34 7624436 35 8205947 34 7624436 35 8195947 34 7614436 35 8195947 34 0 0 0 0 The latitude and longitude pairs i e Longl Latl to Long4 Lat4 are then recorded on the database entry form 3 1 4 Compute Prospecting Licence based on the current form For the current prospecting licence registration form the boundaries of the prospecting licence are given in geodetic format The operator needs only to convert them from Geodetic Bellevue to Geodetic WGS84 when appropriate 3 1 5 Entering Data in Prospecting Licence Access Form All necessary information for the entry of the details of prospecting licence 1405 has now been gathered together Note that the database will reject an incomplete form 18 BGS SOPAC Vanuatu Mineral Resources Database Prospect Licence Prospecting Licence Disp2. are allowed in a field For example text cannot be stored in a field with the Number data type Common data types include Text Number Date Time and Yes No but there are many more Datasheet Data from a table form or query displayed in a row and column format similar to a spreadsheet Design View A window displaying the design of a table form query or report In this view existing objects can be modified and new ones can be created Entity Term used in database design to describe something about which information is known For example A Prospecting Licence is an Entity and its attributes include the Prospecting Licence Number Date of issue Fee paid etc Focus This refers to the most current cursor position on a form Whichever field on a form has the cursor in it is said to have the focus Form 23 BGS SOPAC Vanuatu Mineral Resources Database A form is a screen where a user can input and edit information The form is based on a table meaning that when data is typed into the form it is stored in the underlying table Forms may sometimes be based on more than one table i e a query Form View This is the view of the form that the user sees when opening a form and entering data Forms have two other kinds of view design view which is the layout of the form s design without the display of underlying data and datasheet view which is a view of the data the form 1s based on 1n row and column format similar to a
3. database grouped by island e Reports Island provides a listing of all reports stored in the database grouped by island On clicking the required button the user is presented with a preview of how the document will look when printed 2 6 Utilities There are five buttons providing different facilities which are summarised briefly below e MapInfo starts a MapInfo session e Change Password allows the user to change their password e Profile allows the user to set the correct drive path for loading data into MapInfo e User Management assign a new user or change permissions Database Manager only e Full Access access to the actual workings of the database Database Manager only 3 Data Input 3 1 How to enter the Prospecting Licences 3 1 1 The registration form 3 1 1 1 Old form before 1985 Before 1985 Vanuatu law stated a requirement for quoting the prospecting licence area boundaries in relation to a reference point This reference point was sited on the map by the IGN Institut G ographique National and 16 BGS SOPAC Vanuatu Mineral Resources Database based on the Bellevue Datum Nevertheless this map series is inaccurate as most of the islands are misplaced relative to oneanother Currently an Excel spreadsheet is used to compute the Prospecting Licence boundaries based on the Bellevue Datum 3 1 1 2 Current form After 1985 Vanuatu law started to require the Geodetic coordinates of the boundaries of
4. the form A pair of binoculars means Find a particular record Combo boxes A combo box can make data entry easier quicker and more accurate by presenting a scrollable list from which values can be directly picked Error Messages to ensure data quality there are built in rules concerning the values data can be stored as Some of these are summarised below Error Message Applies to The value you entered isn t appropriate for the field Fields whose underlying data type is different from the data you tried to enter For example information about dates is usually stored in the VMRD in Medium date format i e 22 Nov 95 If you try and enter the date as 22 11 95 for example you will get this message You would see the same error message if you tried to enter text into a field whose data type is defined as a Number The value you enter must match an entry in the list This applies to Combo Boxes when you try to enter a value that is not in the list which is not acceptable for BGS SOPAC Vanuatu Mineral Resources Database the list The value you entered isn t in the list do you want to This applies to Combo Boxes when you enter a value add 1t that does not occur in the list but which is accepted if you want to add it Name The name entered as the source of the value in the field is invalid For example you may have entered an invalid name or expression for the ControlSource property The name m
5. the prospecting licence which is easier as these coordinates were in the old projection system made by IGN Bellevue Datum The Data Operator will have to ensure that conversions are made for these geodetic coordinates from Bellevue to WGS84 which is the new map system adopted by the Vanuatu Republic 3 1 2 The map systems A decision has been made in Vanuatu to produce a new accurate map series of the regional geography This work is under process by the Lands amp Survey Department and the new series of maps should be compatible with data derived from GPS Global Positioning System 3 1 2 1 IGN Datum Universal Transverse Mercator UTM International Ellipsoid Bellevue Datum Zone 58 59 Southern Hemisphere 3 1 2 2 GPS Datum adopted in 1994 Universal Transverse Mercator UTM World Geodetic System ellipsoid WGS84 Zone 58 59 Southern Hemisphere Mean Sea Level Local 3 1 3 Compute Prospecting Licence boundaries based on the old form 3 1 3 1 Reference point co ordinates The Geographic Calculator File Options Help EE Sle oso O lel Name Unnamed Name Unnamed Latitude 1733225 Northing 805 7001 14 Longitude 168 22 40 E Easting 22163840 Ellip Ht 0 00 oystem Geodetic oystem Universal Transverse Mercator Datum 166 WGS 1984 Datum 186 WGS 1984 fone fone 595 166 E to 174 E Forward gt gt Inverse gt gt lt lt Convert Inverse Forward The Geographic Calculat
6. It is not intended that this manual be an exhaustive list of instructions on how to use Microsoft Access and MapInfo Therefore it is strongly recommended that users of the VMRD read the appropriate user manuals for further knowledge of these software packages 1 1 Requirements Compatible PC 486 8Mb with at least 1OMb of free space on the hard drive Windows 3 1 or later MS DOS 5 0 or later MS Access V2 0 MapInfo V3 0 Network recommended Large paper size colour printer recommended 2 Entering the Vanuatu Mineral Resources Database From Program Manager locate the icon for the above database and double click it Vanuatu Mineral Resources GIS Pv a came Site vMBD VMAD Database Hemne You will be prompted for a user name and password After typing it correctly you will see the main screen for the Vanuatu Mineral Resources Database Name OK Password o Cancel 2 1 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 the data entry querying and presentation in report form There is also a section named Utilities where the user may perform other operations such as opening a MapInfo session changing their password or other database management activities for which there is limited user access for security purposes BGS SOPAC Vanuatu Mineral Resources Database Varum i
7. Table opens and the operator should select the sample to be located and then immediately shift to the map view where the sample location should be pinpointed In order to aid sample location it is recommended that the Vanuatu drainage layer be switched on Care should be taken to ensure that samples that have already been referenced are not re referenced by mistake Mapinin Eile Edit Qbecis Query Jable Ogions YWiedow Wap Help Shmiples Licences VANUATU Map Samples ening Teach amples Acie Litet i Afuul Exh 3 3 3 Geocoding the samples back to the data tables When all samples have been referenced the operator must then select the Geocode Samples command from within the Minerals menu This fills in the Long Lat fields in the Sample Table by picking up the values in Maplnfo and transferring them into the above Access 20 BGS SOPAC 4 Recommendations Vanuatu Mineral Resources Database e The Prospecting licence boundaries coordinates must be acquired from the prospecting company in Geodetic W GS84 format e The prospecting company should provide a summary spreadsheet of the samples taken as an annex This spreadsheet should conform to the format detailed below Attribute name Data Type Sample ID Text 50 Prospecting Licence Text 7 Number Sample Number Text 10 Island Text 20 Location Text 50 Minerals Text 50 Laboratory Name Text 20 Geological Description Text 255 Comments Text 255 Longitude Number Latitude N
8. Vanuatu Mineral Resources Database User Manual Franck Martin SOPAC Gaynor L Collins BGS December 1995 BGS SOPAC Vanuatu Mineral Resources Database T FOREWORD Breer eee meet re sre sne seas tea siy ane sn sneer feet Meee rnc ements fe I cob ese mance o fe CORDON CUIUS 3 NITIDIS TT LT 3 2 ENTERING THE VANUATU MINERAL RESOURCES DATABASE 3 2 1 Mam Screen ar SwitchDOSE cs seo ioo euer Sae Se Noe RS R E Yo LAS NER E RS RU uo EAS NR ER RES NN CES DASS A NIAI SOR RETE SP RE RU a Cad 3 252 ata BB Ee eo n dei eu M P d M e E I 4 22 Prospecting Licence IntOFPRAQ Nesis a E a ul a pd oU ed a Sed 4 2 2 REPON Moman a a a a 5 2 2 J 90 iple MIM ORMIALION aes fied faeces E E FT A E T EE A N E A TE cta pie 6 2A Features NOTER QU SPI ETE SUE 7 PAP SRI SISSE STD DT AE E E UT LIN esata 8 2 41 Samples ocatiofis seeo ect ed utei leur ie od IO eee dta ratito ei a a a A 8 2A 2 Companies 7 ISlANGS tete cas Danaea edit cup S bti usn ite dU nbnant leeches 9 DAS Ble mens 111 SATO CG ci cassie eor det E hc UMS I sao Phu ME rS east Adi ad e ple ups da dee 13 PAN MU HL TID E LED m 15 PAM E 16 PP M UOT closet saat earache a a aa 16 3 1 How to enter the Prospecting Licences sci csseszisecccxcasceacgssdescencsdecvebetsesuescnddcanecodeeneuetdecnstecswencxceucecsdeeseussiece 16 SM The Te sis rat on rta 16 SU AZ esi ES SUC TAS ET TOO S A 17 3 1 3 Compute Pro
9. a an ancl aor act a APT fe By selecting a company name and or an island depending on which button is to be pressed a query is run presenting information fulfilling the set criteria e Reports by Island this button is pressed when an island has been selected and following this a screen is presented containing a summary of information about reports related to the selected island Hrgeris Inr selected Island UH NEN pss 0 DER eyes 700000 eosam report Melanesia Epron usta 10 BGS SOPAC Vanuatu Mineral Resources Database e Reports by Company very similar to the above except that a company name is selected prior to running the query Heports het Fela LOM pany npe ES pessm LL az eoe ums Tirante Fite e Company Activity a summary of all prospecting licences is given for a selected island and company alenasia Belo on Aelia Lid BGS SOPAC Vanuatu Mineral Resources Database e Licences by Company a summary of prospecting licences is presented for a selected company Priapecting Lienert saaacisded with Camparny associated with Company e Licences by Island a listing of licences by selected island is given Hra ip ECH l li RFS Bae wath lalang Prospecting Licences associated with Island 12 BGS SOPAC Vanuatu Mineral Resources Database e Samples by Island a listing of samples located in a selected island is given nee pees by seed In the instance that no rec
10. anuatu Mineral Resources Database Prospect Licence Prospecting Licence Display related Sangles E Find n F Prospecting Licence No 1405 Licence location Fatmalapa Date Applied For 3 Oct al Company ID Melanesia Exploration Australia Lt Island Efate Date Granted 15 Fehb 81 Licence Fee VT 100 000 00 Date Fee Paid 5 Nas 8t Longitude Latitude t Fee Paid VT 100 000 00 Outstanding VT 0 00 gt 168335 17 54214 16842003 17 54339 Date of Relinquishment 16 Feb 83 Fehb 83 Application Renewal Appt 168 42705 17 65369 Minerals Sought T Reese 168 33368 17 63229 m A E Reports associated with Prospecting Licence Remember that when information about Prospecting Licences has been entered a record has to be made of which Reports relate to each Prospecting Licence This association is perormed by picking related Reports from the Report ID list Ifthe repart does not appear in the listthen its details must firstly be input on the Repon torm To wiew futher information on am Report click the plus button Report ID Report Title M sPeeep e 2 2 3 Sample Information This is usually collected from within company reports on an area and provides data such as the longitude and latitude of the sampling site the type of sample taken e g stream sediment rock chip etc and often the results of element analysis 5 Sample Details Sample Details Press thes bution
11. at the right hand side of the screen or horizontal appearing at the base of the screen Security A set of features used to specify or restrict the access that specified users or user groups have to data and objects in a database Source Each form report query and every individual field on each of these objects has this property referring to which underlying table or part of a table its data is derived from Switchboard The initial screen that the user is presented with after logging onto the Vanuatu Mineral Resources Database It is from this screen that they navigate their way around the system Tab Order The order in which the cursor moves from one field to the next on a form on pressing the Tab or Enter key Table The fundamental structure of a relational database management system In Microsoft Access a table is an object that stores data in records rows and fields columns The data is usually based on one particular category or entity Text Box A control that provides a place to enter or view text in a form or report Validation Rule A tule that sets limits or conditions on what can be entered in one or more fields Validation rules can be set for a field record or control on a form The rule is checked when the focus moves from one field or control to the next Microsoft Access displays a different message whenever the rule is violated Wizards A Microsoft Access tool that asks the user questions and creates a
12. ay be misspelled you may have omitted the equal sign before the expression or the source itself may have been deleted Other causes include the following The field name may not match the name of a field in an underlying table or query A control may have the same name as one of the fields in the underlying table or query An expression designed to calculate a sum for a control might include a Sum function which can be used to calculate sums for fields only not controls Error Microsoft Access can t evaluate an expression used Deleted If you are working on the database at the same time as somebody else this is the message that is displayed for a record that no longer exists because it has been deleted Custom Messages These depend on the underlying validation rule in this e g Value must be either Appl initial application case the data that can be entered into this field is Renl first renewal or Ren2 second renewal restricted to one of three values 2 4 Queries There are a number of different queries set up for use in the database which are easy to run and require little input from the user These are summarised below 2 4 1 Sample Locations On clicking the button a screen appears displaying a location map of Vanuatu and its main islands There are four boxes into which maximum and minimum values for latitude and longitude can be typed in When done on clicking the button marked Sample Sites a screen ap
13. dth of the prospecting licence is also noted The First corner of the prospecting licence is centred on the figure and its coordinates are 217073 3287E 8058484 422N Please Enter Easting Northing Origin Point 221638 4 8057001 14 207073 3287 217073 3287 22 073 3287 Easting 8068484 422 8058484 422 Vertical side Horizontal side 8048484 422 Northing Use Geographic Calculator to Convert Universe Transverse Mercator Geographic 39 Bellevue 3 World Geodetic System 1984 Zone 59S Zone 58S Depending on whether the corner is NE SE SW or NW we will consider the lower left upper left upper right or lower right rectangle to calculate the coordinates of the prospecting licence boundaries These coordinates will be reported on the first spreadsheet as East1 North1 to East4 North4 The first point Eastl Northl is always the upper left point of the selected rectangle The other points are taken clockwise 3 1 3 3 Transform to WGS84 co ordinates PL ID APP REN Origin Long Origin Lat Zone Easting Northing East1 North1 East2 North2 East3 North3 East4 North4 1405 APP1 168 22 40E 173322S 59S 221638 4 8057001 14 217073 329 8058484 42 227073 329 8058484 42 227073 329 8048484 42 217073 329 8048484 42 1406 APP1 167 13 E 1605S 58S 737126 11 8220554 22 735226 11 8233845 12 745226 11 8233845 12 745226 11 8223845
14. es entered in the data entry form in Access Maplnin 9 Ele Edi Qhjecis Query Table Og ono Window Mee Heip ORGLE ee ial Samples entry Gevced Samples Smp Licences VAHUATU Map Agire Lei s 19 BGS SOPAC Vanuatu Mineral Resources Database 3 2 How to enter the Reports Each report entered in the database should be cross referenced to any related prospecting licence numbers It is recommended that a label displaying the Report Number be used on each report with a red dot marked on it to confirm if the report has been cross referenced with the relevant prospecting licence numbers in Access A green dot should be used to denote that all the samples described in the report have been entered and referenced in Access Maplnfo 3 3 How to enter the Samples 3 3 1 Entering data in the Samples Form From the report the sample data is entered The operator should ensure that the Sample ID is based on the Prospecting Licence ID plus the Sample number given by the prospecting company For example Prospecting Licence 1404 and Sample Number 333 would combine to form Sample ID 1404 333 The geodetic coordinates of the sample should be entered if known otherwise the Latitude and Longitude fields on the form should be set to zero 3 3 2 Locating the Samples On selecting the Samples entry command from the Minerals menu in MapInfo the operator works on the Sample Table in Read Write Mode A browser corresponding to the Sample
15. las related Senes IB Find n F Prospecting Licence No 1405 Licence location Fatmalapa Date Applied For 3 Oct al Company ID Melanesia Exploration Australia Lt Island Efate Date Granted 15 Fehb 81 Licence Fee VT 100 000 00 Date Fee Paid 5 Nas 8t Longitude Latitude t Fee Paid T 100 000 00 Outstanding VT 0 00 a do Jor M 168 42913 17 54339 Date of Relinguishment 16 Feb 53 Application Renewal Appt 168 42705 17 65369 168 33368 17 63229 S UU oMEI 3 iu Reports associated with Prospecting Licence Remember that when information about Prospecting Licences has been entered arecord has to be made of which Reports relate to each Prospecting Licence This association is performed by picking related Reports from the Report ID list Ifthe report does not appear in the listthen its details must firstly be input on the Report form Ta view further information on any Report click the plus button Minerals Sought Report ID Report Title Folder Number C KA e a C C C 3 1 6 Rebuild in MapInfo Prior to clicking the MapInfo button on the Main Screen the Operator must ensure that all data entry forms have been closed This is because data cannot be updated from MS Access and MapInfo at the same time The user then selects the Rebuild command from within the Minerals menu The polygon representing the particular Prospecting Licence area is then rebuilt based on the coordinat
16. le a Prospecting Licence is an Entity something that information is stored about and an example of one of its attributes would be the Prospecting Licence Number Bound Control An object on a form or report whose contents is based on a field in an underlying table or query Command Buttons A button on a form that carries out a certain function for example all forms in the Vanuatu Mineral Resources Database have a Close button Some forms have other buttons on them that open other forms Caption The name that is displayed at the top of a form or report window or the label of a field on a form Check Box A control on a form that stores a Yes No value For example the Report Form has check boxes on it in order that the data inputter can record whether or not a report contains maps or field notes etc When checked a cross appears in the box which is stored as a Yes Combo Box This is a scrolling list of values that the user can pick from when inputting data and its advantages are similar to a List Box except with many Combo Boxes the user can input a new value if the required one is not already in the list Criteria A set of limiting conditions used in a query to restrict the output to a specific group of records For example many of the queries in the Vanuatu Mineral Resources Database require the user to select a value from a list prior to running their selected query Data Type This determines what kind of values
17. n object according to his or her responses for example tables queries reports forms and controls on forms such as buttons and combo boxes can all be created quickly using Wizards 25
18. or is used to convert the reference point from one projection to another In the old style form the geodetic Longitude Latitude coordinates for the reference point are determined and converted from Geodetic Bellevue to UTM WGS84 17 BGS SOPAC Vanuatu Mineral Resources Database If the reference point is sited on the new map series conversion is from Geodetic WGS84 to UTM WGS84 3 1 3 2 Compute boundaries The spreadsheet below shows the data entered for a given prospecting licence e g 1405 registered in the old form We convert the reference point Origin Long and Origin Lat to Northing Easting in UTM WGS85 Zone 58S or 59S PL ID APP REN Origin Long Origin Lat Zone Easting Northing East1 North1 East2 North2 East3 North3 East4 North4 1405 APP1 168 22 40E 173322S 59S 221638 4 8057001 14 217073 329 8058484 42 227073 329 8058484 42 227073 329 8048484 42 217073 329 8048484 42 1406 APP1 16713E 1605S 58S 737126 11 8220554 22 735226 11 8233845 12 745226 11 8233845 12 745226 11 8223845 12 735226 11 8223845 12 1407 APP1 16727 E 1621S 58S 7617436 35 8190751 19 7614436 35 8205947 34 7624436 35 8205947 34 7624436 35 8195947 34 7614436 35 8195947 34 We then use the spreadsheet below to compute the boundaries of the given prospecting licence We record t the coordinates of the reference point Easting Northing which have been previously computed as well as the bearing and distance to the first corner of the prospecting licence area The height and wi
19. ords exist for the set criteria for the query being run a message box appears on screen informing the user that no records were retrieved VMIAD Error Each query output screen contains a button that will print a hardcopy summary of the query results and a close button Some of the query screens contain a small button with a plus symbol if this button is pressed the user is shown additional information about the prospecting licence report or sample in question 2 4 5 Elements in Samples This button leads the user to another screen containing a list of elements and another list containing island names There are two query buttons 13 BGS SOPAC Ambrym Anaityum Anba Banks Mota lev Banks Santa Mi Banks Ureparay Banks sanua Li Efate Epi Erromango Maewao Malekula Pentecost canta shepherd Tanna Torres Aluminium ATSenic Gold Boron Barium Beryllium Bismuth Calcium Cadmium Cerium Cobalt Chromium Caesium Copper Iran Gallium Vanuatu Mineral Resources Database Element values Elements 3 Elements vs Island e Element for a selected element maximum and minimum ppm values are set and a query is run retrieving all instances of samples containing the selected element within the set range Note that 1 is a value assigned to an element that either has not bee analysed for the sample or if its value falls below the limit of detection Ha rM aM I umi Samples b
20. pears presenting information about samples falling into the selected area If the user does not set their own values for latitude and longitude default values are set which include the entire Vanuatu area On this screen are two buttons one to close the screen and the other to provide a printout of the query s current result BGS SOPAC Vanuatu Mineral Resources Database Min Long 166 Island samples by Min Lat Island Sampie Locetions wlihks Defined Area Sample Locations Fore ged lives deris the rmlkeecng samp kes heave tese rere Poo recard a tuned has n o earples hero been lourd In axi weihin he dened area Prospecting Licunca Ma i pie ii Irinnd I p h rie Longitude a uu TEL EIE JE 2 Lr 7 W Fr E F bt f EE J 33155354 E I ES 25273 a i 2 4 2 Companies Islands This button when clicked leads to another screen containing two lists and six query buttons BGS SOPAC Vanuatu Mineral Resources Database Sel query criteria then press appropriate button to view results Pursiper Resources ML Birmai du Aacher Gedog ai regi ERG Caso Fiera uncas Fry Lid bib Minas r Daha Goki mma Asse Pm rami ort Campagne Fran a ue Des Phosphates Da Octane tals A a CDs Sakai sient ant Compar Seleci s CDI Bet
21. rium value in parts per million ppm Caesium value in parts per million ppm Cobalt value in parts per million ppm Chromium value in parts per million ppm Copper value in parts per million ppm Iron value in parts per million ppm Gallium value in parts per million ppm Germanium value in parts per million ppm Mercury value in parts per million ppm Potassium value in parts per million ppm Lanthanum value in parts per million ppm Lithium value in parts per million ppm Magnesium value in parts per million ppm Molybdenum value in parts per million ppm Sodium value in parts per million ppm Nickel value in parts per million ppm Phosphorous value in parts per million ppm Lead value in parts per million ppm 21 BGS SOPAC Vanuatu Mineral Resources Database Pt Sb Sc Si Sn Sr Te L2 Zn Zr Minerals Number Platinum value in parts per million ppm Number Sulphur value in parts per million ppm Number Antimony value in parts per million ppm Number Scandium value in parts per million ppm Number Silicon value in parts per million ppm Number Tin value in parts per million ppm Number Strontium value in parts per million ppm Number Teryllium value in parts per million ppm Number Titanium value in parts per million ppm Number Vanadium value in parts per million ppm Number Tungsten value in parts per million ppm Number Yttrium value in parts per million ppm Number Zinc val
22. specting Licence boundaries based on the old form cccccceceeeceeeeeeeeeeeeseseeseeeeeeeees 17 3 1 4 Compute Prospecting Licence based on the current form sse 18 3 1 5 Entering Data in Prospecting Licence Access Form sees eene eene enne nnns 18 Sc D Ope MUI Map oadisc iste tdeo ded dh acb E ioc sentio ees snasuobate nial add aut Nensdusokogons Capra ada 19 5 2 How to enter the REDO EIS c ieeretec eee oreet ree Er he IE R ete eed 20 5 3 How to enter the Samples 5 deo ebe Eee Fa ees ir ze east o beer venae c aed u ve de dod E ee RR EET ous 20 3 5 P Enter dataa thessampbles DOLI ecodct eis oreet ima chapa bis teo dati nce os les oeo imul edo pal uu tesde eae bci ei Oria 20 3 2 2 Locatie he Samples x sorte Loreto te tel otis EspU dE Eee a esie da diode use a due odo MEN SP orP DR Op Qedede RU d pd qE 20 3 3 3 Geocoding the samples back to the data tables esssssssseeeeeeeneeeeneeeeeenenennnnnnnnns 20 4 RECOMMENDATIONS 1 1 erre leeclleclieeuiee eene enn ann n ana a a aaa a an aua mana 21 2 GLOSSARY OF TERMS carron a cune iecoNeE QN eee aUe aD e QU ORE oDa COO eS 23 BGS SOPAC Vanuatu Mineral Resources Database 1 Foreword This manual is a user handbook for the Vanuatu Mineral Resources Database VMRD As this system is based on Microsoft Access and MapInfo We describe here only how to navigate around the Vanuatu Mineral Resources Database VMRD
23. spreadsheet List Box This is a simple list of values that the user can select from instead of having to type them in The main advantage is that data will always be input correctly and consistently if a list is used Navigation Buttons In form view at the base of the screen there is a horizontal scroll bar containing buttons that are used to aid navigation through data ast record Go to next record Go to specific record user types which one in box shown o to previous record o to first record One to many Relationship A one to many relationship is the most common type of relationship in a relational database In a one to many relationship a record in Table A can have more than one matching record in Table B but a record in Table B can only have one matching record in Table A A typical example of this kind of relationship is that between Prospecting Licence and Sample in the Vanuatu Mineral Resources Database a Prospecting Licence may have one or more Samples associated with it but in order for a Sample to be stored in the database it must be linked to a Prospecting Licence One to one Relationship In a one to one relationship a record in Table A can have no more than one matching record in Table B and vice verse This kind of relationship is unusual but an example might be of a database containing employee salary details with one table containing personal details such as name and address etc and the other table containing
24. ted 15 Fehb 81 Licence Fee VT 100 000 00 Date Fee Paid 5 Nas 8t Longitude Latitude Fee Paid T 100 000 00 Outstanding VT 0 00 a do Jor M 168 42913 17 54339 Date of Relinguishment 16 Feb 53 Application Renewal Appt 168 42705 17 65369 168 33368 17 63229 S UU omME 3 QW Reports associated with Prospecting Licence Remember that when information about Prospecting Licences has been entered arecord has to be made of which Reports relate to each Prospecting Licence This association is performed by picking related Reports from the Repor ID list Ifthe report does not appear in the listthen its details must firstly be input on the Report torm To view further information on any Report click the plus button Minerals Sought Report ID Report Title sFeesp 169 D LLL 2 2 2 Report Information Following the issue of a prospecting licence a company releases reports periodically which summarise work done in the licence area The frequency of these reports may vary but are often produced quarterly or annually Information about the report such as its title the island it refers to contents etc are stored on this form There is also a facility for the user to view which prospect licences a particular report relates to Information about which reports relate to which licence is recorded on the prospecting licence form which is then automatically visible on the report form BGS SOPAC V
25. the person s name manager and current salary in this instance there would be a one to one relationship between the two tables Query Queries enable the user to retrieve data from their database that matches certain conditions or criteria the data that is retrieved depends on the structure of the query Queries are an efficient way of viewing related data from several different tables at once Read only In the Vanuatu Mineral Resources Database the results of queries are all set to be read only meaning the data cannot be altered but only viewed on screen Record Selector Within a data entry form the left hand side of the form often has a small box containing different symbols denoting the status of a record in the database i e Record that is currently being viewed which has already been saved New Record Record edited but not yet saved changes can be undone by pressing Esc lel dili Record being edited by another user 24 BGS SOPAC Vanuatu Mineral Resources Database Relationship An association between common fields columns in two tables For example the Prospecting Licence and Sample tables are related on Prospecting Licence ID PL ID Report Output of data from a query or table in Microsoft Access in document form Scroll Bars A typical Windows style control which aids the user to view different parts of the screen or navigate their way through a combo box Scroll bars can either be vertical appearing
26. to view or enterminerels found inthe curer vsmpis S v eU a i E az Prcipecme Licgsecae Mo nih Hame 5mmpnie Type Ean niin et erry EDU TDI Ag a 1 Ag a w a Bel Boel 3 Bey 1 Gel 1 oe do Cel 1 Col 3 Cel 1 Cuf Fef ao Baf J C Rey cobe i Lie i af i Mol so Naf i f i Pl a 1 Pel a gel a a a eel a Ta sox a a a a mel 3 ef Ce Gel i Gel i Amel i Bel i Sef 4 amp l a Wl Zo 4 Mjaa fot BGS SOPAC Vanuatu Mineral Resources Database The button at the top of the form allows the user to record minerals present in the sample if any sample Minerals Sample Minerals Enter minerals faund in the current sample Mineral Name 2 3 Features to note on Forms 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 line of data is put into one or more underlying tables Status Bar If the user is not sure of what to enter in a field the status bar at the base of the screen will display the definition of the field that currently has the focus 1 e which box on the form contains the cursor Navigation buttons these help the user to move or navigate through the records Other Buttons these are usually located at the top right hand side of the screen Different symbols mean different actions e g closing door means close
27. u Min tial AHeaouricea Database Sehihbhiasrd Vanuatu Mineral Resources Database ming admin 140ar 195 Data Entry Queries Utilrties mm Prospachng p Sample E Mapinfo Report Companies Change i Islands Password Sample CNN EJ Profs D ve a Full Access e 2 2 Data Entry Data is input via a series of entry forms Data stored falls into three broad categories prospecting licence information report details and sampling data Each of these three categories has a form through which data is loaded into the database and these are described below 2 2 1 Prospecting Licence Information This is the first information to occur in time sequence a company firstly applies for and receives a Prospecting Licence and information appearing on the prospecting licence document such as the name of the company holding the licence date of issue details of the prospecting area etc are recorded After information relating to reports written about the prospecting licence has been input the user can cross reference which reports relate to the licence by picking from a combo box on the form in the section named Reports associated with Prospect BGS SOPAC Vanuatu Mineral Resources Database Praspect Licence Prospecting Licence Dips relaten Samples EB eco i Prospecting Licence No 1405 Licence location Fatmalapa Date Applied For 3 Oct al Company ID Melanesia Exploration Australia Lt Island Efate Date Gran
28. ue in parts per million ppm Number Zirconium value in parts per million ppm Memo Minerals found in samples e tis recommended that the prospecting Company provides their sample data in the format above on digital media MS Excel preferred All coordinates must be given in Geodetic W GS84 The Land Survey department should supply a MapInfo layer including the Vanuatu coastlines in WGS84 to the Department of Geology as soon as the islands have been surveyed The Land Survey department should supply a MapInfo layer including the Vanuatu Drainage lines in WGS84 to the Department of Geology as soon as the islands have been surveyed A Maplnfo interface should be developed to ease the use of the display capabilities of MapInfo and to enable the production of thematic maps from this part of the system just as data reports are produced from Access This work comprises Phase 2 of this project as previously stated e tis recommended that a label displaying the Report Number be used on each report with a red dot marked on it to confirm if the report has been cross referenced with the relevant prospecting licence numbers in Access A green dot should be used to denote that all the samples described in the report have been entered and referenced in Access MapInfo 22 BGS SOPAC Vanuatu Mineral Resources Database 5 Glossary of Terms Attribute Term used in database design to describe different pieces of information about an entity for examp
29. umber Sample Type Text 10 Ag Number Al Number AS Number Au Number B Number Ba Number Be Number Bi Number Ca Number Cd Number Ce Number Cs Number Co Number Cr Number Cu Number Fe Number Ga Number Ge Number Hg Number K Number La Number Li Number Mg Number Mo Number Na Number Ni Number P Number Pb Number Width Description Unique Identifier Prospecting Licence Number Sample Number e g PL122 236578 Unique Identifier assigned sequentially for each prospecting area e g PL122 Company Sample Number eg 236578 or 236578a Island name where the sample was taken Location Name where the sample was taken The names of the minerals found in the sample e g pyrite Laboratory Identifier for the sample analysis Field Notes General geological comments relating to the sample Other comments and additional information e g sampling quality analysis precision etc Sample longitude in WGS84 Sample Latitude in WGS84 The sample category e g Rock chip stream sediment rock float rock channel sample etc Silver value in parts per million ppm Aluminium value in parts per million ppm Arsenic value in parts per million ppm Gold value in parts per million ppm Boron value in parts per million ppm Barium value in parts per million ppm Beryllium value in parts per million ppm Bismuth value in parts per million ppm Calcium value in parts per million ppm Cadmium value in parts per million ppm Ce
30. y Element value Element tor whet rage was delined Pimpa Sample IL Licenca Ho Semple o Amnhyticni Method Smmpnim Type 141H Ip AMC Ale pipipon Speci e Elements vs Island for a selected island and element all samples are retrieved fulfilling the criteria 14 BGS SOPAC Vanuatu Mineral Resources Database samples by Island and Element Fie Samples by Island and Element f ie As with other queries each of the output screens contains a report button and a close button 2 5 Reports As seen from the above section reports are a neat way of presenting the results of a query in hardcopy format Each of the above queries has a report facility attached to it On the Switchboard there are three further reports that have been set up for use e Licences Company provides a listing of all prospecting licences stored in the database grouped by company name 15 BGS SOPAC Vanuatu Mineral Resources Database Mic iic EM Lampany Vamuara Micra Fesewrces Date Licences by Company Thus summary Lists all Prospect Licences both past and present grouping them by Company ee Company Manse Tskund Licence Lexatim FLID Application Renewal Granted Date Re Melanesia Fatmalapa Exploration Australia Ltd Melati sia bdalaicula Malus Bay App Lex zs Pent At Exp koratin Australia Ltd Melati sia tanc Ap Dex Mel 15005 Exploration e Licences Island provides a listing of all prospecting licences stored in the
Download Pdf Manuals
Related Search