Short Rotation Coppice (SRC) Database – User Guide
Contents
1. find the information needed There is also the option to then save the data to an Excel file or a text file by clicking on the relevant button The example below shows a search for D100 data from the site Balbirnie for the clone Beaupre in the year 2001 E 0100 Search Form lt All gt 2001 Ba PLOT_NAME CLONE MMONTH MEAR STOOL Balbirnie i 2001 Balbirnie 001 001 2001 2001 2001 z001 2001 z001 z001 2001 2001 2001 nnd e p j p p p j ee M MM l MM 1 Ralhirmia Re amra Save Data as Excel File save Data as Text File Page 6 SRC DATABASE 2 2 5 Other Data The last button on the Menu Page is Other Data this opens up a screen shown below which has information on all the other types of data that is available but that is not included in this database For more information please contact the Data Centre on the number shown 6 Other Data Form Page 72. the left hand side is a table giving more details of each site such as Site Number Plot Name Grid Reference Altitude Aspect and Slope It is possible to scroll through the sites numerically by using the mouse wheel or clicking on the right and left arrows on the record selectors found at the bottom left hand side Clicking the Close button will close the map data and return the user to the menu screen amp Site Map E NO268064 mo Record 14 4 i 1 gt gt I a of 53 Page 5 SRC DATABASE 2 2 4 Other Search Forms The other search forms follow much the same pattern The only exception is when clicking on Soil Search another screen appears first offering a choice of either searching by location or soil type after selecting one of the options a screen similar to the one below will appear The image below shows the D100 search form most of the other forms will follow the same pattern At the top there are a selection of drop down lists by clicking on one of the drop down arrows a list of search options will appear once an item is selected from the list this will narrow the search Only one item can be selected from each drop down list but a selection can be made from each drop down list narrowing the search further once the selections are made the next step is to click the Get Data button The data will be returned in the box at the bottom of the page and this can be scrolled through to
3. SRC DATABASE Forest Research An agency of the Forestry Commission SRC Database User Guide Prepared by Marc Sayce Version 0 Date 18 07 2005 Page 1 SRC DATABASE 1 INTRODUCTION W 2 USING THE DATABASE 2 1 FRONT END 2 2 GETTING STARTED 2 2 1 Front Page 2 2 2 Menu Page 2 2 3 Site Map 2 2 4 Other Search Forms 2 2 5 Other Data NA AK WWW w Page 2 SRC DATABASE 1 Introduction The Short Rotation Coppice SRC database was designed in Microsoft Access The database contains many different data sets sampled during the lifetime of the SRC project See the report Short Rotation Coppice SRC Data handling and database design and construction It includes such data sets as Damage Data D100 Growth Band Soil Length amp Biomass Standing Biomass and Meteorological Data The database contains many different and complex data sets In order to allow users easier access to the data the database includes a number of forms These forms cover the data sets that we anticipate would be the most commonly required 2 Using the database 2 1 Front end Researchers requiring the data need a means of access that is available on their own desk and which does not require specialist knowledge MS Access is part of the Microsoft Office suite and is loaded on many PCs It is closely integrated with the other packages in the suite Word Excel etc and is easy to use after some basic training Users
4. can view and query the data through a series of Access Forms and therefore do not need to learn any database skills 2 2 Getting Started 2 2 1 Front Page On opening the database in Access the page below is displayed This is the front page and details the organisations involved in this SRC database The organisations logos are also hyperlinks which can direct the user to the appropriate website Press the Enter button to continue Page 3 SRC DATABASE 2 2 2 Menu Page Upon clicking Enter on the front page a menu page shown in the picture below opens up There are a series of buttons to click on depending on what type of data is required Clicking on one of the buttons will open up another form described later but this menu page will remain open in the background so when the other forms are closed the user will be returned to this screen Page Two Form Length and tte Map Biomass Soil Moisture Met Data Standing Soil Search Biomass Other Data There are various forms to select from this page but a lot are very similar so there are descriptions below of each type of form some of the other forms will follow the same pattern as the one described Page 4 DATABASE SRC 2 2 3 Site Map Clicking on the Site Map button will open up the form displayed below This shows a map of the UK on the right hand side with the locations of all the sites showing the site number On
Download Pdf Manuals
Related Search