3. Creating a report using MS-Access soil data file.

Equipment needed:

• Computer with MS-Access software
• Soil data file developed using the MS-Access soil template (.mdb file)

Advantages:

• Uses basic software, no special software needed
• Produces tables in a style similar to published soil survey
• Can select as few as one map unit or all map units in county

Disadvantages:

• Relatively slow
• Report interpretations are “bundled”; eg. Sewage Disposal report contains both Septic Tank Absorption Fields and Sewage Lagoons interpretations

Soil report using the Access file (.mdb) - Instructions

1. Using Windows Exporer go to My Computer then to the F drive and open folder named geodata then folder named soils. Next open the county folder (eg. soil_oh103), then in the tabular file open the soil database file with .mdb extension by double clicking on file name. Example file named soil_d_oh103.mdb.

2. After opening the soil data file the window pictured above will appear.

Soil report using the Access file (.mdb) - Instructions

2

1

1. Select desired map units or click on “Select All”. Hold down “Ctrl” to select more than one map unit.
2. Click on button to get list of reports available.

Soil report using the Access file (.mdb) - Instructions

Select desired report from list.

Soil report using the Access file (.mdb) - Instructions

2

1. Click on the button “Include Report Description” if you want to include an explanation of the criteria used in the interpretations and a description of the limiting features used in the report.

2. 1

   Click on “Generate Report” to run report.

Example of report using MS-Access file (.mdb)

Completed report is ready for printing or saving.