• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

For this project I will be constructing an I.T. solution for Castle Couriers. Castle Couriers is a company, which provides a number of courier services, mainly for car showrooms.

Extracts from this document...


Analysis 4 1.1 Statement of the problem 4 1.1.1 Introduction 4 1.1.2 User Requirements 4 1.1.3 Current system 4 1.1.4 Data Flow diagram of current system 5 1.1.5 Problems with the current system 5 1.1.6 Objectives of the new system 5 1.1.7 Performance indicators 6 1.1.8 Volume of data 6 1.1.9 Hardware and Software 6 1.1.10 End user skill level 6 2 7 Design 7 2.1 Consideration of solutions 7 2.1.1 Manual System 7 2.1.2 Spreadsheet System 7 2.1.3 A specifically designed courier system 7 2.1.4 Access database 7 2.2 Database Design 8 2.2.1 Entity-relationship diagram 8 2.2.2 Table Design 8 2.2.3 Form Design 10 2.2.4 Query Summary 10 2.2.5 Document Summary 10 2.2.6 Macro Summary 10 2.3 Templates 10 2.4 Data entry and Validation 10 2.5 Macros 10 2.6 Security and Disaster Recovery 10 2.7 IT tasks 11 2.8 Schedule of Activities 11 2.9 12 2.10 Test Strategy 12 2.11 Test Plan 13 2.11.1 Function testing 13 2.11.2 System testing 13 2.11.3 Disaster testing 13 2.11.4 End user testing 13 2.12 Test data and Expected Outcomes 13 3 13 Implementation and Testing 13 3.1 Test Results 13 3.1.1 Function testing 13 3.1.2 System testing 13 3.1.3 End user testing 13 4 13 Evaluation 13 5 13 User Manual 13 6 13 Technical Manual 13 Analysis 1.1 Statement of the problem 1.1.1 Introduction For this project I will be constructing an I.T. ...read more.


However, at home, where some aspects of the design will be carried out, I have a newer version of Microsoft Office, and therefore a newer version of Access. This should not cause any problems, however should I wish to incorporate functions not available in the school's version, I will have to do this last. All of the designing will be done in Microsoft Access, with some links to Word, for better quality documents, and Excel, for data interpretation. This is available on all three of the concerned systems. 1.1.10 End user skill level None of the people who will be using the system have any formal I.T. qualifications. Their only previous I.T. experience is based around the use of Lotus SmartSuite. This will be a problem for me because the system I will be designing for them will be entirely based within three programs, Microsoft Access, Microsoft Excel and Microsoft Word. It will therefore be necessary to make the project very simple to use with automatic functions. 2 Design 2.1 Consideration of solutions 2.1.1 Manual System This would be based around data being processed, stored and filed in the form of paperwork, with calculations being manual and documents handmade. -Easily the slowest -Higher risk of loss/damage to data -Complicated and tedious -Lower quality documents -High risk of mis-calculations We have therefore judged that this system would not be suitable for Castle Couriers, as it is far too slow and complicated and will not be better than the current system. ...read more.


Data will be inserted that is valid, invalid and extreme. Sufficient data will be inserted so that each table has at least one row of information. This will test to see if the different masks that have been used are correct or the different data types are correct. Subsequent data will continue throughout the test to make sure that the data is correct. System Testing When the system is complete, the whole range of tests will be repeated. This will ensure that no further problems have arisen. Recovery Testing The computer will be rebooted during procedures to see if data becomes corrupt or lost. If problems are found they can be corrected Acceptance Testing The end-user will be involved at this stage, they must test every aspect of the system to see if it fulfils the requirements that were set in the analysis section. They will be asked to check if each menu is correctly headed, if the system functions correctly and if it is user friendly. Any faults found at this stage can be corrected before the final version is passed on. 2.11 Test Plan 2.11.1 Function testing 2.11.2 System testing 2.11.3 Disaster testing 2.11.4 End user testing 2.12 Test data and Expected Outcomes 3 Implementation and Testing 3.1 Test Results 3.1.1 Function testing 3.1.2 System testing 3.1.3 End user testing 4 Evaluation 5 User Manual 6 Technical Manual Castle Couriers Sam Tibbitts Project Outline ...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. Marked by a teacher

    An introduction to Identity Theft

    4 star(s)

    * Advance Fee Fraud (AFF) and 419 Fraud. This type of primarily electronic fraud is perhaps among the most prevalent and continues to grow. It will take the form of email (spam often sent to millions of email addresses), postal documentation or faxes. Its pattern is said to be predictable.

  2. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    This can lead them to expect the prototype to accurately model the performance of the final system when this is not the intent of the developers. Users can also become attached to features that were included in a prototype for consideration and then removed from the specification for a final system.

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Additional payments infotype (0015) in which you capture the details of annual or irregular earnings or deductions. For Mastek, Indian payroll, they will be LTA and Performance Pay. * Contract elements infotype (0016) * Monitoring dates infotype (0019) * Family details infotype (0021)* * Membership fees infotype (0057), which

  2. Computing Project

    borrowed Due Date Date 10 characters 16/02/2005 The date a DVD is Due back Rental cost 5 characters �2.00 The price of renting a DVD Data Dictionary - (Members) Name Data Type Length Validation Example Data Comment Title String 5 Characters Max Must Only Contain Letters Mr The title of

  1. Video Club Database Project

    Other Names Text (20) Date Of Birth Text (8) Sex Text (6) Address Text (50) Tel number Text (7) ID Card Number Text (16) Two data entry form are needed. This form will be used for several purposes so it needs facilities to * Check to see whether a Customer is already on the database.

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

    able to use one moveable camera to cover the space that three or perhaps four stationary cameras could cover. Therefore, moveable cameras are more cost effective than stationary ones. However, there are disadvantages to using this kind of camera- these are shown below.

  1. Tod's Tyres is a small business that supplies new car tyres to company car ...

    Data will be entered through means of input devices such as a mouse and keyboard; a keyboard is a computer input device derived from the typewriter, where keys pressed communicate discrete commands to the computer.

  2. I have been given the task to design a database for a company called ...

    Design - the design is produced 5. Construction 6. Testing - system is fully tested 7. Implementation - system implemented and users trained 8. Maintenance - there are three types of maintenance: a. Perfective maintenance, where you make the system easier to use or you add new facilities b.

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