Write down all of the fields that are going to be in table 1. The kind of data it is going to be. E.g. text, number, yes/no.
The fields for table 1 are: -
- Personnel reference
- Forename
- Surname
- Age
- Club
- Domestic league
- Goals.
This is how the design view looked when I had finished writing the field names.
This is how I created the primary key. I clicked on the field that I wanted the primary key to be attached too and clicked on the primary key icon.
I chose the field personnel reference number as the primary key. The reason why I chose this is because, age, club, domestic league, and goals could have been duplicated.
You need to create a primary key to help you later to link up the relationship between the two tables.
This is how the table looked after the primary key was inserted.
The next task was too filling in the tables with the information that I researched on. I went on to do my research and then I went on the official site, which is 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
- Personnel reference
- Forename
- Surname
- National country
- National goals
- 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.
I created the relationship between the two personnel references because that was the first field in each table.
This is how I created the relationship between the two tables
I clicked on personnel reference from table 1 and dragged it to the personnel reference on table 2 and then pressed enforce referential integrity and then pressed create and the relationship got created.
After creating the relationship I needed to create a query that will link up the two tables.
I created the query in design view and then added table 1 and table 2
And then double clicked on all of the fields I wanted to appear in the query.
This is how it looked when I Had entered the two tables and double clicked on the fields I wanted.
After creating the query I tested it if it worked and it did. All what I did was enter the players surname and all of the data that I had put in about him had appeared in the query and both tables had been linked.
This is the result of the query
After completing the query I created a form-using wizard.
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.