Mairead has attended:
Access Intermediate course
Access 2003
Which is the best way if a student is given 2 text files in a controlled exam and have to import them into access. They are required to create a three tables. Do they create the tables without validation rules and import and then again create the validation rules and re-import to see what import errors there are?
RE: 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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
