I'v not really used Access much and could use some guidance on how to best go about building an application. This is what I'm trying to acheive..........
Currently I have a access database with serveral tables in it. These tables contain a lot of historical data. I have built a frontend for this table in Excel (which I do know how to use) that takes data from the access database runs several fairly complex macro's to work out cumulative data totals and tracks the performance of the data. Becuase of the type of analysis I am doing on the data (long time periods), and due to the fact that is has gradually got more & more complex these macro's are now taking several hours to process & output the results.
I am assuming that by moving the model from Excel into an Access application I will greatly improve the performance?
Is it possible to run queries with a range of values? i.e. If I wanted to run a query using today's date, then again using yesterday's date etc... If so what is the best way of setting this up?
Does anyone have any links to good examples/tutorials of how to build access applications?
Any help would be greatly appreciated.