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

I have been asked to set up an ordering system for a clothing company to hold stock records and process orders.

Extracts from this document...

Introduction

Design Specification A - Requirements I have been asked to set up an ordering system for a clothing company to hold stock records and process orders. The system should reflect the outdoor image of the company. The company colours are blue/yellow and it has a logo, which could be used to personalise the system. The system must be able to: 1. Hold Information 1. hold the details of 20 stock items including, stock code, description, price and quantity in stock 2. hold customer details for 10 clients including full name, address and postcode, current balance and credit limit 2. Take an Order 1. Input name of client (check if name is on record and generate an error message if not) 2. Input stock code for items required (check for valid code and display item and price each) 3. Input quantity of item required (check there is sufficient stock and generate an error message if not) 4. Repeat for up to 5 stock items 5. Calculate the total bill for the items ordered 6. Apply a discount of 10% for orders over �500 7. Add VAT at 17.5% (including a way to alter this if it changes) 8. ...read more.

Middle

Stock detail (Top part of sheet - macro to return to menu) 2. Client Details (Bottom part of sheet - macro to return to menu) 3. Sheet Three - Label tag "Order" 1. Order Input - Top part of slit screen 2. Invoice - Bottom part of split screen D - Data Fields - "Data" Sheet Stock field headings required 1. stock code Items stock code 2. bin number a number 3. description description of stock item 4. price each retail price of one item 5. stock value calculated from "price each" times "in stock" 6. in stock current quantity in stock 7. new stock input area where new stock can be entered 8. ordered extracted from order form on Order sheet if ordered (IF stock code on invoice = stock code for item, then put in quantity for this item, otherwise do nothing) 9. remaining calculated from "in stock" add "new stock" take away "ordered" Client field headings required 1. S name Client's Surname - it is assumed each Surname is unique 2. F name Client's Forename 3. address Client's Address 4. town Client's Town 5. postcode Client's Postcode 6. account balance Balance outstanding on account 7. ...read more.

Conclusion

Print_Graph2 - selects graph and prints it 17. Process_Order - Selects and prints out the new Invoice. Triggers Update_Client macro. Triggers Update_Stock macro. Triggers Abort_Order macro. 18. Abort_Order - Clears all input cells and returns user to main menu. Possible layout for the Main Menu showing macro buttons F - Constraints - Assumptions 1. Only 20 items of stock are required 2. Maximum amount of stock held will be 100 3. Only 10 clients are required 4. Clients will have unique names 5. Only up to 5 items will be ordered at any one time 6. VAT is 17.5% 7. Discounts will be 10% on orders over �500 G - Testing 1 Comprehensive test data will be required to check 1. All outputs are as expected 2. Invalid stock codes are rejected 3. Clients not on file are rejected 4. Order quantity is not over the current stock 5. Printed invoice matches all data input 6. Invoice total is correct. 7. All cells, other than those required for input, are protected 2 Each formula must be tested to ensure it performs correctly 1. Does it perform the correct function? 2. Does it give the correct answer? 3 Each Button must be tested to ensure it functions as expected 1. Check each macro works independently 2. Check different sequence of buttons to ensure one does not effect another ...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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    2.2 USA SPECIFIC BENEFITS ADMINISTRATION COBRA COBRA stands for the Consolidated Omnibus Budget Reconciliation Act of 1985. It requires the vast majority of employers to offer continuation of coverage to covered employee and their dependents who, due to certain COBRA qualifying events, lose group health plan coverage.

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

    DR DRE IT'S A G THING 2000 �9.00 1 Spice Girls Holler 2000 �5.00 11 Various Artists Gatecrasher: global sound system 2000 �15.00 6 Various Artists Fresh Hits 2000 �12.00 3 Various Artists Now that's what I call music!

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

    There is also no problem why the system can't be built in Access so I am confident that I will not have a problem with the technical side of this new solution. Economic feasibility: As this new system is being built for my A level course I will not be charging the owner of Infernowear.

  2. Smart Card System

    The 32-bit wsock32.dll ships with Windows NT and Windows 95 and runs over the Microsoft TCP/IP stack. These 32-bit environments also have a winsock.dll file that acts as a "thunk-layer" to allow 16-bit WinSock applications to run over the 32-bit wsock32.dll.

  1. Creating a computer system for Wooten Basset Rugby Club

    Here the user will be able to add, alter or delete any records from the Fixtures table. For example if a new fixture has been organised then the user can use the Add Fixture button to add a fixture to the schedule.

  2. Outline the process a PC follows once it has been switched on?

    Many of the errors are conveyed to the user via a series of beeps. As the test is at the very beginning of the boot process the video output is not yet activated. The various meanings of the beeps will depend on the manufacturer of the BIOS chip.

  1. I have been asked to design a system for the United Kingdom Awarding Body ...

    Subject (Subject Reference Code, A, B, C, D, E) Centre (Centre Number, Centre Name, Centre Address) Where the underlined attributes represent the primary keys within each entity. In the candidate entity I decided to use both candidate number and also centre number as a joint primary key as candidate numbers were only unique to their centre.

  2. The United Kingdom Awarding Body (UKAB) has asked me to design a system for ...

    A new record for each customer would be a simple and practical method that could be implemented. This would also provide the basis for a report, which could be more easily created on a database than on a spreadsheet. Data validation is easily implemented on the database package, with different

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