• 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. The aim of my project is to make the task of the allocation of ...

    See test 5 6) It will allow detailed examination of all characteristics of show, such as the catalogues, the bar, the type of show, and whether it was a professional performance or an amateur, and price it accordingly showing the overall cost.

  1. Database design for a games shop.

    Also the data is stored in tables this will ensure I make few mistake as possible. I can easily access sub menus and input data so you have achieved this task with full marks. The main problem with my company was the overdue rentals, I could not keep up, however you have solved this problem.

  2. Reviewing different multimedia presentations.

    go into or just hover you mouse over what section and it show what it involved. What happened when you did this? When you click on a section, for example braking you go into a sub screen showing the specific parts of the braking system.

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

    mark, followed by the cell range; this then allowed me to work between the two sheets. However, I only needed to do this in certain formulas e.g. the VLOOKUP table, but I did not have to do it during my IF statement as it allowed me to select a different sheet whilst I was creating the statement.

  2. bookings database

    Data to be protected from changes- I have prevented changes in this form by entering 'No' into the properties of the form for 'Allow edits', 'Allow deletions' and 'Allow additions'. This is effective for the user as in a busy atmosphere, mistakes can occur and the user might delete then guest's details.

  1. AQA GCSE ICT Specification B

    My final choice of solution for the new system is option three- a database software solution. I have made this decision because I believe the database offers what my client is looking for in a system. A database would provide a way in which data could be handled instantaneously with little fuss.

  2. Research, collect and describe graphics

    Pos: Easily noticed. Neg: The way that they are repetitious and the same banner is displayed on every part of the site can be putting-off for most users. Size: Compact - snugs in well with the website as a whole.

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