... it is going to be. E.g. text, number, yes/no. The fields for table 1 are: - 1) Personnel reference 2) Forename 3) Surname 4) Age 5) Club 6) Domestic league 7) 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 www.yahoo.co.uk to do my ...

See this essay or coursework document in full right now