homepage Welcome to WebmasterWorld Guest from 54.234.0.85
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Best solution for offline database application?
galahad2




msg:4283074
 4:05 pm on Mar 17, 2011 (gmt 0)

Hi,

I've been asked to build a database application for a construction company, which will do a number of things:

1. Store new client details that are inputted
2. Have the ability to create a new job from a template (again, which will be inputted into the database)
3. Bring up all payments e.g by a particular client, and between specified dates if need be (and other criteria as applicable)
4. Provide simple tax calculations, for example tax on the labor component of a payment
5. Generate invoices for jobs within the database
6. Link tables together (if multiple tables are needed?)
7. Store client accounts (individual projects and overall)
8. Generate monthly reports monthly report
9. Have an expense account module (for items purchased by directors, requiring reimbursement from the company)
10. An individual project module showing purchases, profit/loss, fees, costs and wages of any given project and as many report options as possible.

I was thinking of making it an online db so I could build with PHP/mySQL, but there's no real need for it to be online, so was thinking of an application for offline build.

It must also be able to work with MS Word (e.g bring up a Word doc template for an estimate, which can be filled in and placed in the db), and especially easily exported to Excel.

So I was thinking Access might be ideal, but will it do all the above?

Any ideas as to other database apps which would do a better job?

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved