Substrate just means the level (strata) underneath (sub) the water, if you see what I mean. I have a black sand substrate, some have a gravel substrate, you are looking to have a sand substrate. Just to confuse things, there are also planting substrates, which would ordinarily go underneath a sand or gravel substrate. Depending upon your set-up, a planting substrate isn't always necessary, although I do use one.
I honestly don't know if there is a difference between sand for marine and freshwater. I do know that standard childrens play sand, which you would probably find in Wal-Mart, is fine for freshwater aquarium use.