Microsoft Access Soil Database Template

1. Microsoft Access Soil Database Template Data Import Manuscript Reports Data Analysis Custom Queries & Reports March 2005

2. Data Import– 2 steps 1. Obtain a blank Access template and a SSURGO format dataset 2. Import the SSURGO dataset into the Access template

3. Select Survey Area

4. Soil Data Mart – obtain template & SSURGO dataset

5. E-mail Notification

6. Import SSURGO Dataset • Unzip the file, extract all text files into an empty folder • Copy of the blank template also into this folder • Detailed instructions in file named “Using NASIS Exports” http://nasis.nrcs.usda.gov/products/

7. Import Extracted Files

8. Access will import and sort the raw data

9. Manuscript Reports - select desired map units or all

10. Select desired report using drop down menu

11. Click “Generate Report”

12. Export to MS Word or print from within Access

13. Some reports require you to select parameters

14. Select desired crops; then, click on the “Generate Report”

15. MO-1 Template • MO-1 Technical Note Number 42 http://www.or.nrcs.usda.gov/pnw_soil/mo1_technotes.html

16. MO-1 Template Summary • Local engineering interpretations to replace standard national reports: 1. ENG - Construction Materials; Gravel Source – MO1 2. ENG - Construction Materials; Sand Source – MO1 3. ENG - Construction Materials; Topsoil – MO1

17. MO-1 Template Summary • Local forestry interpretations to replace standard national reports: 1. FOR - Log Landing Suitability – ID, OR, WA 2. FOR - Road Suitability (Natural Surface) – ID,OR, WA

18. MO-1 Templates Summary • 6 local reports currently available: 1. Map Unit Descriptions – MO1: abbreviated, semi-tabular MUD 2. Table B6 – Land Capability Classification: displays IRR & NIRR capability with component percent 3 & 4. Tables C3 & C4: expanded information on composition and production of understory and commonly occurring trees

19. MO-1 Templates Summary • 6 local reports currently available: 5. Table E1a – Forest Productivity w/base age: includes the site index base age 6. Table Y2 – Prime and Important Farmland: displays all categories of designated farmland – prime, unique, statewide importance, and local importance

20. Access reports for local interpretations

21. Select desired interpretation

22. Data Analysis Allows user to quickly review and analyze large amounts of data

23. Data Analysis

24. Result - Component Table

25. Freeze Columns

26. Result – column moved to the left

27. Hide Columns

28. Result of Hide Columns

29. Filter by Selection

30. Result of Filter

31. Viewing Additional Data

32. View Component & Horizon Data

33. Analyze Data

34. Custom Queries & Reports 2 Methods 1. Simple Wizard 2. Design View - more advanced

35. Select Queries or Reports

36. Select New – then “Simple Query Wizard”

37. Select Tables/Queries

38. Select Desired Fields

39. Select Tables/Queries

40. Select Desired Fields

41. Result of Query

42. Sort or Other Manipulation

43. Select Queries or Reports

44. Select New – then “Design View”

45. Questions ? ? “Motivation cannot be measured by appearances”