• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1268

PostQuick Parcels Database Solution.

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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

    as I want to search for dates which are not stationary I shall use an algorithm that uses data from today's date ("Now()") I think that ">Now()-365 And <Now()-180" would be suitable to find all people who have booked between 6-12 months.

  2. Organising the database at Costsloadsless.

    o If you lose the card all the information has gone. o You don't need to remember anything because all the information is stored on the card. o If the computer is having trouble recognising the card then there will be no other way of getting hold of the information.

  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

    I will be able to use forms, which has many advantages, like making corrections and analysing data. I can also enter data into one more table and error trapping. Outputs There are three outputs that I require, these are: a reports to show the customer details and all of the bookings.

  1. System requirements analysis

    All the data is saved onto two computers every day and only one of the computers are used and the second one is used a back up if there is a problem with the system or if some of

  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