• 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


    Another feature in vista ultimate is parent control it can be used to deny young children to certain programs. Disadvantages are its requirements are at high rate and consume a lot of hard drive space. Vista ultimate is very expensive and the price rises depending on what country your in.

  2. AQA GCSE ICT Specification B

    It is also carried onto three pages. The note was formatted to create the one on the right; this carries the company logo and is very clear, It is also fitted on one page. Testing Evaluation Criteria Criterion Number Criterion Justification 1. On opening, the main menu should appear, and the navigation panel should not.

  1. Youth Club Database Solution

    many times they have attended the Youth Club, in the previous two Fields. In this Field I have used a tool called conditional formatting and this is how it works: The next column containing a formula in Column N, which adds up all the money which a member owes.

  2. Project 1a. ICT

    By using cartoons like these you can see that the age range is going to be designed for the younger generation. If I was devising this story booklet for someone in my generation or older I would take the opportunity to right a fare bit more as our vocabulary and

  1. Setting up a database in microsoft access.

    Editing Records - This was quite simple to do. I opened my database and searched through the records until I found the one I wanted to edit. I then highlighted the information that needed changing, I retyped the correct information and then saved my database with the new information inserted.

  2. GNVQ intermediate ict unit 4

    You will indicate if records have been broken alongside each event in each Results Grid by using the function: =IF(First Place Time<Event Record,"New Record","") For the Totals grid I have used a SUM function to total up the scores for each team.

  1. A new IT system in a Dubai Marauders Rugby Football Club

    file or JPEG. I will have to add writing to the logo so there is sufficient information for people to contact the club. The program I will use is Adobe Photoshop, but you could use another paint program such as Microsoft Paint.

  2. Database design for a games shop.

    * Popular game: this report will contain, the popular games and genre, once Mr. Walcott has concluded which games will increase the effectiveness of his business, Ben will purchase these games. There will be an advanced query used to search the database: * Overdue games: this search will be done

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