• 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

Evaluation of my database project for a car sales business.

Extracts from this document...

Introduction

EVALUATION (ei) In my opinion, the end result of the system is very satisfactory despite the problems that I faced during the development of the system. Following various meetings with Mr. Ghulraham, I can conclude that the system works as intended. This is because all the requirements that were specified were met. These requirements have been evaluated below: REQUIREMENTS FULLY MET MOSTLY MET PARTLY MET NOT MET Add, Edit and delete member, and Cars. Members should have a unique identification number. Validated data entry. Search for members, and Cars. View member, and Cars details. Print out member details. Cars rented should be stored. Cars rented by a member should be shown on their account. A list of customers with overdue rentals needs to be printed when needed Members with overdue rentals need to be fined. Delete rentals that have been returned over three months. Print off archives. Reduce the bureaucracy and storage space. The use of password to ensure security, preventing data loss. The system should be form based. The system should have different colours for each section. Use of buttons due to users' degree of skills. There should be helpful error messages displayed where appropriate. Preview all reports before they are printed. Date display in the rentals screen. Each requirement has been further looked at, discussing problems that I came across when I was fulfilling each requirement. * Add, Edit and delete member, and Cars: It was inevitable that this requirement had to be met as this is one of the critical aspects of the day-to-day activities of Cars Rentals. These functions (i.e. Add, edit and delete) can be performed on the Cars, Members forms. The add and delete function can be performed by the click of buttons; the simplicity of Access allows the user to directly edit a field by simply clicking and typing the new data, so there was no need to make a button to allow this function. ...read more.

Middle

However, the most important parts where data entry was critical, validation rules and validation text were set to display helpful error messages. All the error messages have been written in a way that it informs that user on what they have done wrong and how they can fix the mistake. When data entered into a field does not obey the rules that have been set in the field properties for that particular field, an error message will appear and tell the user what they have done wrong and how they can fix it. The specifications described below are ones that were later set by Mr. Ghulraham after I showed him the system that I created. * Preview all reports before they are printed: New buttons were created in the reports menu to allow reports to be previewed before they were printed to ensure that the report being printed is the correct one. I feel that this was successfully achieved. * Date display in the rentals screen: I feel that this specification was fully met as it is evident that the date is displayed in the Rentals form. This is important for when dates are been entered to help the user know the date at that particular time. USER RESPONSE TO SYSTEM (eii) From the last meeting I had with Mr.Ghulraham, he appeared to like the system and thought that all the specification was met. He sent me a letter of acceptance to show his final decision on how to implement the system. During the creation of the system Mr. Ghulraham and Mr. Uness at Car Rentals were very helpful as they did not hesitate to provide all the information required for the system. During the investigation and analysis stages, I carried out two interviews with Mr.Ghulraham and Mr. Uness. They were both friendly and gave suggestions on what could be done to make the system satisfy their needs. ...read more.

Conclusion

Without instructions, the staff will not no what the preview button is for as it is not self explanatory. These buttons were not named as there was not enough space so icons were used instead. If there was more time I could have added captions to describe what the buttons do when the cursor is pointed on the button. The calculation that fines members for overdue rentals provides a minus fine if the rental is returned early and provides a positive fine if it is late. Even though the specification was still met as it fined members with overdue rentals, I would have preferred it if a fine was only displayed if the rental was overdue. This would make it more effective and convenient to use. Some function within the system will need to be only performed by Mr. Ghulraham, so having access rights would have been more effective. This could not be done due to my limited expertise in using Access. However, since this was not stated in the specification, I have little doubt if this will come at a cost to Mr. Ghulraham. Extendibility: In the future the following additions can be made to the system to make it more efficient: * Create a website to allow members to order rentals online. This function can be done in Access by linking and creating a webpage, where members can register on online application forms etc. * Linking the database to a spreadsheet to calculate weekly takings of the business. This will aid the finance aspects of Hatch end cars. This can also be done in Access by adding up the Cars rented and presenting it in a spreadsheet where calculations can be made. * Produce mail merge in Word Processor to allow letters to be sent out to members. This can be done by exporting details of members and the Cars that are overdue to a standard written letter in Word Processor. These letters can be printed off and sent to individual members. ?? ?? ?? ?? M.A.OMERZEDA 13 RED 2516 ICT COURSEWORK 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 AS and A Level Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    Often the way in which data is held and manipulated within an organization is inefficient or wasteful, so a computerized system is developed to replace a manual storage system, or to replace an inefficient computerized system. In other words, if there is a better and more cost-effective method of handling data, businesses will obviously want to use that method!

  2. Marked by a teacher

    Assignment A: Analysis of Transactional Website

    3 star(s)

    Offering deals can sometimes increase the company's profits greatly whether it is in a short amount of time or over a longer period of time. For example some customers might just go on the site and buy that one item on sale and never return again, whereas others might go

  1. ict as level coursework

    A.1 and A.5 is the cells with the information that has to be displayed, this can be shown in the print screen above. This will then allow the drop down list to show the relevant titles. In order for this customer details page to work, all the details that are

  2. ICt coursework evaluation

    It should be possible to provide reports in less than 1 minute in each in the following. * Customer details. * Total sales by customers. * Total amount of the Sales. � This system will give relevant information in the form of report in less than 1 minute. l.

  1. Feasibility Report

    insight and lastly SONAR(tm) behavioural protection. Key benefits of the Norton antivirus with Antispyware 2009 include; Stops viruses, worms, spyware, bots, and more-It will keep the Perfect Pie Companies computer system protected against all types of malicious threats. Norton(tm) Insight-delivers innovative intelligence-driven technology for faster, fewer, shorter scans.

  2. Free essay

    ICT organisation project

    Other techniques used These are highlighted in the original copy of the magazine: Use of tables Borders and Shading Margin sizes Headers and footers Logos Standard text Paragraph formats Justification techniques Use of automated bullet points/numbering Font styles Font sizes Text orientation Line spacing Use of bold, italic, superscript and

  1. Threats to Data

    Even then you might be unlucky enough to catch a brand new one. There is similar software to recognise and delete spy ware which works in much the same manor. A transactional web site would need both of these to protect itself.

  2. ICT revision notes - IT project management

    Disadvantages âReal projects do not lend themselves to the sequential approach as you often have to go back to a previous stage and make changes. âAt the beginning of most projects there is often a great deal of uncertainty about requirements and goals, and it is therefore difficult for customers to identify these criteria on a detailed level.

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