Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    What does everybody think of the 2017 Pre-Release?
    Offline

    0
    ReputationRep:
    (Original post by Mr.IT)
    What does everybody think of the 2017 Pre-Release?
    I think it might just be the final nail in the coffin.
    Offline

    0
    ReputationRep:
    The Thread is lit today
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    Hey, any ideas on what we have to do??
    Offline

    0
    I think that this Kennel is really a front for a Chinese takeaways supplier.
    Offline

    0
    ReputationRep:
    How do you guys think the supplies will work??
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by Gibbo55)
    How do you guys think the supplies will work??
    Not too sure to be honest. Haven't really gone over it well in lesson so far. I assume there'll be forms and will need to connect different tables to match customer wishes to what the kennels can offer? Any ideas yourself?
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by kieranm9090)
    My teachers along with several other teachers in and around the UK have built a mock up of what could possibly be the solution to the exam, however obviously it is only a guess as always and only using what we have got with the scenario.

    We think at the moment that there will be two stand-alone tables that will be there for the operation of forms. An Employee table and Supplies table. We think that the supplied table could be there for an operation to occur to print/create a report for the employee's to then state what supplies they are low on, and hinting to order more. We think that the employee table will be there to login as always, but to notify in the login process the roles of the employee, whether an admin or 'other' (we will call it that for now), and so the admin can add a new employee and possibly order, but we think that it is a possibility that we have one employee ordering many supplies in a sense that all the employees can order, and so we would be able to link them two tables.

    This is just a guess but it's pretty good.

    We also think that the other tables can be;
    Owner,
    Dog,
    Package,
    Activities,
    Visits.

    They will all link together with 'one to many' relationships with one owner owning many dogs etc.

    That is what we have so far, we so far have gone through the possible tables and what to do to add a new employee with a unique username with a number or variables simply using a query.
    Thank you for this! What you are saying makes perfect sense! I will look into this tomorrow when I have ICT
    Offline

    0
    ReputationRep:
    Can someone please attach or pm me a copy of the pre-release?
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by kieranm9090)
    No problem haha, I think it is pretty much exactly what is going to happen as lets be honest. The course has been going for 8 years I think? With it being the last exam of this spec, they don't have much room to change, and so implementing ideas from other exams, you can make the full scale exam from the scenario.

    The teachers who are giving us this information and helping us through this are also generating data at the moment and will provide it for us after the half term, and so once I receive the data, I will upload it onto here so you can practice with the data generated by the teachers.

    (Note to moderators; it is by no means the data from the exam, it is the data that has been generated by our teachers as a guess to what could be on our final exam and for prep purposes only)
    Aw thank you so much that will be of immense help to me! Let me know please when it's ready
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by kieranm9090)
    Will do, might be after the half term, but I will be sure to upload asap
    Thank you!! )
    Offline

    0
    ReputationRep:
    (Original post by kieranm9090)
    My teachers along with several other teachers in and around the UK have built a mock up of what could possibly be the solution to the exam, however obviously it is only a guess as always and only using what we have got with the scenario.

    We think at the moment that there will be two stand-alone tables that will be there for the operation of forms. An Employee table and Supplies table. We think that the supplied table could be there for an operation to occur to print/create a report for the employee's to then state what supplies they are low on, and hinting to order more. We think that the employee table will be there to login as always, but to notify in the login process the roles of the employee, whether an admin or 'other' (we will call it that for now), and so the admin can add a new employee and possibly order, but we think that it is a possibility that we have one employee ordering many supplies in a sense that all the employees can order, and so we would be able to link them two tables.

    This is just a guess but it's pretty good.

    We also think that the other tables can be;
    Owner,
    Dog,
    Package,
    Activities,
    Visits.

    They will all link together with 'one to many' relationships with one owner owning many dogs etc.

    That is what we have so far, we so far have gone through the possible tables and what to do to add a new employee with a unique username with a number or variables simply using a query.
    Thanks thats very useful for my unit 3
    Offline

    4
    ReputationRep:
    Thanks guys, this is lit.
    Offline

    4
    ReputationRep:
    (Original post by Muhammad IT)
    The Thread is lit today
    Buckle up, it's about to get more so, Literally.
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by kieranm9090)
    At 10pm tonight I will be putting up the data that has been generated for practice purposes. There is no supplied data but this is gonna be a stand along table so irrelevant at this time. Keep checking around 10 tonight.

    (It's also the time I get home 😂)
    Splendid! I eagerly await
    Offline

    5
    ReputationRep:
    (Original post by LGBTvoice)
    Splendid! I eagerly await
    So you get notification
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by kieranm9090)
    These are the two text files that have been generated. Have fun and get practicing.
    The BookingINFO text file has the information of owners, dogs, packages, activities etc, whereas the employee table has...well the employee details.

    As I said, this is just a guess and not what might be on the final exam, and so don't quote the data, however it gives an excellent overview of the type of data we will see and you can use queries, tables, macro's, forms and reports to make a mock up of what you might be the actual design. I will get my copy of the database and share it on here tomorrow too, I will be uploading it to show my view of what we have come up with, and hopefully we all agree!

    Have fun and let's smash this exam!

    (A correction to my last post which was done on my phone, so excuse the mistakes. It is meant to say that there is currently no 'Supplies' data but that is going to be a stand alone table and will simply be there to either connect with the employee table and/or work forms. The employee table will operate a login form, no doubt about it, but possibly others, have a try and see what you think)
    Thank you so much for sharing! I'll keep checking back to see what else you come up with. I'll have a play around over the weekend and let anyone know of anything )
    Offline

    1
    ReputationRep:
    (Original post by kieranm9090)
    These are the two text files that have been generated. Have fun and get practicing.
    The BookingINFO text file has the information of owners, dogs, packages, activities etc, whereas the employee table has...well the employee details.

    As I said, this is just a guess and not what might be on the final exam, and so don't quote the data, however it gives an excellent overview of the type of data we will see and you can use queries, tables, macro's, forms and reports to make a mock up of what you might be the actual design. I will get my copy of the database and share it on here tomorrow too, I will be uploading it to show my view of what we have come up with, and hopefully we all agree!

    Have fun and let's smash this exam!

    (A correction to my last post which was done on my phone, so excuse the mistakes. It is meant to say that there is currently no 'Supplies' data but that is going to be a stand alone table and will simply be there to either connect with the employee table and/or work forms. The employee table will operate a login form, no doubt about it, but possibly others, have a try and see what you think)
    Can you upload your database please mate.
    Offline

    1
    ReputationRep:
    (Original post by kieranm9090)
    These are the two text files that have been generated. Have fun and get practicing.
    The BookingINFO text file has the information of owners, dogs, packages, activities etc, whereas the employee table has...well the employee details.

    As I said, this is just a guess and not what might be on the final exam, and so don't quote the data, however it gives an excellent overview of the type of data we will see and you can use queries, tables, macro's, forms and reports to make a mock up of what you might be the actual design. I will get my copy of the database and share it on here tomorrow too, I will be uploading it to show my view of what we have come up with, and hopefully we all agree!

    Have fun and let's smash this exam!

    (A correction to my last post which was done on my phone, so excuse the mistakes. It is meant to say that there is currently no 'Supplies' data but that is going to be a stand alone table and will simply be there to either connect with the employee table and/or work forms. The employee table will operate a login form, no doubt about it, but possibly others, have a try and see what you think)
    i'll show u a good smashing lmao

    (Original post by jet399)
    Can you upload your database please mate.
    i'll upload a right good smash m8
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    I've had a play with the data and made the owner and dog table, however I'm confused what to do with regards to the validation and any input masks. The OwnerID also confuses me because of the 6 letters and 4 numbers which obviously needs to change depending on the owner. My relationships are also not working as I can't seem to get one to infinity when I connect the OwnerID from tblOwner to tblDog. Any help anyone can give?


    Posted from TSR Mobile
 
 
 

1,118

students online now

800,000+

Exam discussions

Find your exam discussion here

Poll
Should predicted grades be removed from the uni application process

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.