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

Database - The Problem, the sloution

Extracts from this document...

Introduction

Database write up The Problem: A video shop has recorded all of their customers on card and they find that the card can be easily damaged and hard to continuously organise. The old system is slow and tiring for the workers and can take large amounts of time and the customers have to wait long amounts of time. The current service is not satisfactory and customers have been going to competitors. The Solution: To convert the system to a sufficient standard being quick and affective. This would avoid all the problems of damaged cards and all the other problems involved. When using a database you can access other information quicker than off cards and as long as the software is being looked after the database will never get damaged. You can search all of the database very quickly using the search program. Also the database can be easily trained to new staff. In general the program is easy to use and the speed and quality of the new software will attract new customers and improve the morale of current members and staff. Software Available: Software Use Example Word Processor Produce documents, Letters etc. ...read more.

Middle

Then a search bar will appear at the top of the screen. This will then appear at the top of the screen you can then type what you are searching for in the yellow sections bellow. Type the name or addresses of a certain person or just get sections for a short list, such as all the misters for example. Relationships: Relationships between different fields are vital if the database is going to be used in a professional way. This way something written in one field can directly change the information in another. So sorts and searches can be more affective with the help of relationships. You can access the Relationships page by going onto any field in edit mode. You can access the edit mode by pressing f5. When in edit mode you should click on query/table at the top of the page and then scroll down to relationships. Validation and Verification: We verified our work by printing our work off and checking it we then marked any mistakes on the paper and then modified the database. We then printed our work off again and tested it again and again if we found any more mistakes then we changed the work in database. ...read more.

Conclusion

We made it quicker for the workers in the shop and the customers can no longer complain at the wait that the old system made. I also feel that the software was adequate and the staff would catch on to the new system quickly. The database is easy to learn and anybody with basic computer skills could use it. I could improve my database by making it more user friendly. I could do this by making instructions and guides to find your way around the database. In some ways my database could be easier to use by adding these instructions to help workers around the database. I have already added a menu hyperlink at the top of the screen to quickly access the homepage of the database. Datapower 2 has all the requirements available to complete a successful database and has been very user friendly to make for the video shop. It is easy to train people to use and it is quick to use and this will attract customers. Some of the other plus points of datapower 2 are the automatic things that datapower 2 does for you including writing letters and searches for names, addresses, and films etc. Overall I was happy with the software and the database I created filled all its requirements. Ian Skidmore 10N2 I.C.T ...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 Software 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 Software essays

  1. Planning a spreadsheet database for a gun shop.

    Thank you for all your help. Yours sincerely, Ms Lisa. IMPLEMENT Evidence of error correction: Initial design for sum Final design of sum: Test Results Below is the test plan which was completed with the actual results.

  2. Database design for a games shop.

    Now I can see who is overdue, I can see their details and also the mail merged letter is there to make life easier. The query is handful because it gives me information about the game rented date, returned date and how long it was rented for.

  1. Reviewing different multimedia presentations.

    the start screen of the whole car it took be a while to realise what I had to press the word car to go back as it wasn't clear what I had to press. How effective was the interactivity? The interactivity of this Multimedia Presentations is quite good as it

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    exceeded, met or needed to inform parents and how many students' percentages were green or amber. I created each chart by following the steps above. Step 21 After creating my charts, I decided to put a validation on my results tables, as this prevents the teacher from typing in a

  1. bookings database

    An improvement I would make here would be to increase the font of the Guestnumber so the user can easily see the Guestnumber. Other than this, there are no improvements I would make to improve the effectiveness of the database.

  2. AQA GCSE ICT Specification B

    Spreadsheets and manual files can be difficult to update as the company grows; a database is very flexible and simple with regard to imputing new information. It can change and adapt as the business expands because there is no extra difficulty in having a million records on file.

  1. Research, collect and describe graphics

    Top banner is displayed on every page and does not disturb the user's activities. 1) 2) Source: http://www.sky.com/ Date: 11th Sep 2008. Purpose: To advertise for sky motoring Suitability: Suitable as the advice is being advertised on the service provider itself.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    The modification/corrections highlighted above should be incorporated in the next review. Best of Luck. Regards. Syed Mr.Hussaini. Design I started by an initial design of the menu by hand on an a4sheet of paper. So now I am going to modify it by using Microsoft publisher as my design maker and also considering the user comments.

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