• 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

Design an application which will give "Ken's Newsagent" a more efficient and reliable way to run his newspaper deliveries.

Extracts from this document...

Introduction

1. Identification of task and general specification "Ken's Newsagent" is located on the edge of a housing estate. It caters for the local needs by providing newspapers, magazines, stationary, plants and confectionary. It has a large clientele, some come into the shop for their newspapers, and others have them delivered. Up to now "Ken's Newsagent" has relied upon a hand written log book contain all the relevant information about newspaper deliveries. The size of the deliveries and the fact that Ken now employs a manager to help with the deliveries means that he now requires a more efficient way of recording this information. The deliveries are split into 5 rounds. Each round covers a particular part of the housing estate. Each house is recorded with the customers name and the newspaper(s) required including the days for each delivery. Some customers only have newspapers delivered on one or two days, some also require an evening newspaper. Customers also tell "Ken's Newsagent" when they will be on holiday so that the deliveries can stop. "Ken's Newsagent" works on a monthly invoice system, sent out with the deliveries on the 20th of each month. ...read more.

Middle

There was only 3 fail overall, I was expecting more than that. The fails are not major failures so I don't really need to go back and edit the database. Ill leave it and just say in the user guide that type in exactly. 7. Program Evaluation If I was to do this again I would build a user interface with home made buttons and background pictures. I could have made the tables better in the way that the work. For an example I could have made the address for the customer a drop down box and just have the roads that Ken will deliver to in the drop down box. And just improve on nearly every thing that I have done. For this is not a very good data base for this is the first time I have made one. But I think if I could make an update version of this data base, I would. 8. User Guide. Customer details table. 1. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms. 2. Type in the First Name of the customer; only use leters in low/high case. ...read more.

Conclusion

Click to start search Delivery Form 1. Display Delivery Number from table 2. Display Customer number from table 3. Display Paper number from table 4. display delivery date from table Paper Form 1. Display Paper name from table 2. Display Paper Number from table 3. Display Paper Relies date; D=Daily, W=Weekly, M=Monthly, Y=Yearly 4. Display paper Costs Query 1. Type in customer number 2. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms. 3. Type in the First Name of the customer; only use leters in low/high case. 4. Type in the Last Name of the customer; only use leters in low/high case. 5. Type in the Address/Hosue Name of the customer; in clude house number with the road name. 6. Type in the Road Name of the customer; only if you have put in the house name in the Address Line 1. 7. Type in the delivery date 8. Type in the paper name customer has delivered 9. Cost of delivery Invoice Go in to report and every think in the Query is made in to a invoice for you and you just have to press print in file, print. If you have any problems call me on 07952130031 and ill come and help you. Craig Linford 03/05/2007 I ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Designing a booking system for an Estate Agent.

    1.5 Evidence of the use of relevant investigation techniques. I will be using an interview technique to find out more information about the client and the existing system they use. I will be using this technique as it is the most effective technique to find out the specifics that the client wants and to identify the current problems that they are having with their current system.

  2. The purpose of this document is to provide a design for an electronic payment ...

    The GUI screen design takes into account colour blindness and internationalisation. 2 Decomposition Descriptions 2.1 Module Decomposition This design document aims to provide a detailed outline of what needs to be extended to the existing S3G system. The aim of the document is to outline what components need to be

  1. The application to be researched is a small company called RS EQUIPMENT. The company ...

    David Johnson and how procedures and measures are dealt with. I was met by the systems administrator and was showed around the office where I had a chance to meet the personnel, and noted down the specification of the network, software and hardware.

  2. ICT Solutions for people with Special Needs.

    Conclusions about the affects of legislation on visually impaired users and the requirements it makes on organisations and individuals involved in supporting them Anti-discrimination laws which extend to the net (Conclusions)

  1. I was hired by Mr Davies to create a website for a newly built ...

    Type in all the pages names. Pick out the same layout as used on the home page Have navigation page on the website. Sponsors * Banner Write the companies Crop the banner to fit the page Have banner on website * Logo Companies logo Crop re-size to the correct size insert into html.

  2. Background and investigation for designing a database for a DVD rental shop.

    is very familiar, although he is willing to learn how to use Microsoft Access. Investigation Techniques Primary Interview with client These are the set of questions that i will ask during my interview that I will be holding with Ashley, the manager and owner of JenJams.

  1. ICT Security Report

    They could also only use special delivery so that they are sure it goes to the correct address and the person specially signs that it whom it is to. EXTERNAL THREATS A business can also face many potential external threats that may try to retrieve or pilfer customer data.

  2. Datbase Project newsagent shop

    I am going to use the Computer and its systems because it is faster, easier to use and more accurate. Besides by using the storage system of the computer, that is, floppy, hard and removable disks and tapes, storage is safer, file are not easily lost or damage and it

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