• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  • Level: GCSE
  • Subject: ICT
  • Word count: 865

Create a database that has a minimum of 2 tables with 15 records.

Extracts from this document...


INTRODUCTION For this assignment I need to create a database that has a minimum of 2 tables with 15 records, also produce queries and reports I have chose to create a database on football players from all over the world. The users for this database will be adults and teenagers. With this database the fans will be able to find out information about their favourite players. The database will look at the following facts about the players. Player's forename Surname Age, Club Domestic league Domestic goals National country National goals The first thing I did was going on Microsoft access. The package that I am going to create my database on. After double-clicking the Microsoft access icon this page got displayed. I then created a new database Before creating the table I needed to fill in the information in design view. This information is based on what the actual table is going to hold. ...read more.


I went on www.yahoo.co.uk to do my research and then I went on the official site, which is www.uefa.com for the facts that I never knew about, this site showed me everything about these players e.g. age, club and goals scored in their career. After completing the table 1 I made another table called table 2 that was going to have players information at international level. The fields in this table are 1) Personnel reference 2) Forename 3) Surname 4) National country 5) National goals 6) Position I used the same process to create the second table the difference was I added some more fields. For the second table I used the same personnel reference and 2 fields that are forename and surname. This is how table looked when it was complete The next thing i done was creating a relationship between the two tables. I did this by clicking on the relationship button. ...read more.


I created a form for both tables. This is how I created it. I entered all of the fields from table 1. and named it form 1 And when I finished this is how it looked I used the same process for table 2. After completing the forms I created a report. This is how I created a report I when on "create a report-using wizard". And entered all of the data from table 1 to it. I named it report 1 And this is how it looked when I had finished I used the same process to create the second report. Evaluation My database looks much better than my original plan; the user thinks that the database was very good and effective. If the user wants to add some more information to the database it can be extended very easily. If I had more time to do this assignment I would have put more information in to it and would have covered more players from worldwide. Atiq zafar 12btw G.N.V.Q ICT intermediate - 1 - ...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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    specific range; it also allows you to put an error message on the cells if you enter a number which should not be entered in those cells. To complete a validation, you do the following: 1) High-light the cells you want to validation to be present within, and select "Data" from the top toolbar.

  2. AQA GCSE ICT Specification B

    1.5 gigabytes (GB) of available hard disk space Super VGA (800 x 600) or higher-resolution video adapter and monitor CD-ROM or DVD drive Justification of Software Choices Functionality: Windows XP is a modern and powerful operating system. The vast majority of people are more familiar with it than with MS

  1. Project 1a. ICT

    I will show you a few slides and how I have designed and changed to suit my audience. Older Slide Younger Slide The screenshots I have used are vital to my target audience because I use images which are relevant for the age range I aim at.


    Disadvantages would be depending on your computer if you fill it up with to much crap your computer will slow down a great amount. XP comes with a firewall but is really outdated now because of all the advance people and hackers using the internet now.

  1. Project 1b; Film Database

    In this screen print I will show the validation rule I set up to validate typed in data for the data field certificate: In the following two screen prints I will demonstrate how the data I type in is validated by typing in unsuitable data.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Out of the few main packages I have talked about, I have decided to choose a spreadsheet to do my coursework on, the specific package I am going to use is Microsoft Excel 97. I have chosen this because it suits my requirements, as I do not need the Vat

  1. GNVQ intermediate ict unit 4

    save my work into my user area, I will also do back up copies on my memory stick which I will keep in a safe place. I will need a spreadsheet package (Excel) and a word processing package (Word) to produce my spreadsheet, the report and the user guide.

  2. GNVQ intermediate ict unit 2 database

    Birth Date Medium Yes No Address Text 150 Yes No Post Code Text 8 Yes No Plan for the Schools Table: Field Name Field Type Format/Length Required? Primary Key? School Name Text 30 Yes Yes Headteacher Text 25 Yes No Address Text 150 Yes No Post Code Text 8 Yes

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