• 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 ...

    whole is doing well, and which subjects the class is best in, and what areas need to be improved. To create a chart, I did the following: 1) I high-lighted the data I wanted my chart to display, however, my data was not situated next to one another, so I

  2. AQA GCSE ICT Specification B

    It is new, which means parts and servicing will be readily available, it has enough running capacity to work fast and safely- not crashing. It is of a similar design to the average home PC, making it very easy to use.

  1. Project 1a. ICT

    How the Development Matches the Purpose: There are many ways you can develop a project once you have designed and evaluated it, like I have found out. With my target audience being so young, I can develop my PowerPoint by changing pictures and writing styles to suit this age.


    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

    Now I will set up some validation checks on the two data fields certificate and genre. The following screen print shows me setting a validation check up in the design view of my database. This validation rule is for the data field genre: On the next page I will present the other validation rule I set up.

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

    This computer will take a maximum of 1 minute (preferably 30 seconds) to function from the moment I switch on the computer until it logs on onto a spreadsheet. The saving of data must be fast and efficient (around 5 seconds will be respectable)

  1. GNVQ intermediate ict unit 4

    do technical things like macros Things that I may use to help me: o Textbooks o Online tutorials in Excel o The help function in Excel The resources (people, document, Hardware and Software) I will use: I will be using the school's PC's on the network in the collage and

  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