Can I ask what you use it for?
I'm certainly not offering to do owt ( been there, still got the scars) but sounds like its not really the right tool for the job. You need queries that allow you to set date ranges for reports and some tools to archive old data (Access isn't good when it gets over a certain size)
I guess its a bit like me doing my own plumbing, I'd be all hammer and pliers
