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


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.


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.


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. AQA GCSE ICT Specification B

    There must be a 'Total Cost' box on the order sheet, calculating the sum of 'Personalization' and 'Duck' costs. This allows information to be readily on hand and prevents human error in calculating totals. 12. Each button on the main menu must have a simple explanation.

  1. Evaluating a relational database solution

    I could see my tables just by clicking on the design view. Producing reports was quite easy to do, I could chose which queries I wanted to use in the report, and by using the 'show' row again, I could decide which field results I wanted to show.

  2. The aim of my project is to make the task of the allocation of ...

    We will change the selection and see whether or not the grand total changes according to the cost of the show. OK. The drop down menus were used with the previous test. See pictures on page 17. It will solve the problem of the requirement of a calculator, which would

  1. Project 1a. ICT

    This would make it harder for a learning child as words sink in more if you can see this clearly. Design Layout Also I use more complex layouts to make the page more used so that the pages are not blank in parts.

  2. Setting up a database in microsoft access.

    As evidence of these queries I did screen prints of my results. Data Entry - After I had completed testing all of my queries I had to enter all of the information I had collected. I typed in all 30 records and my validation rules helped to make sure I did not type any errors.

  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. Fix the problem of the car company's storage problem, using either excel or access.

    Yes definitely, this is one of our biggest problems; we don't want other people to see out details 4) I have a proposition for you, I am willing to design you a better type of storage using ICT, and would you accept this?

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