+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, [ACCESS] Requirements for A2 exam, Need to know how... in Technical; ...
  1. #1

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    2,840
    Thank Post
    785
    Thanked 552 Times in 432 Posts
    Rep Power
    261

    [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
    • Address
    • Dob
    • 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!
    Last edited by Oaktech; 21st February 2012 at 03:22 PM.

  2. #2

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    22
    Quote Originally Posted by Oaktech View Post
    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
    • Address
    • Dob
    • 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!
    Horray for teaching kids the wrong way to do stuff...

    In order to achieve this you'd have to create a separate auto id field in the table to generate the numerical part of the ID and then on the data entry form create a custom field which appends the characters and the ID together and displays it. Nothing in what you posted says that the StudentID in the described form must be held in the database, just displayed on the form, so the auto id field makes your rows unique and the student ID can be "generated" on the fly on the form.

  3. Thanks to ChrisMiles from:

    Oaktech (21st February 2012)

  4. #3

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    2,840
    Thank Post
    785
    Thanked 552 Times in 432 Posts
    Rep Power
    261
    Ok, i've spoken to the ICT chap, and apparently the student ID does need to be stored... Just something else to think on!

  5. #4

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    22
    Why does it? Seems like a general lack of understanding in database driven application development to me. So long as all UI components display the student ID in the format requested, why does it matter if its actually held in a database field or not. Surely thats a design choice that should be left to the student. Your list of requirements says absolutely nothing about the underlying data structure, surely the test is to see if the students can decide a way to achieve what is asked (ie the data entry form in the specified format). By restricting them to one solution, and not even a very good solution, you reduce the worth of the test to basically can the student remember which buttons to press. Anyway an ID like that is fundamentally flawed and would never be employed in a real world application.. What happens if the person's name changes? Should their ID change, or not? If not, doesn't that basically remove any usefulness of employing a name as part of the ID?

    I also think the fact that none of your teachers know how to do it is pretty telling as to the validity of it. Where is the educational benefit? It's just the blind leading the blind.

  6. Thanks to ChrisMiles from:

    Oaktech (21st February 2012)

  7. #5

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    2,840
    Thank Post
    785
    Thanked 552 Times in 432 Posts
    Rep Power
    261
    I don't really have the experience to comment on what you have said from a technical perspective, but just reading it in english it seems to me that you are right, there is more than one way to skin a cat, some are more correct than others, and it should be up to the students to design something that works in the most elegant way they can think of. I will pass your words on and we will see what is said.

    I fear, however, that the concept and specification of the project may have been passed down from on high and then been left to the teacher to implement. The teacher involved is unlikely to set something he doesn't understand how to do!

  8. #6

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    22
    I've been developing database drive applications for 15 years and this is how I'd see a student doing it to satisfy the requirements using access, make of it what you will. I cant think of any other way to do it that doesn't involve writing vbs code which I assume you don't teach your students.
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 1st February 2011, 09:02 PM
  2. Replies: 26
    Last Post: 13th December 2010, 10:09 AM
  3. Replies: 35
    Last Post: 6th April 2010, 01:14 PM
  4. Replies: 1
    Last Post: 15th September 2007, 09:56 AM
  5. All i need to know
    By danIT in forum General Chat
    Replies: 3
    Last Post: 14th July 2006, 06:55 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •