This tutorial demonstrates ways to make a glass, its materials and the content inside the glass. I made the model in c4d r9, but It can be done with lower versions (just to try it, I got avery similar result with cinema ce6).
This tutorial will teach you to make a great sandglass, which you can use for plenty of purposes. You can find the finished model and other stuff here Glass.zip