Mr Jones - Year 12 GCE Applied ICT - Monday 6 March

Refer back to my work set for last lesson (Friday)

'Make a copy of the csv datafile from the 6th Form folder in the shared documents area. Load this into Excel to analyse the fieldnames and data structures present. Then decide on two or more table names for your database and create appropriate fieldnames, datatypes, field lengths, data formats and validation rules for each field. Finally, import the relevant data from the datafile into each table and make a relationship between each of your tables.'

This work is to be completed by Monday 6 March 2006. If this part has been finished, use the example weblink shown below to get some idea about how you will create and use this database to meet the requirements for the project:

http://www1.edexcel.org.uk/gceict-eportfolio2/DataBase.htm