[ACCESS] Requirements for A2 exam, Need to know how...
I've had this from our head of ICT, can anyone help him out with this? It's been a flippin' long time since i used access.
In the A2 exam students need to be able to do the following;
Create a data entry form for each student the form should collect:
• Student’s name
• Passport no
• Parental consent
• Emergency contact details
Generate the StudentID & display it on the form. A StudentID consists of the first three letters of their surname and a sequential number one higher than the last number.
Now we can do the first part easily how the question on the generation of the studentID is something that we can’t do. I’ve asked 3 other heads of ICT and they don’t know either…struggling!