Set up a pricing system which will automatically work

Assignment Help Database Management System
Reference no: EM132286547

Database and Advanced Spreadsheet for Business Assignment - Spreadsheet Project

The Problem: Fights Transfers are a Dublin based transportation company providing transport services from Dublin Airport to Dublin and the surrounding counties up to 50KM from the Airport.

They have asked you to use spreadsheet software to set up a pricing system which will automatically work out the cost of a transport service, record quotes and create professional looking receipt.

Specific Requirements -

  • They want to be able to clear the price calculations at the click of a button and to be able to change prices easily.
  • They want to be able to change prices easily on any of the three price lists (This project will require four price lists, one for each vehicle type, on the Price Lists page).
  • They want to be able to print this receipt at the click of a button.
  • They also want the spreadsheet set up so that you cannot delete formulas and data by mistake or enter data which is unacceptable.
  • They want a method of recording customer quotes.

Note - Just need to make a receipt on excel using different functions of Excel. Try to work it out on your own and remember: the 'Denton Gazette' assignment shows you how to use these tools.

Attachment:- Assignment Files.rar

Reference no: EM132286547

Questions Cloud

Discuss and share a crisis event from your life : Discuss and share a crisis event from your life. Address the following: What were the precipitating factors? How did you feel? How did the crisis resolve?
Write an effective e-mail message : Read the S cenario below. Decide upon the appropriate content and structure you would use to write an effective e - mail message to your employees.
Effective communication strategies for communicating change : Describe two effective communication strategies for communicating change that are relevant to internal and external stakeholders.
Why is strong leadership imporant : Why is strong leadership imporant to a compney and their succuss?
Set up a pricing system which will automatically work : 6N8383 Database and Advanced Spreadsheet for Business Assignment - Spreadsheet Project, Dublin Institute of Technology, Ireland. Sup a pricing system
Why is it important to clarify organizational mandates : Lastly, why is it important to clarify organizational mandates and mission? Support your thoughts with material taken directly from our text and outside sources
How information technology can be used to assist bureaucrats : Informed decision-making is an important aspect for working in the government. According to Milakovich and Gordon, provide some examples of how information.
International strategies using business strategy : Firms will typically develop their international strategies using business strategy. what is business strategies and what is an example of a firm that has used
Who happens to be a former student of mine : Your boss, who happens to be a former student of mine, says to you "Our new employees seem to be lacking in self-efficacy

Reviews

len2286547

4/17/2019 10:01:48 PM

This is MS Excel Spreadsheet. Please read that document. There is no word limit in this. You just need to make a receipt on excel using different functions of Excel. Please check the pdf file also, This sample will help you in this. You will spend approximately 4 hours on this assignment but you will learn a lot and gain more confidence in your abilities. Try to work it out on your own and remember: the ‘Denton Gazette’ assignment shows you how to use these tools.

len2286547

4/17/2019 10:01:42 PM

Please NOTE Each student must do their own work. Report Presentation – Professional Layout of Spreadsheet. Colours, Fonts, Layout and use of basic Excel Formula’s. You may not need all the tools listed here but give this project some thought and think back on the tools that we used for Denton Gazette. These are the tools that are in your toolbox for this project: Check boxes, If function, Option Button, Combo boxes, Nested IF statements, VLOOKUP’s, Spinners.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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!

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