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

Design -Consideration for possible solutions - Comparison of alternative solutions.

Extracts from this document...


Design Consideration for possible solutions Comparison of alternative solutions This project could have been implemented in a number of different ways, for example either a database or spreadsheet package could be used, or the current paper based system could be streamlined for a more efficient data management. However, I have decided to use a spreadsheet package above the rest as it contain certain advantages which are very useful within the context of a stocking system for a restaurant. It is far better than a paper based system due to the automation available in a computerised system. This would mean that there would be a lot less mistakes when totalling up invoices and purchase order requisitions. The spreadsheet system also speed up the whole process from hours of paper work to jus a few clicks of a button, and the computerised system will not forget anything, so what needs to be done, will be done, unless the user decided to leave it out. As the spreadsheet system is computerised, all outputs will be printed, so will be much clearer, which would lead to less mistakes on both the restaurant's and the supplier's part. It would also be easier to improve the company's image as all outputs could contain the company logo, which would automatically be printed along with the POR (purchase order requisition). ...read more.


2 With the aid of the user forms, it should be very easy to navigate User forms are also available in Excel, so compares well with Access. The masses of paper, which will have to be used, could cause much confusion, so navigation will not be easy. 3 Access 97 has been known to crash on slower, less powerful machines. So a reliable computer system is required for the smooth running of Access. Excel, less demanding on a system than Access, will still prove to be unstable on extremely slow machines. A paper base system will never crash, however are susceptible to coffee stains, crumpling, ad being eaten by the dog 4 Again with the aid of the user forms, and the manual, the process should not take much time. The process should take even less time in Excel as each cell can have a note attached to it, to act as a reminder to the user of what to do. The user mush hand produce all tasks, so will consume large quantities of time 5 Access is by far the most expensive piece of software, with the latest editions reaching into the hundreds of pounds, then plus the new computer system Excel, although cheaper than Access is still expensive, costing approximately �50. ...read more.


Test plan Test number Test Purpose Expected result Comment / verified 1 Erroneous "landau" Test password upon entry Error message 2 Click all buttons Navigation buttons on front end user form To be taken to the designated page 3 Normal "15" Validation on sales sheet Entry to be accepted and sales sheet to be updated 4 Extreme "1" and "44" Validation on sales sheet Entry to be accepted and sales sheet to be updated 5 Erroneous "hay" Validation on sales sheet Error message 6 Normal "27" Extreme "1" and "44" Erroneous "-8" Validation on menu section Accept entry Accept entry Error message 7 Sales data To see if sales data changes data in stocks Stock details to change accordingly 8 Open then document To see if the auto open macro is functioning The appearance of the program to change to one specified by the macro 9 Close altered program and open new spreadsheet Test auto close macro New spreadsheet should appear as default 10 Click modify "sheet" in modify user form Check that alterations to data can be made The specified area to be unlocked and the user, able to enter new information 11 Enter data into linked cells and calculate by hand, the expected figures To check that all formula function properly Figured should match, which suggests that the formulae are correct 12 Check that all lookups are correct Check that all logical ifs are operational ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Computing Project

    The forms will not be cluttered and the layout of the buttons must be suitable so that there are spaces and blanks. Items must be placed in a logical way in order to make it easier for the user and to make it look nice.

  2. Smart Card System

    language that can be used to develop all kinds of programs, it include designing application for any computer. Besides that, a Java program is also created as a text file with the file extension .java. It is compiled into one or more files of bytecodes with the extension.class.

  1. System I designed in order to produce a promotion package for her newly formed ...

    It is not very useful because many customers are from the same birthplace so it would be difficult for the user to search a customer's record. Customer ID Last Name First Name Gender Birthdate Place of birth 12 MANN HARBAJAN M 11/04/65 GLASGOW 30 CUBRA ROGER M 04/07/59 HALIFAX 6

  2. Computing Project

    many times what happens is the instructor looks at the wrong date, for example if the student asks for April 21st 2008 then the instructor may accidentally open may 21st 2008 and tell the student he is free. But in reality on that day an on that time he is busy.

  1. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    This is not needed at this current time in the company's life cycle, because of this I will not be recommending spending vast amounts of money on this type of solution. The next type of system that could be used would be a custom made solution.

  2. Ilford Cricket Team Data Analysis Project.

    Also backing up data can be a very hard process, because it involves writing up everything or photocopying everything again, which is very time consuming and also means that if anything is wrong once then it is wrong again and all the time is spent on copying it is wasted.

  1. Evalutation of a Spreadsheet

    With the new system you can simply delete the data on the computer and type in the new data to replace it. Also, it makes it easier to add more data where you what it to go within the spreadsheet.

  2. Unit 6 - Advanced Spreadsheet Skills

    with both incoming and outgoing sales and also provide customers service calls. The employees are employed from the local area. The department currently employs around 20 staff members within the call centre. 2.7 Buying This department's responsibility is to call up local suppliers to find out which products are available for the next few weeks of sales.

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