Home

NTFP Database (Version 1)

1. Lao and English telephone o ont eee fax e mail Address Joint venture I Foreign company The Actors form also keeps Province E O Languages Spoken Phone 031 212494 530193 r b Ene paaa SC Lao Japanese Other Language E n e about ba ee aa type of NIFP activity the Vietnamese 7 French Other Language L YP es y n Chinese German T person is involved with ae z ai szen A gt isd aang Record 14 4 1 gt ril of 74 researcher administrator a ete collector trader Stat Tinstaniaccessocn CINIC Database E Microsoft Access A EPaintShopPio E sa manufacturer cultivator and what type of organisation they are with government NGO Project educational institution private or public company etc The languages spoken by the person is also recorded if this is known Viewing Records Set Remove Filter As with the other forms you can find groups of actors by using the Set Filter Set iter button For example if you wanted to find all government people working with NTFPs click the Set Filter button The form is presented empty and the Filter toolbar is shown on screen Just tick Lao Government in the Organisation box then click the Apply Filter button on the filter toolbar The forms for all Lao Government people are selected They can be viewed by using the record selector buttons at the bottom of the screen The 2 total number of forms for this group of people is also shown with th
2. The database has four major sections LIBRARY catalogue of books newsletters reports videos CD ROMs held in the NIC library or other libraries in Laos or abroad SPECIES List of species recorded in Laos with local names scientific name English name taxonomic climatic geographic amp distribution information NTFPs Products created from species with socio economic information such as harvesting processing management and marketing information ACTORS Information about people and organisations active in the NTFP sub sector categorized by type of activity researcher trader teacher administrator and type of organisation government private project NGO The good thing about putting all these different types of information into an information system or database is that they can be viewed together in all sorts of ways For example from a card for a product you can go directly to a list of all the library resources about that product or the species that it is made from Or you can get a list of all people and organisations with an interest in that product The two most important sections are SPECIES and NTFP As well as the links to the LIBRARY and ACTORS these parts also have subsections for QUOTA and TRADE statistics 2 Printed on 19 09 05 NIC NTFP Database User Manual The LIBRARY also has subsections One for managing loans from the NIC Library and one for Internet or WWW addresses for international NTF
3. been included for your use Making a new record Use the New Record button on the Record Selector toolbar at the bottom of the screen to create a new blank form See The Record Selectors on page 10 Species ID Number The Species form is the only one where the operator must make a new ID number All other tables in the database have automatic numbers This is because the Species ID is based on the character of the species and uses a special code The code has two or three letters at the beginning followed by numbers Eg BB001 is the first bamboo species entered The code works like this The first letter is either B botanical or Z zoological The second letter and sometimes the third identifies the character Eg BT001 is the first tree entered 12 Printed on 19 09 05 NIC NTFP Database User Manual The numbers are in order of entry Knowing what code to use and what is the next number is a special problem when entering a new species To make this possible the Last ID Number button is beside the Species ID Field Last ID Number Clicking the Last ID Number button will display a box asking you to select the character of the new species eg Wildflower then show the last ID number used for Wild Flower a this character In this example the last wildflower ID r Bamboo Rattan number was BW432 Close the box and make the next a Climber wildflower ID Number BW433 Insert Photo Photo Links to photographs can
4. wai te KIRE NEW LOANS CANNOT BE ADDED ON THIS SCREEN and changes to the current card cannot be made also Use the RED labeled buttons to add or edit cards The Edit card This much simpler form is used to nominate the person Actor and the library resource being borrowed Use the pop up menus to select the Actor and the Resource Fill in the other details View Details takes you back to the Details card for this record This is usually the best choice View all Detail Cards take CEE 7 A OO ES oE E Bie Eat View Insert Format Records Tool Window Help 8 8 00 8eGea M BY YuExvrm BBO xr 3 Be Y E ee e E Microsoft Access Eien shopPo Record 14 4 Astart AINIC Database w 2 sirilo 2 icrosoft Word NTFP you back to the full set of Loan cards You will be at the first record Not the record for this card Take note of the record number if you want to get back WWW Form World Wide Web WWW or Internet Addresses are kept separately in the WWW form It is opened from the database Map Use Set Filter to find an address 10 NIC NTFP Database User Manual Species Form The Species form is used to record information about the living plant or animal As well as names Scientific English Lao and other local names which could include Vietnamese Thai Chinese etc the Species form hold descriptions habitat amp environment informati
5. Printed on 19 09 05 NIC NTFP Database User Manual Using the Forms Library Form F eQrosolt Access LIBRARY REFERENCES APICES Nl Ove ales PETES EB Bile Edit View Insert Format Records Tool Window Help lel x 2aa S Rl OH eaaeGa M OY YRxyr sm BBO eK The Library form gt contains entries for _ library references and 2 Commerce Internatioonal9091 Yolurme II resources books newsletters reports CD ROM Video etc Not only are the NIC resources listed but also resources from other libraries in Laos and abroad O Add Media m 1 gt ou gt of 157 Form view a el ae eet ee Astan NIC Database EJ Information Sheets IZ Microsoft Acc Screens Eil Paint Shop Pro 3608 on To search the library use rena seis the Set Filter button You can then ask for a title or author or subject etc For more information on using the Set Filter see Set Filter Remove Filter on page 11 Adding a new record Use the New Record button on the Record Selectors at the bottom pmeremmmi of the screen This will create a blank form ready to be filled in The FIOM cs TAB key will take you from field to field 2 Thai 3 Vietnamese 4 Chinese Some fields have pop up lists to make entry easier and more accurate 5 Japanese 6 English 7 French 8 Russian On the Library form these are Language Library amp Media Type Notice the arrows If the entr
6. Realistically even after ten years of information collection there will still be substantial gaps Most of the information in the database so far is scientific lists of species taxonomy The database wants lots of economic trade statistics prices and socio economic harvesting processing management amp marketing information One record in the database could end up being as large as a university thesis The information collected so far is minimal However when printed it is more than 500 pages Version 1 will not be widely distributed and should be regarded as a pre release or beta version As it is used over its first few months it will need modifications corrections and additions Future versions will combine ever increasing information and improved functions Comments and suggestions are welcome Bill Fisher Information Management Consultant 1 Printed on 19 09 05 NIC NTFP Database User Manual Overview Microsoft Access Enter Edit Browse Menu Form Rep B27 SS So BD SE ej k f x EE Ele Edit View Insert Format Records Tools Window Help l x m E amp lpas X H FXT rB em Database Map el _ViewEngish Select the information you wish to view or edit o wano pe LIBRARY References Problems Form View a ie a a AStart ANIC Database Norton System Do i Microsoft Acc WY Microsoft word Ei Paint Shop Pro ENG A 231
7. attendees for this workshop Agencies Form The Agency form IR EXtrosoft Access AGENCIES SAUER Eee ED ES B File Edit view Insert Format Records Tools window Help 18 x keeps details about CELE loaf Mae Y ax a BB em the involvement of NTFP Agencies Agency in Laos 7 different organisations sos T saree O p rojects NGOs Agency Name Non Timber Forest Products Information Centre Remove Fiter i f Lao Name aguiyuanandoa soi Government Agency Te 2 3 Phone 732282 C i i S Educational r e e Institutions re gt Address dn ee Forestry Training gudngz wda tines businesses in NTFP z activities t is extra Description information to what is kept about an actor Project descriptions can be stored here Record a 4J T gt our of 9 E er Sl 7 a al A Start 5 Instant Access OCR ANIC Database BF Microsoft Word NT IQ Microsoft Acces ij Paint Shop Pro ig 15 35 Buy amp Sell Forms The Buy and Sell forms can be used to record actual prices from traders This information is collected by survey The form works the same as other forms Red labeled buttons for editing information and blue labeled buttons for moving around and viewing lists S e Ce a tl Te ME Ca al al 3 METIE ty os es Pat me eae oe eee aaiaglongel var lynx Al 7 re HEEE i eue ai 0Glomgelx wy vax al uy SELA Buying NTFP s of ids oE Praha
8. buttons with red labels are for use with text editing USE THE RED LABELLED BUTTONS TO ADD SPECIES ID AND NTFP ID Using these buttons help to locate the correct species or NTFP ID They also transfer the names for the species or product to the fields at the top of the screen If you do not use the red labelled buttons these fields have to be typed by hand Viewing Quota Information The Quota for is not the best way to see the quota information The blue labelled buttons provide two ways to view the information 16 Printed on 19 09 05 NIC NTFP Database User Manual View all Quotas for this R Srosott Access ISpecies Quota List EESE ET ele GIES Spe ciles File Edit Yiew Insert Format Records Tools Window Help l x m as Daea X H YeExivem Ben x i jes form o Clicking this button will Quota n ma i Product Name E Rattan wai thon show a list of quota P n L baa O Scientific Name Calamus sp 1 i j English Name Rattan Large diametre Quota Form information for the species gish Name Faten Lapedanetey J Gustarom _ Quota Records shown in the current Quota ID Year Period Pname Quanti d gt 1995 1995 96 Luang Namtha 15000 Pole 2 1997 1997 98 Bokeo 10000 Pole record E 3 1997 1997 98 Xayaboury 10000 Pole 4 1997 1997 98 Vientiane 50000 Pole hi ij 5 1997 1997 98 Special Region Xaysomboun 50000 Pole From this list you Can use 6 1997 1997 98 Bolikha
9. in both Lao and English This is possible where the entry can be made from a standard list like Character Soil type etc Sometimes the list does not have the entry needed If this happens just click the Add button beside the field This will open a table containing the list Add the new entry in Lao and English at the bottom and then click the Return to Last Form button at the top of the screen Your new entry should now be on the pop up list ready for you to use If it isn t choose Refresh from the Records menu 13 Printed on 19 09 05 NIC NTFP Database User Manual Add Reference for this Species The species can be linked to many references in the Library To adda reference click the Add Reference to the Species button This will take you to a screen for selecting the reference from the library by its Title or author etc Type the first few letters of the title in the Title field then check the pop up list to make the final selection from the library list When you have selected the reference title click the top button on the toolbar shown Title Author l Manual of the bamboos of Lao PDR This will transfer the Species ID and the Library reference to a NIC Reference Title select the reference title then click gt form for linking Species and dl new itis ka Referees brary References Cancel and return to species form gt R Just add Chapter Name and Page Number if necessa
10. is your last back up copy You will be asked if you want to replace it The answer is YES Maintaining amp Changing the Database General users do not need to know any more than what is in this manual Some NIC staff responsible for the database need to know more Technical information about the database is contained in Part 2 of the NTFP Database Manual 33 Printed on 19 09 05
11. x e AA mm Y selin 7 BY SRK wm BBm I D at ab ase p AutoCorrect 2 Relationships Just by using the E ae r database the database WWW Security Compact D s Replication gt Repair Database Agencies will grow in size After a P Make MDE Fie Run Macro just one or two hours sles NTEPs ACTORS Ay ActiveX Controls ES the database might be g hs fs Options i z 1Mb larger than when EE S E a you started even if you References Problems 09 05 Database Utilities Gonvert Databaser Form View SS ae A Start Instant Access OCR Sy Manual BY Microsoft Word NT IQ Microsoft Acces gj Paint Shop Pro q 13 53 NIC NTFP Database User Manual havn t entered new information This is because the database makes temporary files while it works If these files are not cleaned out frequently the database will become very large This should be done before making a copy for back up From the Tools menu choose Database Utilities then Compact Database This will take about 30 seconds After it is finished Exit from the database Make Back up copy After closing the database select it s icon and choose Copy from the Edit menu Open the Backup Folder and Paste from the Edit menu You will be told that a file with the same name already exists This
12. Microsoft Access Main Menu N07 gt e SER E Eile Eait View Insert Format Records Tools Window Help 18 x Aaa theqdazenay ai Sy ual ua Uy utmenasendy What is an NTFP Database Manual NIC Database S oe oe pp N Pete G 4 af BE f 4 a MOJE E ai i aie T ih 4 r y Non T WNoeT ror C a a a VILIA CENIL Chu Teusuu we anausiusn i pi a J AHAAA 3 ba y Make a Query big Print a nauiuan Juonen eport Form view Num A Start EANIC Database z Norton System Do BF Microsoft Word Microsoft Acc A EJ Pro BOB 2220 H 22 20 Non Timber Forest Products Information Centre NTFP Database Version 1 User Manual Part 1 Using The NTFP Database February 1999 Forest Research Center National Agriculture and Forestry Research Institute Funded by the Government of Austria Implemented by CARE Austria amp CARE International in Laos The NIC thanks the following organisations and people for their assistance with the development of version 1 of this NTFP Database Forest Research Centre Department of Forestry Lao PDR CARE International in Laos Government of Austria Jenne De Beer Bert Jan Ottens PROFOUND Consultants in Development Bandith Ramangkoun Vongvillay Vongkhamsao Bill Fisher Bill Fisher Vongvillay Vongkhamsao Bandith Ramangkoun Vongvillay Vongkhamsao Bounhong Pathamavong Kantamily Chanthalangsy Dr Bou
13. P information The ACTORS part of the database includes subsections for recording reported problems and suggested solutions recording trading and project activities and a management system for organizing workshops and seminars The database is bi lingual Lao amp English This means that the information held in the database has been translated into both languages and database reports can be made in either language It also means that the user can use the database with either Lao or English language screens If you ask for a report from a Lao Language screen it will produce a Lao language report and visa versa Starting Up the Database Where is the Database The Database is called NIC Database Replica and a number or NIC Database Master and is always stored in a folder Directory called NIC Database The NIC Database folder is always at the top level of the directory for the C Drive on your computer Opening the Database The database can be opened in any standard manner for opening a computer file You can double click on the icon or use the Documents command on the start menu As the database is opening the Log on screen is displayed You need to identify your user level and if necessary enter the password If you want to view the records see queries and reports but do not want to change any s c information use the name NIC and do not ERR Cancel enter a password The database wi
14. Special Note on Leaving Word Exit Word when you have finished Cancel the Logon box and then maximise MS Access from the status bar at the bottom of the screen 25 Printed on 19 09 05 NIC NTFP Database User Manual Workshops Form The Workshop form keeps information about workshops seminars and conferences relevant to the NTFP sub sector It can also be used as a management tool for organizing workshops 2 Rosat Access WorkshopsSeminense URE Cs ETSI Parl Es S File Edit Yiew Insert Format Records Tools Window Help l x mgt aRAI Tm napa X HYIYxX Albeo Lm When Actors are linked to EAEN the workshop use red labeled Link Actor to this zee Workshop Name E NTFPs Gaps in Reseach O jE Workshop button Workshop Name S f Date Start 237 02 55 stationary such as lists baerne labels envelopes amp letters o can be cr eated easily Details E PPE yahan including all organisations conducting NTFP research and activities Make Stationary Mail Labels Make stationary by clicking the Make Stationary button Details L Envelopes Addressed Letters Make Stationary Name Cards Desk Cards This displays the Stationary z Record I4 lt 1 Db bETb of 2 menu as shown on the a Ti eT previous page The process Astin Eiren awicoat my wiciess amp micio Erang SGMicise Gresa ser ce fi i519 is the same as described on the previ
15. TFP ID TO THIS m FORM As well as finding the correct ID for a product it will bring both the Lao and English name for the product into this form It is quicker easier and more accurate than entering this information from the keyboard mEt RAITI aapa ay 6x ie NTFP ID Product Narne L Product Name E After clicking this button you will be offered a list to choose the product by either Lao or English names When you have made your selection click the ID button on the toolbar This will transfer both the NTFP ID and its _ names to the Trade form D choose NTFP by Lao or English name E 1f NTFP not listed add new NTFP x Cancel 21 Printed on 19 09 05 NIC NTFP Database User Manual Actors Form Deora Access ACTORS Form TEN IE Eee Bale The Actors form keeps S File Edit Yiew Insert Format Records Tools Window Help x at b l ortig ena M OY Bx TH BEO rem information about people ISAS shes gt v BH O i i gt R her Administator Collector Manufacturer JU Links to working in the NTFP sub NTFP Actors P scoxi0 a Worksho sector ere WERE Organisation ae jo Gim a I Lao Government a The Actors form keeps cesten i ger p osition L Project Remove Fiter Filter names and addresses in both ae Organisation Name E Branch of Salavan promotion export Co ltd lucation Institution td Marked pee Private company Organisation Name L Mawniiudeseenmmsu
16. ach page Viewing NTFP records Use only buttons with blue labels to view the records Buttons with red labels are only used when entering information You may use the record selectors at the bottom of the screen to move through the records see The Record Selectors on page 10 or the Set Filter button to select a name or group see Set Filter Remove Filter on page 11 Information Sheet All information about the current product can be printed as an Information Sheet by clicking the Information Sheet button There are two steps Read Information Sheet on page 19 The steps are the same as with Species Information Sheets There is also some other important information about information sheets on this page 18 Printed on 19 09 05 NIC NTFP Database User Manual View all references for this NTFP As with species NTFPs can be linked with library references These links can be viewed by clicking the View all References to this NTFP button Editing Records If you are adding a new record or editing existing records the buttons with red labels have been included for your use Making a new record Use the New Record button on the Record Selector toolbar at the bottom of the screen to create a new blank form See The Record Selectors on page 10 Find Species ID All products are linked to the species that they are derived from To do this the Species ID must be entered on the NTFP form The Find Species ID button is n
17. ao aa eo E E E Choose by product in English d ne i Ea 10 das aju ita 15000 E pe a Choose by Province in Lao ea t O O S T Fcc e E E eae ee Ge ao Choose by Province in English 4 PPh List Lao e A E ae Province Lao by Province Endish Is Select the view required by choosing from the worksheet tabs at the bottom of the screen If you wish to make any changes to the layout or format of the tables select the table Copy open a new workbook Paste Special Values This will make a new table not linked to the database and it can be formatted or changed You can save this version to a new file name 17 Printed on 19 09 05 NIC NTFP Database User Manual NTFP Form The NTFP Form or Products Form records information about products produced from the forest The products are linked to the species that they come from Most of the information about products is socio economic rather than scientific The NTFP form has 4 screens 1 Product information such as name species description use and part of use a ales tL let mjas GET T Record tw J L Jet fee of 58 Form view ae E ae Waster ac peste Sy Merce weed NTFPO E Microsoh Access 1 EPa om aconk whi T aeije of sA ew E sel e a EA 2 Market information 3 Processing information 4 Management information The four screens or pages can be accessed by clicking the buttons on each page or by pressing TAB in the last field of e
18. appear when you are making a selection for a Query or Report Their purpose is to give you a way of finding a record or group of records For example finding all species with character tree or NTFPs with use medicinal When you click the Set Filter button the screen changes to blank fields NIC Filters ES New buttons Clear Grid and Apply Filter appear X Clear Grid SF Apply Filter Type into a field what you are looking for eg Scientific Name or Lao Name As you type the filter will try to guess what you are typing by taking you to the closest match If the field is a tick box such as commercial just tick the box When you have entered the criteria for what you want click Apply Filter A subset of records that matches your criteria will be selected for you to view Note that the number of records displayed in the record selector is less than before It shows you how many have been selected for you The Clear Grid button can be used before entering your criteria Any criteria still there from last time the filter was used will be cleared It is a good idea to always use this button first Using the Remove Filter button will display all records again On Line Help On every screen there is on line help This is shown by the question mark button It is used whenever some extra instruction may be needed for a button or feature Clicking this button will take you to the section of this manual covering the topic 8
19. at Records Toots Winds ap PTT TET aMaule olog g SO rer HIFPs ACTORS a oe Beale 7 Hit Daata Hinor Ac Bafom Soho am The Query Control Panel offers a choice of pre prepared queries that can be made as well as the opportunity to make your own using the Query Wizard The pre prepared queries are available from the buttons There are four types 1 Standard lists 2 Lists with choices 3 Custom Lists 4 Information sheets Standard Lists These are simple Just click the button and the list is displayed You can print this list Maybe you will need to use Page Setup to make a wide landscape page so the information will print on one page wide The standard lists are 28 Printed on 19 09 05 NIC NTFP Database User Manual NTEP NIC Library List Description All List Traders Full List Environment All Subsistence Manufacturers Loan List Commercial Local Cultivators Export Collectors Projects amp NGOs Government NGOs Businesses Lists with choice With this type of list you i DE R must choose what you want For example the Character query under Species asks you what character you want listed This is done by picking from a list then clicking the Apply Filter button The list is then displayed The lists with choices are NTEP Search References References NTFP Character Use Species Location Custom Lists These have been included so that you can choose what i
20. be inserted in either the Species or NTFPs forms The photographs are not stored in the database Many photographs would a make the database too big and too slow Instead the photographs are linked Insert Photo to the database from their separate folder called Database Pictures which is Double click the icon to inside the NIC Database folder view the photo The photographs are also not displayed in the database All that can be seen on the Species or NTFP forms are icons for the photographs Double click the icon to open the photograph It will open using Paint Shop Pro or PhotoShop software To insert a link to a photograph Nert Object IES OK 1 Click the Insert Photo button eas i cence e Click the Browse button to find and create from Ble ic database databasepictures bamt B T M Link select the photograph in the EEE a AAA Database Pictures folder m 3 Tick the Link and Display as Icon Result Inserts an icon into your document which bamboo2 ipg check boxes then OK fu afa represents the file The icon will be linked to the file so that changes to the file will be reflected in your document An icon representing the photo will appear in the photo square You should also read the section on preparing photographs for the database in Part 2 of this manual Adding to Pop Up lists Character Soil Type Forest Type amp Source Where possible pop up lists are used for easy and accurate entry
21. e record selectors Mark Unmark Records A special feature of the Actors form is that records can be marked This Ud Marked makes a group of people that you have marked easy to select using the Filter Marked records are also used for making envelopes mail labels Unmark All name and desk tags and personalized letters These are covered later in this chapter A quick way to mark a whole group is to use the Filter first to find the group Then choose Mark All All records in the filtered set will be marked 22 Printed on 19 09 05 NIC NTFP Database User Manual Only one group can be marked at a time Before making a new set of marked records you need to clear the old marks Remove any filters that you have applied and click Unmark All All currently marked records can be seen by clicking View All Marked Actor Links Actors are linked to products and species information This makes it possible to create a list of people working with or have knowledge about an NTFP Links to More fees Details inline Workshops These links are made from the Actor Links page of the form To get to the actor Links click the More Details button or scroll down As well as links to Species and Products individual information about buying or selling NTFPs can be linked to an R erosott Access ACTORS Form TOTEM CE PNET eae IGE File Edit Yiew Insert Format Records Tools Window Help lexi Actor eg Trade
22. ed What title do you want for your query When you have all the information you want click next That s all the information the wizard needs to create your query Step three is to give the query a name and select if you want to see it in Datasheet View the information or Design View check your Do you want to open the query or modify the query s design C Open the query to view information relationships or set a criteria for finding what you want T Display Help on working with the query h cre iS rosoft Access NTFP s Listed Select Query B 3 S ENEKE Aae dexi e File Edit view Insert Query Tools Window Help la x m E a eaeee e sar B GEkyY teeseen se Neea o NTFP Part of Use NTFP Use Cate D Part of use L Part of use E D Use category L Use category E E ___ _ _aa z Use E E E Field NTFP ID T Product Name L Product Name E lUse E ss Use category E Partof use E Table NTFP NTFP NTFP NTFP Use NTFP Use Categor NTFP Part of Use Sot f tt CCSCsidzC SaaS Be eee eet Criteria or Ready fT NUM fea A Start Fa Instant Access a EY Microsoft Word pj ce C ANIC Database IE Microsoft Ac Ej Paint Shop Pro fi 12 25 If you choose Design View you will see a screen like the one below The fields selected are in the top row The table they belong to is in the second row Above the rows is a map sh
23. eset query or make your own Goto the Reports control panel to select a preset report or make your own Goto the Database Window to work in MS Access directly Do not go to the Database Window if you are not experienced in using MS Access The Record Selectors Current record Go to first record number Go to last record Record 14 H of 1834 ae Go to next record Go to previous record New record The Record Selectors are for moving between records and setting up a new record for entry These selectors are at the bottom of every screen Click the buttons to move between records Use the New Record button to set up a new blank screen for a new entry Buttons on the Forms Every screen form will have some control buttons Their labels should tell you what they do For further information just put the cursor on top of a button and after a moment a Tool Tip will be displayed Some buttons have red labels These are for use by the person entering data and can change information If you are not entering or editing data 7 Printed on 19 09 05 NIC NTFP Database User Manual DO NOT USE BUTTONS WITH RED WRITING Buttons with blue writing are for use by everybody They either navigate to other places in the database or help you select a group of records Explore them freely Set Filter Remove Filter de Ta a C E Creo Remove Filter The Set and Remove Filter buttons are on every form They may also
24. ext to the Species ID field to help with this This will take you to a screen Speciecid ao Nano th Lao Nano Sant Name Fhaich Name where you can select the species by either scientific name Lao Seed name or English name Pick See ine from the list or just type some of matan the name The list will select the Select species by Lao Engl or Seni name then cik gt I om closest match After that click Bee wma ae the ID button on the toolbar T13 YWimansuua maikhetsa na Aquibra crassna Pierre A ag Eagewood Your selection will be displayed with all names Check that it is correct A Transfer Species Number to NTFP Form fd Transfer number and names to NTFP Form R cancel NIC Find Species ID 2 You can either just transfer the Species ID number to the NTFP form or transfer both the number and the name if the species name is the same or nearly the same as the product Eg The species may be Eaglewood and the product name is the same Inserting Photographs Inserting photographs in the NTFP form is the same as the Species form For information see Insert Photo on page 23 Add Reference for this NTFP Adding a library reference for an NTFP is the same as adding references to species For information see page 26 Adding to Pop up lists Use Category Part of Use Source See Adding to Pop Up lists on page 25 19 Printed on 19 09 05 NIC NTFP Database User Manual Trade Form The Trade form rec
25. l2 The Database Map can be seen in Lao or English language depending on the language of the button used in the Main Menu You can also change languages by using the View buttons near the top of the screen The map display the various tables used in the database to store the different sorts of information The tables are linked together so that reports and queries can be made using all the different ways the information can be combined The four major sections Library Species NTFPs and Actors with their subsections and links can be seen on the map Each label is a button Click on a button to see or edit the records that are stored in that section 6 Printed on 19 09 05 NIC NTFP Database User Manual Moving around the database From the Database Map you can choose which part of the database you want to work in Clicking on a button on the map will take you to a form Library Species NTFPs or Actors or one of their subsections From every form there are other controls for you use to move around Many of these are the same on every form The Navigation Toolbar Database Window Queries Tables Queries Main Menu English or Loa Forms amp Reports SG aa Ge aaee Database Map Reports English or Lao English or Lao This toolbar is at the top of every form Use this toolbar to Return to the first Main Menu screen Return to the Database Map in English or Lao Goto the Queries control panel to select a pr
26. lick the Information Sheet button This will gather all information about the species then display a second box with buttons Clic he underlined Hypertext link to open the Species In i i Word k ont formantion Sheet in Microsoft 2 Click the Information Sheet button This will open the Species Information Sheet template in MS Word _ Information sheet and transfer the current data to the word file Special Note MS Word will attempt to re open the Logon AE database to locate the current data even though it is Name already open During this the ID amp Password dialog box er cancel will be displayed Do not enter anything here again After a few seconds Word will find that the database is already open and continue If you do enter name amp password don t worry it just means that the database 1s open twice Special Note on Leaving Word Exit Word when you have finished Cancel the Logon box and then maximise MS Access from the status bar at the bottom of the screen View all References to this Species If library references have been added for this species clicking this button will take you to a list of those references View all Local Names for this Species If additional local names have been added for this species clicking this button will take you to a list of all other local names and their locality Editing Records If you are adding a new record or editing existing records the buttons with red labels have
27. ll open as read only and you will not be able to change any information If you want to add change or delete information you will need to use the name Admin and enter the correct password into the password box The password will be given to approved people by the NIC Co ordinator This is not always true in this version of the database Some reports use both languages particularly from the ACTORS part of the database which has only been built with English language screens Also sometimes it has been necessary to show some instructions in English on a Lao language screen toolbars tool tips etc 3 Printed on 19 09 05 NIC NTFP Database User Manual If you want to make design changes to the database new fields Tables Forms or Reports you will need the Admin name and password and be working on the NIC Database Master copy of the database You should also read Part 2 of this manual 4 Printed on 19 09 05 NIC NTFP Database User Manual The User Log screen After supplying your user level the database will open to its User Log screen On this screen you must identify yourself by name from the list of names NIC staff or regular users only or if you are a guest type your name and organisation From the check boxes on the right tick the type of use for this session The comments box can be used to provide further information if necessary When this screen is completed click OK to go to the Main Menu The U
28. mpassak 124 1997 1996 97 Huaphanh 2 000 Tonnes 77 1997 Jan Sept 1997 Vientiane Municipality Export 21 100 Kg select a line in the list and go back to the Trade form to edit it or return to the Trade forms 99 42 21 1997 1996 97 1997 1996 97 1998 1997 98 1998 Oct 97 Apr 19 Vientiane Municipality 1998 1997 98 1998 1997 98 Champassak Champassak Champassak Champassak Champassak _ Export Domestic Domestic Export Export 83 500 Kg Export 31 100 Tonnes 31 100 Tonnes 78 Tonnes 20 Tonnes 20 Tonnes Q wo for the current NTFP E toNumber View Trade Tables in Excel 2 400 USD 1 20 8 400 USD 12 289 200 Kip 12 289 200 Kip 27 652 000 Kip 16 600 USD 6 480 000 Kip 6 480 000 Kip There are many different ways that the trade statistics can viewed Excel provides the easiest and most flexible way to view this information and make reports Clicking the View Trade Tables in Excel button will open an excel file that is already linked to the 0 40 395 15 395 15 354 512 62 0 20 324 000 00 324 000 00 20 Printed on 19 09 05 NIC NTFP Database User Manual database This button is also on the Database Map On the Database Map it is called Trade Statistics Any changes in the information since the last time the file was opened will be automatically updated When the Excel file is open you can choose from the worksheets Idi Bl NFP Quan
29. msay 50000 Pole E 7 1997 1997 98 Khammuane 150000 Pole the blue labelled buttons E 8 1997 1997 98 Sekong 10000 Pole 9 1997 1997 98 Attapeu 50000 Pole to chang e the species or E 97 1995 1995 96 Luang Namtha 4000 Pole 98 1995 1995 96 Oudomxay 4000 Pole 99 1995 1995 96 Bokeo 5000 Pole return to the Quota form 100 1995 1995 96 Xayaboury 30000 Pole p m 101 1995 1995 96 Vientiane 100000 Pole The red labelled Edit 102 1995 1995 96 Vientiane Municipality 5000 Pole 103 1995 1995 96 Special Region Xaysomboun 100000 Pole selected record button can Ind 4296 120535 tuarjpanh aT Lr 5 be used to return to the Form View uml NUM Quot a fo rm for the A Start Instant Access OCA NIC Database EF Microsoft Word NT IQ Microsoft Acces Ej Paint Shop Pro fi 13 29 selected record Choose a line in the list before using this button View Quota Tables in Excel This is a more useful way to view quota information The information in the database has been linked to an Excel Workbook which is updated from the database each time the workbook is opened Just click the View Quota Tables in Excel button on the Quota form or on the Database Map to open this Excel workbook In the Excel Workbook there are six different views of the data aaa A z D E F G H I J e Full list n Lao Sum of Quantity Year Period 1 2 3 5 BAD We ita 30000 PEE 7 ta Full list in English Choose by product in L
30. n Hoong Southavong Medicinal Plants Institute Khamphone Sengdala Tom Evans Darwin Institute Mrs Bouahom Wildflower Institute Wildlife Institute Mike Callahan Implementing Department Implementing NGO Project Funding Concept amp Initial Specification Specification Development Software Development Content Manager Content preparation Data entry and software testing Content Consultant Medicinal Plants Content Consultants Bamboo amp Rattan Content Consultant Orchids amp Wildflowers List of wildlife found in Lao PDR Species Lists The NIC also acknowledges the support and suggestions of everybody who has watched its progress Some of you will see your suggestion in the product Finally the NIC would like to express its appreciation Mr Khamphai Manivong Head of the Forest Research Center for his support of the Project The NTFP Database is a major output of the Non Timber Forest Products Information Centre in Lao PDR NIC 1999 Non Timber Forest Products Information Centre Table of Contents INTRODUCTION TO VERSION 1 OVERVIEW STARTING UP THE DATABASE Where is the Database Opening the Database The User Log screen The Title Screen USING THE DATABASE The Database Map Moving around the database The Navigation Toolbar The Record Selectors Buttons on the Forms Set Filter Remove Filter On Line Help USING THE FORMS Library Form Adding a new record View as a list Loan
31. n M za Lje fimi E hss i Gwe ti Peal EE o is E Da a OOO f bari eh if Alaha at ma PSS a E Fun ome r an Sd a Ff Ei ert beter _ DF its Wied ELS DEARA baie je himassh Ac Red Labeled Buttons Use the red Find ID buttons to add Actor Species and Product Ids Use the red Add buttons to go to the Actor Species or Product forms to add new entries if they are not already there Use the Add another selling buying record for this Actor button to create a new record and automatically add the same Actor ID as the current card 27 Printed on 19 09 05 NIC NTFP Database User Manual Blue Labeled Buttons The Main Problems with Selling Buying button displays the problems and suggested solutions screen Any reported problems or solutions can be recorded here You can also get to this part of the record by using the scroll bars It is part of the same form Other buttons are used for moving to other forms selecting all the Selling forms for this actor or viewing the information in Excel The Query Control Panel The Query Control Panel in either Lao or English language is used to make lists from the database It can be opened from the Title screen the one with the map of Laos that you saw when you first opened the database or from the toolbar Read The Title Screen on page 5 and The Navigation Toolbar on page 9 k AN rosoli Acces iUwery Menu Leo Form Th pe Edt yew Insert Form
32. naes Salento Hane Er hae Information Sheet button for Species or NTFP a list tastet Tamer headings offering Lao or eneak English names is Sees Ebony displayed Choose from the list then click the ID button on the toolbar You have now chosen the Information Sheet required The Information Sheet dialog box is displayed 2 Click the Information Sheet button This will open the Ciok on the unin Het Ink to open te Species Informantion Sheet in Microsoft Wor Word document and transfer the information you have momar sel chosen to it There is some other important information you should know on page 19 The Query Wizard Use the Query Wizard to make your own queries Be careful if you do not understand how the forms link together relationships the query may not work Relationships Microsoft Access is a relational database What this means is that the information in one list can be linked to information in other lists For example from a card for a product you can go directly to a list of all the library resources about that product or the species that it is made from Or you can get a list of all people and organisations with an interest in that product In this database the ID number field in each list is used as the relational link with other lists You will have noticed that the NTFP form has a field for the Species ID Because of this Species ID number all of the Species information is linked to
33. nformation you want to see in the list They include every field for each type of information When you ask for a Custom list it is opened in Design Field SpeciesID____ Lao Name L ScName J Emg Name Family LuangNamtha Autha View Table SPECIES SPECIES SPECIES SPECIES SPECIES SPECIES eee ee eee eee eee In design view all of the available column headings are shown There are many more than can fit across a piece of paper There are many more than you can see on the screen Use the scroll bar to see more The ticks in the Show row determine whether this column will be displayed on the list Turn off the columns you do not want by clicking on the tick When you have selected the columns you want click the Data Sheet View button on the top left of the screen or select from the View menu Information Sheets The Information sheets are made in Microsoft Word Each Information Sheet is about one species or product They can be from 3 pages to 30 pages long depending on how much information is in the database They are the same as the Information Sheets that you can 29 Printed on 19 09 05 NIC NTFP Database User Manual make from the Species or the NTFP forms The only difference is that on the Species and NTFP forms the Information Sheet is automatically about the Species or Product on the form In the Query Control Panel you must choose the species or product There are two steps 1 When you click the see BERANE a
34. ns on the local names form 15 Printed on 19 09 05 NIC NTFP Database User Manual References List A list of references for a species is available from the Database Map clicking the References button then making your choice of species from the References screen B File Edit view Insert Fitter Tools Window Help 18 x Choose by either Scientific Name English Gl Name or Lao Name lt 9 a a ee Filter X Clear Grid Special iter _ PH E Quota Form The database keeps information about annual quotas for products and species The Quota form ic opened from the Database Map SSI EEEN eE e E pu rer lO e yo ret Fyne Bands Ipos ydw tip Species Names poret M Ik U7 IIVAA jonn rem p Quota bores Rattan CU _ of sau i imispase i ot TED we ay 2 neo 2 pg pavard E ee 5 T a sanea mination Species 10 ig 10 a 1 5 new Per View Ouse mens yaserari wf a amen o m E m su 13007 anes tin Sead e H Pomad 2m sn Quwtiy 1500 rrano 10 e E Une ID 1 Source ID vaj Adi Mew Source Reco l 1 ej of 325 Form View m ASt Haters Access OCR f NIC Database EY Mimmot Word NT E Microso Acces Record tl T erlea of 325 4 i Form view ed coed med et eed Stan Eiraan Access OCH CYNIC Database EF Microsolt Word NT E Miczosoft Acces BA Pant Shop Pro En This form is for adding or correcting quota information The
35. oducts the actor is involved with Button on this form allow you to see another actor edit a link or go A fiarai s Eat E E E E AR ge Ses er Yous EON IRT i TEE Sa OR loreal UF ae 7 suro aaa s E TEILLE bm aj e anje a ii EE Gt fee eet Ppt a foo Yee eee SEE SS 1 00 basal Kk UF Sa TA ed ate Actor links with Produc han poet Pcie 00 eto _Sntelnponeeini amen Saori Ammi y GateLan Fim de hor ea tel oe 23 Printed on 19 09 05 NIC NTFP Database User Manual back Making Stationary Stationary such as mail labels envelopes name cards can be made for _ Mail Labels all marked records in the Actors forms Envelopes Addressed Letters Make Stationary Name Cards First clear all previous marks Do this by removing any existing filter then Unmark all Records New marks can be added one at a time by finding and marking with a tick or by using Set Filter to select a group then clicking the Mark All button Desk Cards Once the records needed have been marked click the Make Stationary button which is on the Actor Links form ei aie ETE E e Ga e eet Prea eoi fale mee aa oqlcm S faum ia bet hra Labels Envelopes and Letters Labels Envelopes and Letters ab EE E the From the Stationary control panel select the z PMT JBK AJ Ree ee F a type of stationary required Each of these stationary types have been prepared as MS W
36. on and distribution by province The Species form has 4 screens 1 Species ID containing names descriptions and harvesting notes 1 A TT fem a EE eet Pie T pk ee peri gree ec foc mie Eb T 1 Gi n fgg rea baiah Ala oath JAO TE pk ye per iya peri foots ieee eb Eee SR210R oree K UF vax TA the LIa OCs tar we Lee oe j C e e e N EE a E CE 2 Environment containing rainfall elevation soil type forest type habitat and general distribution 3 Distribution in provinces 4 Sources of Information Use the buttons to move between screens or use the TAB key from the last field on the screen Viewing records Use only buttons with blue labels to view the records Buttons with red labels are only used when entering information You may use the record selectors at the bottom of the screen to move through the records see The Record Selectors on page 10 or the Set Filter button to select a name or group see Set Filter Remove Filter on page 11 Information Sheet Clicking this button will prepare an information sheet in Microsoft Word eit Information Sheet for the species in the current record The process may take a while as the information must be collected Word opened and the information View all References for displayed this Species View all Local Names for this Species 11 Printed on 19 09 05 NIC NTFP Database User Manual There are two steps 1 C
37. opened the database or from the toolbar Problems by NTFP Problems by Type Read The Title Screen on page 5 and The REPORT Navigation Toolbar on page 9 Form view Sa ees ed ed num ee Astar Eflinstant Access J Manual EY Microsoft Word amp Microsott Ac E Paint Shop Pro Re 13 37 The Reports Control Panel offers a choice of pre prepared reports that can be made as well as the opportunity to make your own using the Report Wizard Except for the Information Sheets the reports are ready to go Just choose the report required and it will be displayed in Print Preview mode ready for printing Check the page navigation control at the bottom left of the screen to see how many Pages wala 77 pai pages the report will take The Information sheets work the same as described for the Query Control Panel Read about Information Sheets on pages 19and 44 At the end of each session The database needs to be backed up at the end of a session where information has been added or changed Full back up is discussed in Part 2 of this manual and needs to be known by the database administrator Each data entry user of the database does need to do a first level back up of their changes to the database in case there are file problems and data is lost C Ix Tosoft Access Enter Edit Browse Menu Form B 3 S S 2 es 4 50 OBL ey omp act File Edit Yiew Insert Format Records Tools Window Help la
38. ord files which merge with information from the database Special Note MS Word will attempt to re open the database to locate the current data even though it is already open During this aes the ID amp Password dialog box will be a displayed Do not enter anything here again After a few seconds Word will find that the database is already open and continue If you do enter name amp password don t worry it just means that the database is open twice Special Note on working with Word Merge Files When the Merge document is opened a new toolbar for using with merge documents is displayed This toolbar should be used for various actions Merge to Printer Insert Merge Field Insert Word Field ld 4 l P H Ele aE P5 D Ca Merge to New soculnent Don t worry about the first two menus Insert Merge Fields and Insert Word Fields These are only used when making or changing a merge document The ABC is also not needed but try it out if you want It changes your view from seeing the data to seeing the merge fields The next group the record selectors work the same as in H i H Access Click forward or backward to see different pages or see the first or last page To print the stationary use the Merge to Printer button on the toolbar To keep a copy or make some changes use the Merge to New Document button 24 Printed on 19 09 05 NIC NTFP Database User Manual
39. ords information about trade statistics for NTFPs collected at a level Ameer NTEP Trede qe TE pes Po a atc N rosor Access ira AASE lel AA E t a TE LEN paar pea pe ang Tb jage AABlagioad s x OP 1 YOXVAl SOR Lem p E a _ E dE a ape ol Record te sf 1 fotlves of 151 SD Astan LYNC Dabare BY Miror Wend NTEP O E Microso Access 1 Step Pro EME Where possible pop up lists have been used to link to other parts of the database Eg NTFP ID These make data entry fast and accurate and reports can be produced in either language On this form only the ID numbers for these items are shown Viewing Trade Information The buttons with blue labels provide ways to view trade information Find NTFP Clicking this button will start the filter to allow you to select an Once the filter is started just type or select the NTFP required in the NTFP field and click Apply Filter All record forms will now be for that NTFP View All Trade Statistics for this NTFP Clicking this button will summarize all trade statistics for the current NTFP and display as a list From the list form you can change NTFP A N rosoft Access INTFP Trade List TTT Se ee fe ed Ee ew etree kab la x A RAITI TAPB X ay YAXYA amp Bo x 4199 70 1 199 70 9 657 585 Kip 9 657 585 Kip 8 050 Tonnes 8 050 Tonnes Domestic l l Export Export 1996 1995 96 Champassak 1996 1995 96 Cha
40. ous page for making stationary from the Actors file The only difference is that from the Actors form stationary is made for Marked Records Here stationary is made for all participants in the workshop Actors can be linked from this screen using the Link Actors button or directly from the Database Map using the Attendees button Both display the Attendees form If you use the button on this screen the Workshop ID is automatically entered Attendees Form R R rosoft Access IWorkshopAttendeesE Haee ee E Use the Red labeled File Edit Yiew Insert Format Records Tools Window Help 18 x Find ID buttons to JZ l lgaGe e ay vaxve Be o rri Fa and PT aie Workshop and Seminar Attendees Workshop ID and the Attendee ID AutoNumber g T z Actor ID Workshop ID OE If the Actor is not already in the database use the red labeled lt 3 33 Add Actor button to return to the Actor Form and add the new Actor There is also a red Record LAT mpl of 1 x Form Vi T a labeled Add Astan F lInstant Access OCR NIC Database BY Microsoft Word NT E Microsoft Acces Ei Paint Shop Pro fe 15 40 Workshop button to add a new workshop from this form if necessary 26 Printed on 19 09 05 NIC NTFP Database User Manual The Blue labeled buttons are used to return to the Actor Links form or last form used remove any filter view all Attendee cards for this workshop or view list of
41. owing the relationships between the tables If there is no link shown no line joining the tables there is no relationship and the query will not work Try again This example shows NTFPs linked to Species and NTFP Part of Use NTFP Use and NTFP Use Category Each table is linked through their ID numbers The query can be changed even further by setting what you want to find in the Criteria row For example if you only want medicinal products listed type medicinal in the Criteria row of the Use E column When you have finished choose Datasheet View from the View menu or its button _ B gt 31 Printed on 19 09 05 NIC NTFP Database User Manual at the top left of the screen Reports Control Panel The Reports Control K RNirosoft Access Report Menu E Form SeSe FEE Pes ees PEI Es g S File Edit Yiew Insert Format Records Tools Window Help la x Panel in either Lao or EEE lemes X US ZUXYA BRO x English language is used Reports Select the Report you require or customise to reports of the whole e contents of the database LIBRARY i SPECIES i I NTFPs i ACTORS It can be op ened from All Library References Information Sheet Information Sheet Actor by Organisation the Title screen the one NIC Library References Species by Character NTFP List Actor by NTFP with the map of Laos Www References Species References NTFP References Agency by Type that you saw when you first
42. r The Actor fou naw IS uia MU MesIsenwIAea can also be linked to a Actor Links fA anchatSdlaven promotion spat aT Fes bas workshop seminar etc and to an Agency NGO Project Actor Links Stationary oe etc Add Link Tink Added Yew Links Mail Labels __ViewFoms Forms Envelopes Td Marked e e Species by Actor Addressed Letters Make Stationary Editing Actor Links a f aan ean _ Actor by Species a Species Desk Cards The Red buttons are used to Actorby Product add links for the actor co e Species Products Buy Sell _ st r sa Workshops and Agencies Workshops Workshops Once a link has been made EZA Ee 5 Record Waj afp T gt Lon gt of 74 the Link Added tick is SS oo SS automatically included This is useful for knowing that this AStar FA Instant Access al NIC Database BY Microsoft Word Microsoft Ac Ei Paint Shop Pro 3S Microsoft Excel H K 14 23 actor has a link before choosing from the View buttons When you click a red link button you go to an Edit Link form The different Edit Link forms all work the same way Use the red buttons to find and add the correct ID numbers Viewing Actor Links The blue buttons on the Actor Links form and the various Edit Link forms show different views and lists for the links b For example by clicking Product be Actor button on the main Actor Links form you will get a list of all pr
43. ry REN rosoft Access Species References RNAS BAE You can add more FB Eje Edt view Insert Format Records Tools Window Help lal x l cE HeaG ea e OY Y eExve Bao references view all references linked to this species or go to the library card directly from the buttons on this form as cr You can also return to the Species or NTFP form by clicking the Return to Last Form button References for species amp NTFPs can also be r EE E Form View viewed fr om the Astan ENIC Database BY Microsoft Word NTFP D amp Microsoft Access Paint Shop Pro Database Map Click the References button on the map Add Other Local Names Many local names can exist for a species Sometimes the same local name is used for more than one scientific name The NIC also wants to record local names for neighboring countries Vietnam Thailand Cambodia Myanmar China As well as a main local name the database has the ability to record as many local names as we know Click the Add other local names button to go to the Local Names form The Species ID for the current record is automatically included on a new record The other local name and the locality Province or country should be entered in both English and Lao script 14 Printed on 19 09 05 NIC NTFP Database User Manual More local names can be added or the list of local names for this species can be viewed by clicking butto
44. s Form The Edit card WWW Form Species Form Viewing records Editing Records References List Quota Form Viewing Quota Information NTFP Form Viewing NTFP records Information Sheet Editing Records Trade Form Viewing Trade Information Editing Trade Information 10 11 11 13 14 14 14 15 15 15 16 17 19 22 28 29 30 34 35 35 35 37 37 40 Actors Form Viewing Records Actor Links Editing Actor Links Viewing Actor Links Making Stationary Workshops Form Attendees Form Agencies Form The Query Control Panel Standard Lists Lists with choice Custom Lists Information Sheets The Query Wizard Reports Control Panel At the end of each session Compact Database Make Back up copy Maintaining amp Changing the Database 42 42 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 44 NIC NTFP Database User Manual Introduction to Version 1 The NTFP Database is a major output of the Non Timber Forest Products Information Center NIC Information about NTFPs in Lao PDR is scarce and widely scattered The NIC s mandate is to collect manage and disseminate as much of this information as possible in a useful and accessible form The NTFP Database is the main tool for doing this The information in the database is still largely incomplete The NIC estimates that it will take a further year of information collection before the database can fully demonstrate its potential
45. sage Log can be viewed as a list by choosing Datasheet View form the View menu Return to viewing the form by choosing Form View from the View menu This information will be used for analyzing and reporting on usage The Title Screen Microsoft Access Man Menu Form Rephcated APC EMM MTEC slit EEE lalate tcl Es Eile Edit View Insert Format Records Tools Window Help From the buttons at the a What is an NTFP Database Manual bottom of this screen you can taeyeax 909 gisyudiuneu nu yu ejisej choose what activity you want to perform You can ee SUE uUvUeIVOS IVLMsqwaesac 1 Edit or just view the ye ee Brn aJi pe 5 records Ty ryo yao N p ra ee teigi k y tied r as a A4TY Ta H prest PIANT OT O Art aTi Aari ATI Te 4 a A Bee WWOTMa wor enue LN Wil A AL 444 od 2 Make a standard or new Query 3 Print a standard report amend or make a new report l ea det ie GLEN RSH Make a Quey fi i These choices can be made by Form view NUM choosing either the Lao or Astan ANIC Database Norton System Do EY Microsoft Word Microsoft Acc Sates mg ST 22 20 English language buttons If the Lao language button is used you will be taken to the Lao language versions of the database screens or if you choose the English language buttons you will be taken to English language screens You can also see other database information including this man
46. the Product Before making a query check that the information that you need from different forms or lists are linked through their ID numbers Using the Query Wizard If you want to make a new query the easiest way is to use the Query Wizard button on the bottom left of the Query Control Panel Just click it to begin the steps Pw Query MEI Step 1 take you to a choice box Select Simple Query oe Wizard then OK ia This wizard creates a select query From the Fislde wrar Simple Query Wizard Crosstab Query Wizard Find Duplicates Query Wizard Find Unmatched Query Wizard Lea You can choose from more than one table or query S Tables Queries information you want From the Tables Queries j Available Fields Selected Fields Species Code al ne m 30 engName E 9 05 areca x Ea cows cies O in Step 2 take you to the selection box for choosing ee TIN the tables or other queries that contain the is NIC NTFP Database User Manual menu choose the first table or other Query that contains the information From the second box choose the field you want to use and click the gt button The field is included Keep doing this till all the information you need in included You can change tables as often as is necessary Any time you see a field which is an ID field it means that information about that field is in another table Go to that table and include the fields you ne
47. tit ATFP alue Province Quantit Province Value Average Price bar at the bottom which view of the information you want Some of the worksheets are a list of all NTFPs Other worksheets have a menu at the top for you to choose the NTFP you wish to 1 A Product Name E 3 4 5 view Sum of Amount Cardamon If you want to change the layout or ane i a EEN yaani i formatting of a table it is better not to 5O ae fearon te make the changes here These Excel files 8 ae Ki Ki 23 552 250 have been protected and your changes ioin cannot be saved Copy the table and open a new workbook Use Paste Special SSSiMaie aS instead of normal Paste from the Edit menu Select Values Oo C Sommers th en OK cers C All exrent borders Operation This makes a copy of the data table that is not linked to the ree oe i C Subtract database It is much easier to make layout and formatting J Skip blanks Tl Transpose changes to this copy than the original It can be saved to a new file name Cancel Paste Link When you have finished working in Excel choose Exit The database was minimized when Excel was opened To maximize again click its button on the tool buttons at the bottom of the screen Editing Trade Information There are only two buttons with red labels on the Trade Form Find amp Use NTFP ID and Add New Source Find amp Use NTFP ID ALWAYS USE THIS BUTTON TO ADD THE N
48. ual by using the buttons at the top of the screen A toolbar is also shown at the top left of the screen Clicking tool buttons on B this toolbar will take you to the Database Window to see all Tables Queries Forms or Reports Only use the Database Window if you are familiar with using MS Access Click the View or Edit Records button will take you to the Database Map Click the Make a Query button to go to the Query control panel Click the View or Print a Report button to go to the Reports control panel You can use either the Lao or English language buttons 5 Printed on 19 09 05 NIC NTFP Database User Manual Using the Database The Database Map Microsoft Access Enter Edit Browse Menu Form Rep B S I Z SS S Sag ojo x BEES RERI Access Enter Edit Browse Menu L Form E File Edit View Insert Format Records Tools Window Help le x EB Bile Edt view Insert Format Records Tools Window Help a amp l Inas X H eax FSBO S RAl UR eeee M OY l B Database Map Bi Select the information you wish to view or edit tht es CeUReUUWU NAV viewEngish pe o Jz iew English KoeNs YUH gaun adang easoj en eee iiaa iaia nauganSy e el a ee e a ie A Astn a BY Microsoft Word EEglPaint Shop Pro 4O 22 31 M Start ANIC Database IQ Microsoft Access 2 Microsoft Word Manua
49. y you need is not on the list you can cones add it by clicking the Add button beside the pop up list Clicking mpm this button take you to a table displaying the choices Add the new one then click the Return to Last Form button that will be on the toolbar View as a list All forms may be viewed as a list This is often quicker than moving through the separate forms for each record The forms can be viewed as a list by choosing Datasheet View form the View menu Return to viewing the form by choosing Form View from the View menu Loans Form NIC library resources may be loaned out The Loans form keeps a record of the loan and the return of the material The Loans form is opened by clicking the Loans button on the map 9 Printed on 19 09 05 The Loan Detail card displays all loans made Loan cards may be browsed using the Record selectors at the bottom of the screen The Still on Loan tick box at the top right of the screen is a quick way to see if the book is still out To see a list of all materials on loan use the Loan List button To find a loan card use the Set Filter button NIC NTFP Database User Manual A EXtrosoft Access Library Loan Display Card ss LUPUS ESE gE a el cI es fs ESTES 3 fae a AEE Ema View Insert Format Records Tools Window Help l2 x He i Q O0 oea e M ay vexvel immer r gt al pe F E Lac English 1 gt oufr of 1 ised Sue

NTFP Database (Version 1)

Contents

Download Pdf Manuals

Related Search

Related Contents