We are a manufacturer who needs an Access database to build and track quotes. To run in a multiuser enviroment.
We do have MS SQL running on the servers.
We sell our products though distribution, manufacturer reps, resellers, and direct sales, we need to track all of these methods as “Agents??
It is very important we be able to pull up quotes by agent, customers, end users, dates, or products.
We need to have reports on quotes and resulting sales by:Agents, Customers, End Users, Products, Shipping methods, Quotes by dates
We need to enter all information on 1 form called “quote??, with sub-forms for the adding all of above. We will need to have buttons with links to print a Quote, and resulting sales order, ( I would also like a button for e-mailing the quote )
Our agents are tracked internally by an agent code, and name of company, many have multiple locations as well as contacts. For this reason we will need their address, phone number and contact information to appear on the entry form when selected from the list.
The same also applies to the customers and end users.
When selecting by Catalog # we want the description, unit cost, unit price to fill in automatically, and, the extended price as well as order totals to figure on there own.
I would like the quote details to show our cost in a different color or background so as not to stand out as much, ( this should help reps not shout out the wrong price )this of course does not need to be on the print forms.
During the quote process we will need to see past quotes, it would be of great help if we could see an older quote while working on a new one.
We need a comments section on each quote.
Phone Numbers need to be able to handle international numbers and area / country codes
I would like the database to open to a new blank quote form each time it is started
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
All Servers are Windows 2003 Server
running MS SQL
All workstations are XP Pro
All workstations have Access Pro 2003 installed