Being a bit of an Access geek, I’ll try to offer some advice;
Your requirements are;
Store new client details that are inputted
Have the ability to create a new job from a template (again, which will be inputted into the database)
Bring up all payments e.g by a particular client, and between specified dates if need be (and other criteria as applicable)
Provide simple tax calculations, for example tax on the labor component of a payment
Generate invoices for jobs within the database
Link tables together (if multiple tables are needed?)
Store client accounts (individual projects and overall)
Generate monthly reports monthly report
Have an expense account module (for items purchased by directors, requiring reimbursement from the company)
An individual project module showing purchases, profit/loss, fees, costs and wages of any given project and as many report options as possible.
Simple to do this in Access - just create a form to take the input, add validation rules, link the form fields to the appropriate table fields and there you go.
Just design a form in Access
This is a simple query - you could design a form to display the results in a nice way
Easy enough using a query
Access lets you create what it calls “reports” which is the result of query, formatted in an easy-to-read format. You can easily export these to Word.
Easy to do in Access - use the Relationship editor
Yep, should be straightforward
Theoretically easy, but could get complicated.
So, I would say Access could meet all your needs.
There are advantages and disadvantages to having an off-line database - the main advantage is that you aren’t reliant on having an internet connection. The main disadvantage is making sure the database is replicated across all users - it is no use updating a record on your copy of the database if no-one else can see it.
Great, thanks for the replies. Sounds like Access should be able to do the necessary work (particularly as for cost reasons we’ve now ditched Item 10 - this may crop up in a Phase 2 as and when but isn’t needed for the moment)
Do you really think a construction company really cares of investing a couple of hundred dollars? And perhaps they already have Access! And what about the developing time? And when he’s thinking on using Access, wouldn’t it be more likely that he knows something about VB(A), so he would be more comfortable with VB.NET instead of PHP. He can download Visual Studio Express Editons for free, to build Windows and/or web applications using MS SQL Express as well if money is a consideration…