Esr 0 Posted January 12, 2012 Share Posted January 12, 2012 Can someone help please. I'm a training coordinator, and arrange funding etc I need to create a database on excel or access 2003. For the budget. For example someone wants to do an business and admin NVQ the cost is 1,500. Is there a way of just adding a names and it will deduct from a total figure? Link to comment Share on other sites More sharing options...
Burnsy2023 2,895 Posted January 12, 2012 Share Posted January 12, 2012 Ok, so I need to understand what you want exactly. Do you have a list of names and courses that these people wish to attend and want to associate a cost with that? Link to comment Share on other sites More sharing options...
Esr 0 Posted January 13, 2012 Author Share Posted January 13, 2012 Yes, so I would have a heading with a set budget. For example the heading is called safeguarding that cost 150.00 The budget for this heading is 5,000 Could it be set up to give me a total after adding people? So I wound not over spend? Link to comment Share on other sites More sharing options...
Esr 0 Posted January 13, 2012 Author Share Posted January 13, 2012 Would Excel be best? Link to comment Share on other sites More sharing options...
R 1 0 Posted January 15, 2012 Share Posted January 15, 2012 No reason you couldn't do this in excel. It would certainly be a quick and easy route. I've put together an example spreadsheet - it's attached. See if it's anything like what you're looking for Cheers. Example budgeting.zip Link to comment Share on other sites More sharing options...
Recommended Posts