I have attached an Excel file that performs some simple calculations on stock price data.? Your task is to create Update-Queries in MS-Access 2003 that perform the same calculations on the same data in an Access db.
?
The Excel file contains five columns of input data (black) and three columns of results (blue). The Access db contains the same five columns of input data. The other three columns are to be calculated. There is a second worksheet (Stats) which is used to calculate some additional statistics. The db contains a corresponding table, named Stats. These? numbers (three columns) are also to calculated. So, this would be three update queries for the first table and three update queries for the second.
Some caveats: These queries will eventually be run on a large db containing some 3000 symbols (3 Mio records). Returns are always to be calculated from consecutive closing prices, that means missing data is simply ommited. Not all symbols have data for all days throughout the year.
If you have questions, don't hesitate to ask.
## Deliverables
Attached is? the Excel file [login to view URL] and an Access file [login to view URL]