I have just started to work on this assessment with my Higher classes.
It is all quite straightforward apart from the auto-number field for Traveller ID. The sample data states it has to be in the format of ‘1000’, i.e. starting at 1000. The file supplied by the SQA uses this format.
However, I have no idea how this is achieved in Microsoft Access. There is nothing in the field’s properties settings of the SQA version of the file to suggest how they achieved it. I have used online help and ‘googled’ it and all the solutions to achieve this point towards writing SQL.
Can anyone tell me if this is achievable without writing SQL, or did the SQA just import the data from a spreadsheet, starting at 1000?
Vale of Leven Academy