• 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)

    Evaluation of methods used to engage, retain or entice the customer The purpose of offering deals is to try and entice their customers to purchasing from them and in the process the company is hoping that they may buy more than that one item and return to the site again.

  1. ict as level coursework

    I will have to do this by click on each individual text box and going to the control source. For the example above I would click on the 'first name' text box, go to control source and type in: customerdetails!c2 this is because customerdetails is the name of the spreadsheet therefore the information should be diverted there as well.

  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. Threats to Data

    they intend to process the personal data before they collect any data from them. 3. Adequate, relevant and not excessive. Where information is to be used or disclosed for direct marketing purposes, transactional website should be provide individuals with the opportunity to prevent this.

  2. Feasibility Report

    With a backup system, all data from the formatted system can be viewed, accessed and saved onto another system. Conclusions And Recommendations Software Needed The Perfect Pie Company will need to invest in antivirus/spyware software, and integrated packages like Microsoft Office 2007.

  1. Free essay

    ICT organisation project

    The font size also remains consistent in the main body of the text. There are instances where the font style changes to another readable font, for example Arial. This is when the topic of the article shifts, from a health issue to a youth scheme.

  2. ICT revision notes - IT project management

    The model does not accommodate this natural uncertainty very well. âSome clients will want to see a rough working version in order to make comments on it and this method does not allow for this. âA working version is not produced until late on in the project development.

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