• 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

    User Interface Design My user interface will menu driven based. The menus will be accessed using buttons placed on forms with a label on each to indicate which button corresponds to which form. The forms displayed, selected from the main menu will have titles on them to identify them.

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

    All the user has to do is type in a birth date and it will give a list of birthdates. This depends if the user uses AND, OR, LIKE or NOT in their search. They can also do this to find the customer address or the way in which the customer wants to pay.

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

    To test that these work I will just need to press print on the form (screen shot below) and see if the printouts meet the designated criteria set out in the previous sections. After examining the printed reports I can safely say that they work and all the necessary detail is in place.

  2. Evalutation of a Spreadsheet

    This is very useful because if a spreadsheet is copied by hand, it would take a very long time. If it is copied on a computer it would take less than a second and it is then possible to email it to other people who would receive it immediately.

  1. Unit 6 - Advanced Spreadsheet Skills

    changed to just computer based systems this is the reason behind the new system. It will perform the entire task required like producing charts and graphs to provide evidence to the banks and larger business that the company is a solid worth while investment.

  2. IT-based solutions, embracing the newest IT developments throughout the whole organisation

    The driver will communicate between the hardware and software. With the companies new systems there will be need for certain software to manage the computers or certain departments. For example advertising department would need to have graphical software. Also all the computers would need security software for both malware protection and protecting peoples information from thieves and hackers.

  1. Computing Project

    By computerising the system half the time will be wasted in collecting and passing on the data. The diary is not a very reliable way of writing appointments and if the instructor were to forget the diary or loose it then it would be impossible to continue with the day.

  2. Evaluation of a computerised system

    database A unique ID is generated for each staff member that is entered into the database is automatically generated. * Generate a record for each staff member added into the database When the details of a new member of staff are entered into a Staff form and the 'Add new

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