LWAF Plant Database

1. LWAF Plant Database - AKA “Accession Database” -

2. Plant Database Usage • “Accession” plants • PMD personnel • Project managers • Any volunteer • Provide lists of plants for: • Docents • PMD personnel • Potential visitors to the Arboretum • Any other interested parties • Standard reports available • User-controlled reports available • Update plant information • Add missing information • Correct erroneous data • Revise location data • Online/Multi-user/Multi-tasking

3. Volunteer Internet user Internet Add records Query database LWAF Plants PMD Chair Docent Project Mgr Add/Update records Add docent notes Add/Update records Operational Overview

4. User Plant Database User Interaction - Overview - 1) Request for Plant List 2) List of plants 3) Update this plant record

5. Allowable Flow of Webpages Accession Home Page Report Page Custom Report Menu Lookup Table Selection Menu Single Plant Record Update Form Mulitple Plant Records Update Form Lookup Table Update Form • Note: • You can always go back to the Home Page or the Custom Report Menu • from any screen.

6. Accession Home Page

7. Show Pictures/More Info Other Perrenials Shrubs Non-Conifers Blooming Conifers Accession Home Page (plantsteward.com) By Garden Plants By Name Plant Update Form Report GenerationFor Predefined Reports Update • Standard record selection and sorting • One click for viewing pictures/more info • One click to retrieve update form

8. Custom Selection Page Plant Lists Page Home Page Paginated Report Plant Update Form Update Custom Report Generation Custom Reports Update List Details By Garden Notes Names • User-specified selection, sorting, report format • Paginated report format available • One-click to retrieve update form • Update list available for multi-record update

9. LWAF Home Page Click on this link

10. Plants List Page Explanatory text Check if you want to show pictures Select Report Click here to run report

11. Sample Standard Report Click on highlighted name to get Google results for this plant in far left column Click on question mark to get update form for this record.

12. Sample Standard Report- Showing Google Search Results - Click here for most pictures Click here for more pictures You clicked here on previous screen to request Google search results. Click on hyperlinks to go to info on Internet Click here for most text info Click here for more text info

13. Plants Selection Page (Menu) Set numbers to indicate sort order • Default: all plants selected • Set any or all selection fields • Selection criteria are “and” conditions • (as opposed to “or” conditions Select report format This shows your authorization level Enter password here to change authority Click here to list plants once you have set your selection and sort criteria

14. Plants Selection Page Example • Select all maples in the Smith Mossman • Use “By Garden” Format • Order by accession number • Enter password for update Select only maples Smith Mossman Garden only Use “By Garden” format Current authority is “view onlyl” Enter sort order Enter update password Click here to run report

15. Sample Custom Report- All Acers in the Smith/Mossman Garden - Custom report as requested by user Records sorted by garden as requested Link to update form Click here to get paginated report

16. 1. This message line provides status to the user. 2. Select “Tree” from the drop-down list. 3. Click on the “Revise” button. Plant Update Page- Example - • We got to this page from the Plants List Page. • Our objective is to change the Form field from “Conifer” to “Tree”

17. Example – Record Revised 1. Message indicates that record has been revised. 2. Revision date and time have been updated automatically. 3. Form is now correct.

18. Example – Add a Record You got here by click on a record on Plants List page. Status line. Click “Clear” button to get blank screen for adding a new record.

19. 1. Status information Example: Adding a New Record- Top Half of the Form - Note: To show all information in this training material, the form is show on two pages. See the next page for the bottom half of the Form. 2. Will be computed if left blank. 3. All fields are automatically assigned a default value if you do not enter anything in the field.

20. Example: Adding a New Record- Bottom Half of the Form - Note: To show all information in this training material, the form is shown on two pages. See the prior page for the part of the form not shown here. Click on the “Add” button to add this record.

21. Example – Adding a record This screen shows the response after a record has been added 1. Status information 2. Transaction date and time computer generated 3. Accession number computed.

22. Example Plant Record- No Update Authority –(View Only) 1. No add/revise/delete status 2. No Add/Revise/Delete buttons Note: Your update authority will automatically expire, if you do not make any screen input for an extended time period.

23. Delete Example 1. You arrived here from the Plants List page 2. Status information is shown here. 3. To delete this record, click here.

24. Delete Example- The record shown has been deleted - 1. Status shows that record has just been deleted. 2. If you deleted the record in error, click on the “Add” button to add the record back.

25. Navigation from Plant Update Page Produces Plants List using your last query. Return to report menu. Return to Database Mgt page. Go to the home page.