We need you to create a logbook software to be used on windows environment to document our daily order.
The logbook need to have at least following Columns with as below listed headings
Date: We need to have a pop-up of monthly calendar to select a date
Customer Details: with separate cells to enter Client Name, Phone #, Email and also this info should be saved in backup data base
Description of Work: sufficient space to write details of work
Artwork: need a space to write with a check box for YES or NO
Due Date: We need to have 2 due dates one For Proof and other For Print: For both dates we need to have a pop-up of monthly calendar to select a dates
Cost: we need 2 separate cost one for For Design in $ , and other For Print in $
Balance: The balance should be calculated, total minus advance paid
Mode of Payment: Cash, Check, Credit Card, on account
Invoice #: with an option to record the date invoice paid.
We usually get about 70 to 85 orders in a month
The program should generate data base in the back end so that the customer details are recorded, and for a return customer it should be able to pull out customer details when search by customer name, phone# or by email and it should find our docket numbers of previous jobs for a specific customer.
We should be able to search/sort the data by customer name, date, phone # or Invoice #
We should be able to see/search the total sale by a week or my a month or by a year
We should be able to print the logbook for a specific period of time, or by specific customer name, by docket number
This is a rough description of what we need, you may suggest better options.
The program should be stand alone and to be used from multiple terminals but the data to be saved on main server.
Software to be developed preferable using VB with back end data base in MS access or excel if required. We dont want to purchase any additional software to run this program. It should have an option of user name and password for each user to log in to make entries.
Please provide a sample of similar program written by you for us to review if possible.