Ideally I would have wanted to just make an access database on the managers box... then code with VBA and make all the queries for her, unfortunately the fools don't seem to have an access license!
Basically it's gone from an easy RAD approach to something much more complex and out of my comfort zone... maybe I can persuade them to stop being cheap and grab a single / 3 user license.