• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1573

The purpose of my database is to help customer's choose which Music cd or Album they prefer to buy and which is most suitable for their requirements.

Extracts from this document...

Introduction

1 Describe what the User Needs What will the database enable you to do when it is finished? The purpose of my database is to help customer's choose which Music cd or Album they prefer to buy and which is most suitable for their requirements. The database allows them to sort through a wide range of information and gives them opions on which album would best suit them. 2 Describe the data needed what data is needed? For my database to be successful it needs to have the following data: * Basic details of a range of ..... * Cd Names / Info * Artist Info * Cost's * Popularity Of Cd * Record Label / Info Where will you collect data from? I will collect data from a range of sources. These will include internet, artists, magazines and record labels. The most important source will probably be the internet because it is always updated. 3 Describe the tables and the relationships you plan to use How many tables? I plan to create 3 tables. These will be called: 1) Artist Info 2) Cd Info 3) Record Label Info What fields and types of fields, etc. ...read more.

Middle

5 describe how you entered data into your tables I entered my data straight into the tables. This was because it was easier to identify it and easier for people to use it. It also helped me to make sure that everything I entered was correct. I also use extra features for example the "next record" and "last record" buttons these are clearly visible on the screen shot below, I created these so it would be easier for people to move onto the next and previous record and it also improved the design and layout. In the form I had made some changes which improved the design of the form and made it easier to use. First I made some buttons which when clicked on would link to, the next record, last record, find record and exit. I also had to make some changes in the properties make the form better, I removed the navigation buttons and removed the border. So after all the changes the final design looked like this, I changed to option on the navigation option to make it invisible instead I put separate buttons on the form design so it was easier to use and work. ...read more.

Conclusion

I created several back up copies of my data bas this was just in case one got deleted or lost. I saved a copy in school and at home. I checked my work for errors some things that I looked for were, spelling and grammar I done several checks as I went along to make sure that none of the work were spelt incorrectly. I also made sure that the relationships were linked correctly and the form features were working correctly. 8 evaluate what you have done My finished database is different in many ways compared with the one that I has designed for my plan. I added many features which made the design look better and the database easier to use. If I had more time I would have put in many more features and buttons and maybe I would have had more tables which might have allowed me to create more relationships. To extend my database I could put more tables in and maybe I could insert pictures or covers of the albums, which would also improve the quality of the presentation. I made sure that the names of the tables had something in relation with the information in the tables. 1 DATA BASE GNVQ ICT - Sherjeel Akhtar Database report ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Technology to help the blind.

    breaks o Something's very disturbing o Gets lost o One of the bad thing about Braille Watches is that it only reminds you once and that's bad because maybe the person is fast a sleep and can't hear it so they will mess the alarm How the technology meets their

  2. Different types of technology How I use ICT at home and at school

    to the restricted computer settings * School it too virus-amateur and thus disallow the use of USB sticks, CDs etc. Conclusion Overall, while the school computer system does all it can to stay safe, risk-free and without threat, it goes too far into limiting our actual ICT use.

  1. Hardware & Software Requirements for Database

    It will mean that the computer will not work with slow speed as well and work efficiently. Each memory slot can contain 256 MB, 512 MB, 1 GB, or 2 GB of double data rate synchronous dynamic RAM .Whipps Cross Hospital is required to have a random access memory of

  2. System requirements analysis

    If there is, the receptionist will need to fill in this slot with the patients name. the receptionist will then need to book the actual appointment by clicking on the macro that is called 'post appointment.' b) System processes (A02.13, A04.41)

  1. Database design.

    in alphabetical order or by numeric order. Click next and the following window will appear. This window will ask you what style you would like for your report and it also gives you a preview of the style, select one and click next. This window asks you to choose the layout of your report, if you want it in landscape or in portrait view.

  2. Financial Model to help organise the year eleven prom

    Publisher would also be a good program to use because it helps you create brochures; leaflets and also data capture forms. These would be the methods that I would personally choose for the prom committee. Since it doesn't cost anything to build or run, as it is on the schools network.

  1. System administration report

    so each departmental head will have to ensure that these strict rules are being followed. Every department have set up their own short term and long-term objectives in order to provide a clean and concise direction for each employee. The account/finance department has a short-term objective of reaching a minimum

  2. Organising the database at Costsloadsless.

    be able to read it o The files won't get deleted like on a computer. o It is complicated you have to write down what customer has lent what DVD o It takes less time than getting the data programme on o It is inefficient Using a swipe card The

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