Create quotation system and generate quotation to email

Reference no: EM131293394

Goal: To eliminate the use of excel and create a quote tracker and job tracker database on top of that able to generate quotation. Basically ALL-IN-ONE system

Task

1) Create Quote Tracker (using Access FORM)

2) Create Job Tracker (using Access FORM)

3) Create Quotation System and generate quotation to email it to customer (using Access FORM)

4) Whole access should be simple and straightforward to use

Scenario:

Quote and Job tracker

1) Adam receive email (quotes) from customer include Reference Number then Adam has to create quote list on quotes tracker

2) Adam then send the email to John

3) John review and make the quotes (set pricing) then send it back to Adam

4) Adam then attached quote and email it back to customer

5) -If Won job Adam will update quote tracker as (Won) status and create job into Job tracker

-If Lose job Adam will update quote tracker as (Lost) status

Quotation System Form

For example:

Product(*This column should be using ComboBox)	UOM (Units of Measurement)	Quantity	Price
Supply 32mm Subduct as per Telstra standards	Per metre	1	$6.00
Supply and install 32mm Tdux system into subducts, conduits	Each	2	$35.00
Supply and install 64mm Tdux system into conduits and pits	Each	1	$45.00
			= Total Price

*Product able to choose from hauling, splicing, and traffic management list.
*UOM and Price should auto update when product are chosen.
*Able to insert new product on "FORM" and product will auto update in the database.

Attachment:- Prototype.rar

Reference no: EM131293394

Questions Cloud

Discusss about the critcal procedure in criminal process : Discuss two of the procedures that you believe are the most critical procedures in the criminal process. Provide a rationale for your response. Are private defense attorneys more efficient than court-appointed defense attorneys or are court-appoin..

Use the generalization bound to give a bound for eaut : Suppose mH,(N) = N + 1, so dva = 1. You have 100 training examples. Use the generalization bound to give a bound for Eaut with confidence 90%. Repeat for N = 10, 000.

Present worth of remaining income from the trust : 1) Ken will receive a $5,000 annual payment from a family trust. This will continue until Ken in 30; he is now 20. Inflation averages 4% and Ken's real MARR is 8%. If the first payment is a year from now and a total of 10 payments are to be mad..

Net after tax annual benefit or cost of purchasing : A chemical recovery system costs $30,000 and saves $5,280 each year of its life. The salvage value is estimated at $7,500. The after-tax MARR is 9%, the CCA rate is 20% and taxes are at 45%. What is the net after tax annual benefit or cost of p..

Create quotation system and generate quotation to email : Create Quote Tracker (using Access FORM) - Create Job Tracker (using Access FORM) and create Quotation System and generate quotation to email it to customer (using Access FORM)

How the internet may affect public opinion in a positive way : Write a paper that summarizes how the Internet may affect public opinion in a positive or negative way with regards to brand reputation. Discuss the current state of public opinion using the Internet as your research tool.

What sample size do you need : For an H with dvc = 10, what sample size do you need (as prescri bed by the general ization bound) to have a 95% confidence that your generalization error i s a t most 0.05?

Charging the optimal price for the product : Suppose a firm has a constant marginal cost of $12. The current price is $25 and at that price it is estimated that the price elasticity of demand is -4.0. a. Is the firm charging the optimal price for the product? Why?

Is there a moral problem presented in the scenario : Is there a moral problem presented in the scenario? If so, what is it?Does policy or law dictate an appropriate response, or does it require that professional discretion be applied?What criteria (considerations), principles, and consequences should g..

User Account

All Pages