• 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. Smarts Leisure Park Database Booking System

    I will do this by clicking on properties And I then clicked on the data type and changed it to "Medium Date" Now that I have changed the date to medium date it is shown in the report like this: I must now add the "Dear" and paragraphing of the report.

  2. System requirements analysis

    the macros as well as the buttons used for them and the screenshots of the pages in the booking system. I have used paint because again it is very user friendly and easy to use and the functions of Paint are very useful.

  1. Organising the database at Costsloadsless.

    Create a form This needs to be done so whilst putting the information on the form there will be not a mistake made and it is quick to do. This also could be made as a back up copy. To make a testing method I would make up customer names

  2. GCSE Database Project ICT

    and create a mail merge where a template can be used to send multiple letters whilst the links are put in the receptionist can also create a report on his/her computer enabling them to know crucial information as whether they have paid or not, or made their yearly appointment.

  1. Internal Functions and External Relationships - NWTB.

    e-mail communication between departments, purchase orders being completed using computers etc. * Information available for management that previously wouldn't have been available in time or may not have been in enough detail or as concise * Tighter control as a result of easily accessible financial information * Reduced costs as

  2. ICT - APPLIED - Database on quesitonnaire

    I will use search engines from the most recognised search engines such as Google, Yahoo, AskJeeves, MSN Live Search and AltaVista. To prove that each search engine gives different search results I will test the results first. When I search "Instant Messaging" in: Google: Yahoo: AskJeeves: MSN Live Search: AltaVista:

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

    everything that will need improvement and understand totally how everything works now before I begin to build the new system: * Where to store the collected details of customer's * Updating member system * How to view the collected customer details The current storage At the present time the customer

  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