• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20

Infernowear is a new company run by a self-employed creative designer aiming to producing clothing at reasonable prices aimed at young teenagers who are into the skateboard clothing fashion.

Extracts from this document...

Introduction

Introduction: Infernowear is a new company run by a self-employed creative designer aiming to producing clothing at reasonable prices aimed at young teenagers who are into the skateboard clothing fashion. As this company has just been set up all orders are phoned through and then written down on any spare paper lying around. At the moment the owner has too much freelance work coming through and is unable to spend the time properly designing and implementing an order system even though he is quite capable. This system will be used to record orders as they are phoned through and also to keep track of the different garments and number in stock. User requirements: Specifically the system should be able to carry out the following procedures. * Store the details of customers and their orders * Keep a list of all garments and garment logos * Record and update stock levels automatically after each order has been recorded * Ability to print out shipping labels for each order placed * Ability to expand the product range by adding new types of garment and garment logos to the system * Each logo and garment should have a simple product code that makes identification and inserting into the database easy and fast. * A search option should be included so that stock level and customer orders can be quickly displayed * A variety of data should be printed in reports including shipping labels and the order line. * As personnel details will be stored it is essential that the system is password protected so that it keeps this data safe and complies with the data protection act. Feasibility study: I will now carry out a feasibility study, as it is the first stage of the systems life cycle. After this I will then make a full detailed investigation into the current system and requirements of the new proposed system. ...read more.

Middle

There will also be an auto customer ID number assigned to each new customer. Also I would like to insert a "memo" text box so that any special information about the customer can be logged here, this could include previous complaints and any payment problems. editClothing & editLogos: These two forms will enable the user to add different types of garment and logos whenever new designs are produced. This will make updating the system easy and hassle free because you don't have to manually enter the new products into the complicated forms. FrmOrderline: This form will be where all orders are made; it will use a query called qryOrderline that combines the customer, clothing and logo tables. This data will then be displayed in a sub form within the qryOrderline form. After an order has been made it will then be added to the Orderline table. Report design: My system will include four reports, one for printing shipping labels, two for logos and garment labels these will be stuck to the deliveries as they come in from the printer so that each box of products are easily identifiable when looking in the stock room. The other report will be the master order line consisting of all the customer orders so that Mr Hull can take this into the store room and gather all items needed with out needing individual customer order sheets. Report names: LabelCustomer: This report will be based on the query qryOrderline showing each customer who has an order & with there shipping address. LogoLables: This report will be based on the Logos table giving the user the ability to print out identification labels for labelling the stock. ClothingLables: This report will be based on the Clothing table giving the user the ability to print out labels for identifying the stock. OrderLine: This report will be produced from the query qryOrderline showing all orders with only the customers name and ID; this saves space, paper and ink. ...read more.

Conclusion

I have not been able to test this part of the system, but the report is set up to print on standard A4 labels so I see no reason why it would not work, obviously the label paper would have to match what the system is set up to print. A payment-received option has been added thus only showing orders that have been paid for, on the main master order report. This is a complete success and works with out any glitches or problems. The last performance indicator stat that the stock level should be updateable after each item is booked out. This has eventually been done after a lot of research into SQL and after a lot of time spent getting the syntax just right. It is a small simple piece of code that has fulfilled this last performance criterion. Future enhancements: At this point in time there is no report for printing customer recites, this is quite important but is easily doable and will be completed after Mr Hull gets back from his holiday cruise. Each item could be given a stock location as well as an amount. This would then make sure that if the stock room were to grow the system would already be able to store the individual stock location of any one item. Last but not least it would be a nice idea to include some sort of mail merge so that whenever a letter has to be sent out to all customers it can be automated saving a lot of time manual work. Mr Hull is currently using this system to see whether it's the sort of program that can do the tasks he specified earlier in this document. If this system proves to b built to a high standard he will use it until it needs updating or extra more complicated features are needed, at this point he may be forced to invest in an off the shelf package solution. Unfortunately Mr Hull is on holiday and I am unable to contact him and get any further feedback. Pete Britten Infernowear Database project 1 ...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 ...

    You can use different gross values to calculate deductions. For this reason, you form different totals during a payroll run, which you then use for future processing. Deductions Purpose This component calculates all payments to third parties with the exception of taxes and other statutory contributions, which are deducted directly from the employee's pay.

  2. Computing Project

    returned by LoanID Number Variable Must only be a number 6 The ID of a rental for a DVD Price Currency 6 Char Must only be a number �1.50 The price for renting a DVD This table will contain all the records of those members who have rented out a DVD.

  1. GCSE I.T Security Case Study - Riverside Leisure Centre

    is also used on the premises. CCTV uses cameras around the complex (they are concealed in Riverside so potential intruders do not know where to find them) and these cameras are all linked back to a main control room. These rooms contain security workers scanning the images from all the cameras on the televisions on which they are shown for possible intruders.

  2. Discuss the relationship that exists in the UK between the legal rules that govern ...

    gain investor confidence as it shows investors that the company is acting legitimately and in their interest. Technically law says that the company is its own entity, the company owns itself however there is also this idea that shareholders provide the funding of a company and are the principals, so

  1. Smart Card System

    It still retains full backward compatibility with the existing 1.1--some of which is clarified further--so all existing WinSock applications can continue to run without modification (the only exception are WinSock 1.1 applications that use blocking hooks, in which case they need to be re-written to work without them).

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

    research evidence 17/10/00 - Produce two or three database structures and explain strengths and weaknesses 19/10/00 - Choose design that is most suitable and explain the decision 21/10/00 - Explain how the hardware and software available influenced the design 23/10/00 - Obtain views of potential users of my system using

  1. Computing Project

    * Only one person is permitted to use the system, no-one else requires access * All files will also be password protected. Database * The instructor will be able to add or delete any records as needed * It

  2. Describe the hardware and software used to create and edit graphic images and compare ...

    But this can easily be resolved with wireless mice. Scanner A scanner is a device that captures images from photographic prints, posters, magazine pages, and similar sources for computer editing and display. Scanners come in hand-held, feed-in, and flatbed types and for scanning black-and-white only, or color.

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