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

    These formal methods are referred to as "System development life cycle models", and the model that I will be following consists of five main stages: System Investigation, Analysis, Design, Implementation and Review The first thing I will do for my project is the conduction of preliminary investigations into Fred's Car Rentals' current system.

  2. Marked by a teacher

    Investigating a Transactional Website (www.latestdvd9.com)

    4 star(s)

    After having tested the website in four different Internet browsers (Microsoft Internet Explorer, Mozilla Firefox, Google Chrome, and Apple Safari) I have found out that all its features work perfectly on all four of these without the need of any add-on.

  1. Marked by a teacher

    Assignment A: Analysis of Transactional Website

    3 star(s)

    more things while they are at it, if they are satisfied with the service they were provided with they may feel happy with the company and become more loyal. Across a larger scale of customers this will build their customer loyalty base greatly and in the process will generate more sales.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    have been identified: * All of the staff of the business will be using this system but obviously managers will use it more frequently. All of the staff have trained computer skills as they deal with computers every day but not a lot of them will be familiar with a database so therefore I have to make it user friendly.

  1. User Guide to my minibus hire database.

    as it is an auto number field which will be automatically filled out when the next field is completed. - Beside the "Customer ID" label there will be a drop down box, when you click the dropdown button it will show you a list of customer ID's with their names

  2. From the e-commerce strategy you gave me earlier I understand that by having a ...

    law and you are not giving out information about Tom to Harry, for example. You only give out personal information to the correct people. Supplying lists of clients' addresses (email addresses, home addresses, etc.) can be a source of making money providing you have the address holder's permission.

  1. ICT revision notes - IT project management

    Linear Development âThe idea is simple: each element of the design is fully completed before the next element is started Linear Methods âThese allow the development of a new system in an order or sequence. âStages of development have to be completed before the next stage can start.

  2. Applied ICT in business scenario answers

    Input and output data formats. Program flowcharts. (8) (c) After the system has been developed it will be evaluated. Describe how test results are recorded and explain how they affect this evaluation. Results recorded on a table where the test, the data are compared to the expected results and the final results.

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