Hey there! Sign in to join this conversationNew here? Join for free
    Offline

    0
    ReputationRep:
    Hey Guys!

    My class and I are pretty screwed with this exam and wondering if you guys had any tips or videos that can be used to revise the exam!

    pls halp

    Thanks
    Offline

    1
    ReputationRep:
    Hi guys, I'm starting this exam on Monday but I have no idea what I'm doing at all! please any help
    Offline

    0
    ReputationRep:
    You need learn about DB structures such as tables, columns, rows, keys - primary, foreign, compound and composite, queries - select, append, update, delete and how to manipulate queries to return different results and, finally relationships. Then understand how to apply this to access! Do past papers!

    Also, take a look at Lynda.com
    Offline

    2
    ReputationRep:
    (Original post by titch786)
    Hi guys, I'm starting this exam on Monday but I have no idea what I'm doing at all! please any help
    Hi! I made a table of all the validation rules for access. I'll attach it in a bit. Goodluck for your exam

    Posted from TSR Mobile
    Offline

    2
    ReputationRep:
    (Original post by billystride)
    Please send it to me on pm

    Posted from TSR Mobile
    Name:  14624378772841258300147.jpg
Views: 821
Size:  501.8 KBAttachment 528447528449
    Attached Images
     
    Offline

    0
    ReputationRep:
    sitting it Monday morning , my teachers are struggling with it and I have no idea on how to do macros .
    Offline

    0
    ReputationRep:
    My teachers think we'll need to know action queries for adding new tables/data etc. Also queries and forms for registering new teachers/acts. We also have 6/7 tables, we assumed we would have to manage video information. I am also struggling to get macros to work tho.
    Offline

    0
    ReputationRep:
    (Original post by thiswayitcomes)
    My teachers think we'll need to know action queries for adding new tables/data etc. Also queries and forms for registering new teachers/acts. We also have 6/7 tables, we assumed we would have to manage video information. I am also struggling to get macros to work tho.
    6/7 tables ? Your teachers are crazy! The most there has ever been is 5. I think that there will be 5 tables, and maybe a m:m relationship but that may not even occur.
    Offline

    2
    ReputationRep:
    Lol😂
    Offline

    2
    ReputationRep:
    **** this is unit7...
    Wrong group😭😭😭


    Posted from TSR Mobile
    Offline

    0
    ReputationRep:
    (Original post by joshgallagher24)
    6/7 tables ? Your teachers are crazy! The most there has ever been is 5. I think that there will be 5 tables, and maybe a m:m relationship but that may not even occur.
    The maximum tables will be 5
    Ive got
    Establishments
    Acts
    Rounds
    Artist
    Teachers
    Offline

    0
    ReputationRep:
    (Original post by Bex1308)
    I agree with these tables, however the voting system is confusing me and I'm not sure how it is going to work, since there is different judges and the establishment and teachers can vote in the final round. This seems confusing in terms of tables to me. Any ideas?
    I think they will be
    Acts
    Establishments
    Rounds
    Teachers
    Artists as a link table
    Offline

    0
    ReputationRep:
    Name:  a2.png
Views: 752
Size:  136.7 KB
    Hey guys ive attached a picture above of what i think how the relationships will go
    It is just a guess so dont use it as a guideline throughout your exam
    Offline

    0
    ReputationRep:
    Name:  Screen Shot 2016-05-08 at 14.08.08.png
Views: 731
Size:  348.4 KB
    Hi guys, i have attached what we thought might be the tables with their field names and the relationships, this is also just a guideline, please give any advice or improvements you suggest to these, thanks, and good luck to us all
    Offline

    0
    ReputationRep:
    Personally I don't believe there will be a many to many, instead I think we will have a 1:m to one specific table like the 2013 exam. They haven't used many to many a lot in this exam so cross your fingers!
    Offline

    4
    ReputationRep:
    (Original post by Joshlpearson)
    sitting it Monday morning , my teachers are struggling with it and I have no idea on how to do macros .
    Youtube macros for saving records and macros in general
    Offline

    4
    ReputationRep:
    (Original post by joshgallagher24)
    Personally I don't believe there will be a many to many, instead I think we will have a 1:m to one specific table like the 2013 exam. They haven't used many to many a lot in this exam so cross your fingers!
    Yeah, I was thinking that too
    Offline

    4
    ReputationRep:
    (Original post by XIIIClueLessIIIX)
    Name:  Screen Shot 2016-05-08 at 14.08.08.png
Views: 731
Size:  348.4 KB
    Hi guys, i have attached what we thought might be the tables with their field names and the relationships, this is also just a guideline, please give any advice or improvements you suggest to these, thanks, and good luck to us all
    Looks good
    Offline

    4
    ReputationRep:
    Who's got a unit 9 networking exam as well?
    Offline

    0
    ReputationRep:
    (Original post by Mohsin56)
    Looks good
    Dont think video will be a table. Either Votes or Artists
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Brexit voters: Do you stand by your vote?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • 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.