User Account

All Pages

Create quotation system and generate quotation

Assignment Help Other Subject
Reference no: EM131297167

Design a new access database and eliminate the use of multiple excel based trackers and job managers.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

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.zip

Verified Expert

The solution file is created in ms access. All excel data are imported into ms access and created relationship between all tables. The forms are created for project tracker, quotation tracker and quotation form. All forms are attached in proect1.accdb and it has all basic operations such as create new record, save record, delete record, clear record etc.

Reference no: EM131297167

Questions Cloud

Employees contributed to that positive image : Identify an organisation that you have a positive image of. Why do you have a positive image of the organisation? How has your relationship with employees contributed to that positive image? (50-75 words)
Roles and responsibilities for a marketing role : Create a job description that sets out the roles and responsibilities for a marketing role you currently have or for a marketing role you would like to have in the future. You might want to write a job description for a public relations officer
What could be the long-term effect of the system on company : How does "the system" affect upper management's ability to monitor and motivate its employees? What could be the long-term effects of "the system" on the company?
Discuss about the main possible health insurance portability : Discuss about the main possible Health Insurance Portability and Accountability Act violations that your facility risks by having a third party monitor the integrated database, and recommend at least one (1) method of preventing or addressing each ..
Create quotation system and generate quotation : 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)
Detailed critique of the assigned readings : Your task is to offer a detailed critique of the  assigned readings for this unit. In your critique, address thefollowing questions or points:
Discuss about the mcgregor and maslow on motivation : Discuss about the McGregor and Maslow on Motivation.vThe Human Side of Enterprise, Douglas McGregor (1960) proposed two theories by which employee motivation can be viewed. He called the theories, Theory X and Theory Y. Both of these theories are b..
What would ebejer and morden advise mitch to do : Should Mitch try to talk Sid into buying a less powerful, and less expensive, computer? Why or why not? What would Ebejer and Morden advise Mitch to do?
How do men establish themselves in the profession of nursing : How do men establish themselves in the profession of nursing which is traditionally a woman's profession?- It will give clues about the percentage of men working as nurses.

Reviews

inf1297167

12/13/2016 7:35:51 AM

Thank you for your trustworthiness in your confinements, rather than conveying a second rate item. It is refreshing and I will remember you when I require another exposition. Much obliged to you.

inf1297167

12/13/2016 7:23:28 AM

As for quotation system, I have attached the example for that. what it does is the supervisor can just select the item and come up with a total price then send it to customer. so the using of Microsoft access is like all in one. act as quotes tracker , project job tracker and able to generate quotation Goals: Design a new access database and eliminate the use of multiple excel based trackers and job managers. Currently using https://docs.google.com/spreadsheets/d/1HRWyStSQhBBQe5msjF4SyIpLrY0f7WtwyxKEC3_fhEA/edit?invite=CL2ok-cL&ts=5834e227#gid=1642313589 As Project Tracker and Quotes Tracker and wants to change it to Microsoft access database. Attachment of : - Scenario - Project Tracker FORM - Quotes Tracker FORM - Quotation template (item and price) - Quotation FORM

inf1297167

12/13/2016 7:19:49 AM

in the prototype access file you sent the form is already implemented. 2) The excel file that you sent doesn't match with the prototype access file 3) In excel file there are many Quotes whose columns vary from one another. 4) Please explain clearly what needs to be done in each form 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) the solution is missing out the quotation form. Where the form used to make generate quotes. for example look at attachment 19716361_1Example of Quotation Form.PNG that prototype file may be wrong. the whole point is just eliminate the use of excel and implement everything in access. quote tracker form my initial idea is to let user input/update/delete the data from there without having to look at the datasheet, same goes to job tracker.

len1297167

12/1/2016 6:48:39 AM

Design a new access database and eliminate the use of multiple excel based trackers and job managers. As Project Tracker and Quotes Tracker and wants to change it to Microsoft access database. Attachment of : - Scenario - Project Tracker FORM - Quotes Tracker FORM - Quotation template (item and price) - Quotation FORM

Write a Review

Other Subject Questions & Answers

  Board measure calculations-use dressed dimensions of lumber

Board measure calculations ____ use the dressed dimensionsof the lumber. When non-standard size bricks or blocks are used, sometimes an estimator needs to calculate a conversion factor to arrive at a number of bricks per square foot. Which of the fol..

  What did you find most interesting about the videos

What did you find most interesting about the videos that you selected? How can you apply what you learned to (understanding) yourself and others? Include a "real world example in your response to the latter. Support your observations with informat..

  What are the requirements of writing a haiku

What are the requirements of writing a haiku? How is it supposed to be organized and what is to be included

  How eighth amendment restricts the governments authority

Explain with examples how the Eighth Amendment restricts the government's authority to make something a crime.

  Describing casualty gap

One of best examples of the way in which social class affects life chances is idea of "The Casualty Gap". The burdens of war, including, importantly, the dying

  Illustrate what made it powerful

During Cognitive therapy session, Dr. Corey used several cognitive techniques with Stan. Which one do you think was most powerful and illustrate what made it powerful.

  Networks-alliances are marriages of money and convenience

Networks and alliances are marriages of money and convenience. Systems are marriages of commitment and values. Develop arguments and counterarguments for each statement.

  Economic policy

President Calvin Coolidge's economic policy included

  The legal structure of business issues

Describe the Business type (new business, franchise, operating business) and include rationale.

  Describe the various levels of software testing

Describe the various levels of Software testing and draw a diagram if possible.

  Role of the federal government in health care

Which describes the role of the federal government in health care?

  Cultural diversity needs issues

What is the definition of this disease/disorder and what are common signs and symptoms of this disorder?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd