• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  • Level: GCSE
  • Subject: ICT
  • Word count: 1268

PostQuick Parcels Database Solution.

Extracts from this document...


AS PRACTICAL EXERCISE FOR SUMMER 2001 EXAMINATION; PostQuick Parcels Database Solution. DEFINITION OF DATA REQUIREMENTS It has to have the ability to store details of customers and parcels. Each customer has their own Identification and they have many consignments, which contain more than one parcel. Customers are charged per parcel by weight it has to check the price of each parcel consignment, to produce an itemised consignment note for each customer. The details actually stored need only include information for 1day. Customer details include: * Name * Middle Name/s * Surname * Business * Telephone * Address * Postcode * Customer ID Consignment details include: * Consignment number * Customer ID * Total weight * Total cost * Deliver to * Address * Postcode Parcel Details include: * Parcel number * Consignment number * Length * Breadth * Height * Total dimensions * Weight * Cost according to weight Cost details include: * Weight * Cost ENTITY RELATIONSHIP DIAGRAM HAS WHICH CONTAIN A customer will have more than one consignment, as they may need to send different batches of parcels to different places. These consignments therefore have one or more parcels within the individual consignments. ...read more.


then a short message should appear in the form of a message box, to tell the user to correct the data entered. ? Parcels have to be heavier than 1 kg and lighter than 30 kg ? Parcel length can't be larger than 150 cm ? Consignments can't be heavier than 200 kg RECORD STRUCTURE, FILE ORGANISATION AND PROCESSING The information of each customer, consignment and parcel are entered and recorded in the Customer details, Consignments and the Parcels forms as shown in the user interface design section. They are linked together as follows: A Access query is used in combination with the consignment form to create the itemised consignment note. SECURITY AND INTEGRITY OF DATA: Most places where data has to be entered by the user have set data types; this helps to keep the integrity of the data by minimizing mistakes. E.g. if the data type of the weight of the parcel is set as a number then only numbers can be entered in this field. Also see validation rules. Data, which is calculated by the computer, can't be changed unless the data in the fields within the formulae are changed. The database will have various security passwords, which only allows employees access to the customer details. ...read more.


Dim cost As Variant Forms![Consignment]![Total cost] = DSum("[Cost]", "parcel", "[consignment number]=Forms![Consignment]![Consignment Number]") cost = Forms![Consignment]![Total Weight] End Sub Total weight = Private Sub Total_Weight_Enter() Dim tot As Variant Forms![Consignment]![Total Weight] = DSum("[weight]", "parcel", "[consignment number]=Forms![Consignment]![Consignment Number]") tot = Forms![Consignment]![Total Weight] If tot > 200 Then MsgBox "Tot weight must be <=200" End Sub Note: I built in a validation rule for the Total weight (total weight must be <=200" Below is the query that finds all the parcels in a certain consignment and displays this date this table can then be merged with the consignment form and this is then the itemised consignment note. TEST PLAN: I will test the all of the validation rules and some other places were data entry occurs to see if any other validations or data types can be applied to fields to make it harder to enter incorrect data. But mistakes will happen when data is entered but it is virtually impossible to create a database where incorrect data cannot be entered but it is possible to minimise this risk. TESTING EVIDENCE: Test with parcel weight with a decimal place. The field automatically rounded the decimal place to the nearest hole number. Which was from 1.5 to 2. Test with weight larger than 30 Test with length larger than 150 Test with invalid data type entered Test with weight less than 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 GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. GCSE Database Project ICT

    Auto number Appointment ID Auto number NHS No Text Appointment Status Lookup Gender Lookup Patient ID Auto number Date Of Birth Date Staff ID Auto number Patient Forename Text Appointment Date Date Patient Surname Text Appointment Time Time Patient Address Text Appointment Details Text Patient Address Town Text Treatment Code

  2. Organising the database at Costsloadsless.

    o It saves writing down all the information you just pop the card into the computer and it will bring up all the information about the card holder. o A card is really easy to get damaged. o It is instant and easy to use.

  1. ICT - APPLIED - Database on quesitonnaire

    The above shows me that none of the search engines are similar in any way and all give different number of results by a great deal. I have typed in "Instant Messaging" in all of the above search engines accurately with all giving me worldwide results and the number showing

  2. Smarts Leisure Park Database Booking System

    Also it will need to store customer bookings, details and one that I will need to devise. These will all be in reports that I will need to create. Report 1 Customer Details: This report will show all of the customer details, and will be used to identify the customer correctly.

  1. System requirements analysis

    Booking tickets for travel. This is an example of a booking software for a travel agency. Most of these input details will not be needed for Howard health centre, but the input forms, e.g. Drop-down menus and tick-boxes may be useful to create a software for the health centre.

  2. The end user of my program is for the people applying for the insurance ...

    When all the factors concerning the insurance are found, with their multipliers then the calculations are carried out and a quote is given. This method is both time consuming and is prone to human error. At the end of the day my project will accomplish all of this and will satisfy the hawk's car insurance company.

  1. Internal Functions and External Relationships - NWTB.

    He does also help to identify training needs of members and organise training events. Some of the benefits of using ICT within the NWTB * Improved accuracy - from basic typing of letters to automation of financial spreadsheets * Faster processing leading to faster responses e.g.

  2. Create a database solution for a college tutor.

    I will be providing a manual with my created system, which will teach him how to perform database tasks, and also back up the work. Hardware and Software Existing software and hardware and new soft wares to be installed, e.g.

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