Access 2003

Hi Mairead, thanks for your query. First of all importing 2 text files to create 3 tables is going to involve either splitting or duplicating some of the data during the importing process, so it might be best to split the data first and then import. Having said that, it depends a lot on situational factors and what you want the final database to be able to do. Similarly, if you are appending imported data to a table the validation rules may already be in place, whereas if the imported data is standalone and forming the basis of a new table, imposing validation rules after the fact may be the best way to go. There is no single best way to do this but the main contributing factor under exam conditions will be the time allowed! Speed may be of the essence!

Hope this helps,

Anthony