Is Access The Best Choice?

Basically I知 pretty new to Access, but feel confident for this project it痴 the best solution. Here is essentially what I知 going to try to get done, does using Access make sense for a project like this? Or am I totally off base?

Everyday, I知 going to be downloading basic information on the futures market on a variety of futures, getting the information isn稚 the issue. The issue becomes storing that information over time, the amount of lines in Excel will limit my abilities to keep this information. I知 thinking about getting the information in Excel, then everyday write VBA code to dump that information into an existing Access table that will accumulate over time, possibly years. For example, say I知 getting a snap shot of twenty futures with some information every 20mins, you can see that each day the line items might get long, I just want to take that information and put it somewhere for storage.

The other aspect is, I would like to query those tables for information, and even produce graphs. Does Access have the ability to do graphing? Or would I then take the query data and dump it back into Excel for its graphing abilities? Also, is it possible in Access to have a field in the table do a calculation? Such as a ratio of one field to another field, this too would need to be done so not sure if I知 on the right track.

Any guidance would be helpful, as I have not started this project yet, but just want to get come clarity from people more familiar with Access.

Short answer:
I do this too for the Natural Gas Trading.
NYSE, ICE, future source, and more...
Access code is about 140 Megs with AceiveX controls.
The 25 users trade about $1B a year.
I link tables and views to SQL Server 5 databases database.
Use Excel (object model VBA) a LOT.

Ok great, after doing more research I think I'm on the right path, I might even end up buying data from the exchanges for further backtesting.. thanks

I will be a little more available tomorrow.
Before you buy the data from the exchanges, you should PM me.

Depending on your situation, you may have options (no trading term pun intended).

Just a quick follow up for anyone searching this subject.
Note: this is just one situation, not a industry recommendation.

Took another position in 2010 through 2011 for gas/oil upstream permit tracking system for international company.
They had Access 2000 that was updated to Access 2007 and now Access 2010.
The front end runs around 60 MB of code and the Access back end DB is around 400 MB.

It runs on a Citrix server for many remote offices, wireless PC, and Apple tablets.
It serves about 30 full time data entry people with no delays. The user community (read only) includes engineers, GIS, environmental, legal and much more, intermittent users in the dozens at a time.

All reports use Excel VBA created inside of Access using Access forms to allow each user to create custom reports.

For all the arguments about going to a web or share point solution:
This application is an extremely rich front-end with each of the 120 forms containing dozens of very specific business rules - and full rich form to form interaction (i.e. tab to one form, make a change and it is there when the user tabs back to the orginal form).
Connectivity to publisher subscriber databases include SQL Server, Oracle and GIS systems.
The Cost of Ownership is very low for an international application. One part-time programmer consultant (me) and virtually no license for a shared Citrix server.
After working in Share Point, the complexity of the business rules are much easier (in cost) to manage and provide in Access.
Having said that, if the application was to be used for data entry for 250 or more poeple at once, my recommendation would be to look at web based systems. Under 100 people, Access is still probably the most cost effective system if complex business rules and government regulations are required.

It is always about the right tool for the right situation.
B.T.W. people using web based systems ohhh and awww at the rich front-end of Access and the user interaction for efficient user interfacing. What value or metric can be put on user efficiency?