Just came across this, hopefully it hasn't already been posted.

The guide to sound effects
This page contains a number of ideas on how to create various sound effects, and we hope you find it inspiring.