• 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. Financial Model to help organise the year eleven prom

    to be made * A system that can predict ticket prices and the break-even point based on approximate numbers of pupils that are attending. * A system that can store information permanently for following years. II. An efficient way of storing information that can be easily established, so that they

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

    of their own space * Access to lots of different programs that will usually be really expensive * Is heavily protected by firewall * Access internet * Internet censoring system does prevent a lot of viruses * Internet censoring system also prevents people from being distracted from games * Internet

  2. GCSE Database Project ICT

    On the following page is the printout of the report for the secretary. Mail Merge The mail merge was created using a wizard: Then, on the right, we then select the options given to use by Microsoft Word's wizard: After clicking next, you are taken to step two where Word

  1. Database design.

    I could get my customers in order of their surnames by alphabetical order or the video ID in numeric order. In order to create a query you go to new and then highlight the simple query wizard and click ok.

  2. Organising the database at Costsloadsless.

    hour because another customer will come in and they will have to remember there data as well as the first customers * They don't have to pay electricity on the computers therefore saving money for the business. * They will go threw a lot go pressure to remember everything!

  1. System requirements analysis

    1.2 Input, Processing and Outputs a) System inputs (A02.13, A01.41, and A04.41) the patient records were imported from the database to the software. These records were put into a new tab/ excel worksheet which I then renamed to 'patients'. The names above are a few of the names that were imported from the database.

  2. Task 2 - Access Database - ICT CW

    The system already has a screen name and password protection installed and every user has their own name and password allocated to them so this will ensure safety of the system and the data. The employees will be able to access all the of the database as account are kept separately for management only.

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