Blackrock Central Transport is a Dublin based Transportation Company: Database Assignment, UCD

The Problem:

Blackrock Central Transport is a Dublin based transportation company providing services from Blackrock and the surrounding areas up to a 70KM radius.

They have asked you to use spreadsheet software to set up a pricing system that will automatically work out the cost of transport service, record quotes, and create a 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 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.

Report Presentation –

1. Professional Layout of Spreadsheet. Colors, Fonts, Layout, and the use of basic Excel Formulas.
2. You will need all the tools listed here so give this project some thought and think back on the functions, tools, and techniques that we used for Denton Gazette.
3. These are the tools that are in your toolbox for this project: Checkboxes, If the function, Option Button, Combo boxes, Nested IF statements, VLOOKUP’s, Spinners.
4. Macros, Macros buttons.