• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Make a system, which can print of invoices for customers who place an order via the telephone, which will show details of price, vat, delivery charge and other calculations.

Extracts from this document...


Problem My friend owns a bookshop in his local town called "The Book Warehouse". They buy books in bulk straight from the publishers for cheap prices and then sell them off separately for retail prices. That's how they make their money. The company is divided into two parts. One part deals with everyday High street customers and the other part is phone based. My friend takes care of the phone based part on his own. Customers from all over the country phone the shop and order their books. My friend writes down the name of the book that the caller wants and their phone number. The reason he takes their phone number is because he has to find out how much the books costs and then has to calculate the V.A.T, delivery charge and maybe a discount if a large quantity of books are ordered. This takes too long and so my friend just decides to call the caller back instead of the caller staying online. When my friend has called the caller and they have decided to order the books, my friend then has to fill out an invoice with all the calculations twice. ...read more.


Here are a list of possible spreadsheet packages: Spreadsheet QC �149.00 Microsoft Excel 2002 �281.86 Lotus 1-2-3 Millennium Edition �270.74 Crystal Deluxe �339.99 Quattro Pro �139.99 I am going to use Microsoft Excel as it has a variety of tools on offer, which I think will be well suited to my system. I have also chosen this package as it is cheaper than most of the other packages, as my friend is on a low budget. My friend is already familiar with some Microsoft packages as he did a management course using Microsoft Word. For this reason I am going to use Microsoft Excel for the system. As he knows the basic layout of Microsoft Office already, then I see no point on making him learn something completely different. Tools His new computer came with a laser desk printer, so he can use this for fast, good quality printouts. This will make the company look professional. Tools im going to use in Excel: Vlookup: This function helps you locate data in a list. It searches vertically down the leftmost column of a list and then reads across the row to find the data or value in the column you specify. ...read more.


System Objectives * The system should be user friendly. I am going to do this by making a homepage, which would have macros on it. These macros would be able to take the user from sheet to sheet without getting lost or stuck. The other sheets will have macros on it to take the user back to the homepage or to other sheets. There will be macros in the invoice sheet. These macros will help the user in various situations. I.E. suppose the user has done one invoice and then needs to do another one, instead of the user having to clear all the data from the past order manually, the user can just click the macro and it will clear everything for him. Another macro allows him to print the invoice just by clicking it. * Minimal amount of effort required by the system. The user should just type a few numbers in the Vlookup and all the information should come up. The computer should then calculate the total price, V.A.T, delivery charge and various other calculations automatically, leaving the user to only click the print macro to print the invoice. * All the calculations should be worked out by the system correctly, all the macros should work correctly and all the Vlookups should work. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Video Rental Shop I.T. System

    This is when data is entered twice to make sure the data is accurate. E.g. this is used commonly in when setting passwords. DATA SECURITY INTERNAL AND EXTERNAL THREATS TO ICT SYSTEMS Data and programs are vulnerable to deliberate or accidental loss or damage form within and outside the organisation.

  2. Creating a computer system for a video rental shop

    Customers are automatically numbered. For this reason automatic incrementation is used. This form will be accessed from the editing form, which is reached from the main form. There will be a button to add customers and delete customers and also a find button.

  1. Creating a computer system.

    The system must record sales and profits * The system must record customer names, telephone numbers and addresses * The system must record customer Ids * The worksheet must be protected so that users cannot change or edit the system, unless they are required to do so.

  2. Model Price Chart.

    altering are the prices for that year which is extremely easy and quick to do. There is a minimal risk of calculation errors, as the programme adds up totals etc. itself, without any input from the user except the formula and cell references.

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    * Products * Services * Price * Size * Vat and other taxes * Discounts * Availability The processes carried on the data will be: * Sum * Multiplication * Vlookup * subtraction * If * List (validation) * Percentage Output The company will use 3 different ways to present the outputs * Monitors * Paper (A4)

  2. Create a power point presentation for people who dont understand cricket so I can ...

    in watching it, they would know where the world cup is going to be held 16 Top ten teams in world of cricket The names of the country with its flag for each of them The audience would know what teams perform at international level 17 Sources The websites where

  1. Creating a computer system for a mobile phone shop.

    The tblPhones is linked to the tblFeatures in a on-to-many relationship because a phone model can be bought by more than one customer, but each customer can choose different features. This is how I decided what fields would be in each table.

  2. I will be analysing the problems defined by the management in the old system ...

    * MS Access is a database program. * I am much familiar with the MS Access interface. * Tables are simple to create in MS Access as it is 'automatically' created i.e. you only have to define the field name, field size and data type for the field.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work