- Messages
- 1,824
- Reaction score
- 949
- Points
- 123
From November 2012 Paper 2 Question 3 PLEASE SOMEONE HELP ME
When you import the N1STORES.TXT into access, do we have to change the names of the 2nd, 3rd, 4th and 5th field and if we do what do we change it to,
this is the link of the exam paper
http://aslevelappliedict.wikispaces.com/file/view/9713_w12_qp_2.pdf
and this is the marking scheme
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_w12_ms_2.pdf
Yes you need to change those.
http://puu.sh/2kxiJ
Second field becomes BranchName as described in the Question itself..
For Third, Fourth, Fifth .. you need to be creative .. and add the fields.. Like I used BranchAddress1, BranchAddress2 & BranchAddress3.
From The question
"Some field names, primary key fields and data types are shown below. Use this information
and to help you to create the tables:"
some meaning that .. they have only given some of the fields and we need to define the rest of the fields ourselves..