MS Access Question

I Have a MS Access Database that I use to store years of Stock Price Information. I’m trying to develop a query with a calculated field eg.[100 Day Volatility]to calculate the 100 day Volatility(or any other time period) on the closing Price.I would like to be able to perform this function on many different securities(Similar to Metastock)so I would prefer the querypower of a Database. I currently can perform this with an excel sheet,but performing this task on muliple securities at once is very cumbersome.Does anybody know how to perform this type of Function With MS Access?