i literally didn’t understand my teacher at all and was just sitting in class thinking wtf am i going to do in my exam. after watching your vids for 2-3 weeks i understood everything. Thank you so much my exam is at 1:30pm. the only thing i’m 50/50 with is reports and queries
Additional notes :) 10:47: when making a value list or lookup wizard, always turn limit to list to yes. This will limit the values you entered to the list so that the user cannot type any other values. 10:40: don't use the "Between" rule. (Between 1 and 3). Instead list the values separated by commas like this "1, 2, or 3". This is because if you say "between" it can cause complications because the database will validate using ANY NUMBER between 1 and 3 so not just 2, but 1.1, 1.2, 2.5, 2.9, etc. Therefore, the "Between" rule is not suitable for this scenario because there are only 3 FIXED values being level 1, 2 and 3. There is no level 1.3 or 2.7.
Hey, so during validation, as I was testing for whether a record would not save if a surname was not present, it seems as though in the "Student ID" in the Student Table, I am unable to change the ID back to 1 when entering in data, as it says the field is bound to "AutoNumber". How would I now be able to change the Student ID after creating my relationships as well?
This can be a common issue when you create your tables and start to enter data then realise that you need to change the table structure or fields in it. There are a couple of ways to resolve this. 1. You would need to remove the relationship links in the relationship section between the effected table and other associated tables. Then go in to the database table design view for the table that is the problem and unselect the primary key and then delete the field. You’d need to save the table again then close it. Re-open the table and look at the data view to check that the field is completely gone. Return to design view once you are happy and recreate your ID with it as auto number you can drag this back to the top if you wish. Once you save you may get a message box pop up saying that it may effect the records in the table,click ok and then you may also be prompted to select and create your primary key again select your ID and then your table should be ready for you to return back to the relationships for the link between table to established again. 2. A simple option would be to turn your auto number to a number field type. Then manually enter in your “1” as it is a primary key you should be able to enter the values 1,2,3 etc and not be able to enter a duplicate value
@@MyStudentSite thank you so much, you’ve been a massive help, my exam is tomorrow so I’m just ensuring I get any small issues resolved as soon as possible
To be very honest I do not know, however I would suggest in your task 5 the evaluation you could make reference to it. There are past examples of exams where the use of an autonumber would not fit as the ID number chain starts at 1000 .
Please help!! What do you do when someone has more than one table of information. Normally you make you use the latest information and only put them down once but what if you need to add the previous information too for the database?? I am making my 4th table and I don't know what to do as everything I would use for a primary key has the same ID twice as the person has 2 lots of information My test is this Monday!! Thank you.
You may need to use what is known as composite primary key, this is collection of fields in your 4th table as foreign keys that you select together to create a primary key. Please look at my video on composite primary keys to help. How to create a Composite Primary Key in Microsoft Access ruclips.net/video/hRnZVPBF8nI/видео.html
17:14 in the diagram the Student ID in the student table is connected to the Class ID in the enrolment table. but in the real database the Student ID connects to the Class ID. when I was watching you make the diagram at first earlier I was questioning why Student ID connects to Class ID. It confused me a bit lol. Also why is it bad to have a many to many relationship? I get that the enrolment table was created as a joining table to maintain a one to many and many to one relationship, but I don't really understand it or how to phrase it. (When i say phrase it I mean for example: (subject table connected to class table) would be phrased like "one subject can be taught in many classes". How do you phrase that using the enrolment table? Ill look for the answers elsewhere but if someone responded then that would be nice too :) my exam is in about a month. If i find the answer ill reply or edit this comment so if anyone else is thinking the same thing u can have it :)
i literally didn’t understand my teacher at all and was just sitting in class thinking wtf am i going to do in my exam. after watching your vids for 2-3 weeks i understood everything. Thank you so much my exam is at 1:30pm. the only thing i’m 50/50 with is reports and queries
Bruh😂😂
THIS IS SOO TRUE IM GOING TROUGH THAT PHASE NOW FR
Used this channel when I had my IT exams and got a Distinction. Appreciate the videos always recommend this channel to other students 🙌
Just by watching this walkthrough made me realise how screwed i am revising this 3 days before the exam
I’m really out here studying 2 hours before the exam 🤦♂️
Additional notes :)
10:47: when making a value list or lookup wizard, always turn limit to list to yes. This will limit the values you entered to the list so that the user cannot type any other values.
10:40: don't use the "Between" rule. (Between 1 and 3). Instead list the values separated by commas like this "1, 2, or 3". This is because if you say "between" it can cause complications because the database will validate using ANY NUMBER between 1 and 3 so not just 2, but 1.1, 1.2, 2.5, 2.9, etc. Therefore, the "Between" rule is not suitable for this scenario because there are only 3 FIXED values being level 1, 2 and 3. There is no level 1.3 or 2.7.
These are great and valid points, thank you for your contribution.
very helpful! my exam starts in a few hours
How was your exam, I'm doing this in January, do you have any tips.
my exam is next week really needed this, thank you
Yeah same mate shitting bricks
same
gl brooo
this vid has acc helped me alot
i got mine on tuesday and before i watched this video i had no clue on what to do
Part A is good to go, but Part B is needed..
I appreciate the content and would even start a petition for Part B
Thanks for the help
My exams tomorrow im absolutely finished
Thank you for the video
Unfortunately my teacher is horrible at teaching and we have one month until the exam...
Same here. We're so screwed for this 😢😢
I am confused about AutoNumber when I use and when I dont use it etc will I lose marks if I dont use it and use Number instead
hi would like to see some of the part B analysis thnx
it would really help for my upcooming exam in 2 days
Please help 😭😭😭. Where can i download the material that is provided in the exams to work on the databases?
Can you release Part B? I need it this week, i’ve got my exam on Friday.
Same
We all do
This is not the paper for the exam
Thank you. Perfect timing for my Year 12 PPE. This is very helpful.
When will part B be released
very helpful! my exam starts in a few minutes
Ur the GOAT of tiktok my bro. Your instagram vid really helped me. Thank god i found you on twitter
Another Banger, thanks mate
Out here gaining knowledge I didn’t get in class in 1 hour 💀
sick one mate cheers this video is great
Is this all the important information I will need for my exam in this unit?
I still don't understand relationships.
This one caught me off guard in January but I still managed to get a distinction
Hey, so during validation, as I was testing for whether a record would not save if a surname was not present, it seems as though in the "Student ID" in the Student Table, I am unable to change the ID back to 1 when entering in data, as it says the field is bound to "AutoNumber". How would I now be able to change the Student ID after creating my relationships as well?
This can be a common issue when you create your tables and start to enter data then realise that you need to change the table structure or fields in it. There are a couple of ways to resolve this.
1. You would need to remove the relationship links in the relationship section between the effected table and other associated tables. Then go in to the database table design view for the table that is the problem and unselect the primary key and then delete the field. You’d need to save the table again then close it. Re-open the table and look at the data view to check that the field is completely gone. Return to design view once you are happy and recreate your ID with it as auto number you can drag this back to the top if you wish. Once you save you may get a message box pop up saying that it may effect the records in the table,click ok and then you may also be prompted to select and create your primary key again select your ID and then your table should be ready for you to return back to the relationships for the link between table to established again.
2. A simple option would be to turn your auto number to a number field type. Then manually enter in your “1” as it is a primary key you should be able to enter the values 1,2,3 etc and not be able to enter a duplicate value
@@MyStudentSite thank you so much, you’ve been a massive help, my exam is tomorrow so I’m just ensuring I get any small issues resolved as soon as possible
@@MyStudentSite sorry can I just add, would I lose marks if I set the field data type to “Number” instead of “AutoNumber” for the second option ?
To be very honest I do not know, however I would suggest in your task 5 the evaluation you could make reference to it. There are past examples of exams where the use of an autonumber would not fit as the ID number chain starts at 1000 .
Hi my exam is in 10 minutes, thank you
Has anyone done the exam, i have mine tomorrow?
How was it, I'm doing this in Jan can you give me some tips
Would they change the equations you have to use for the May exam or would they keep that the same ?
do u guys know if the upcoming database exam is a national exam
The performance grade ID had blank spaces how do u put that as a primary key if there is blank spaces
Please help!!
What do you do when someone has more than one table of information. Normally you make you use the latest information and only put them down once but what if you need to add the previous information too for the database??
I am making my 4th table and I don't know what to do as everything I would use for a primary key has the same ID twice as the person has 2 lots of information
My test is this Monday!!
Thank you.
You may need to use what is known as composite primary key, this is collection of fields in your 4th table as foreign keys that you select together to create a primary key. Please look at my video on composite primary keys to help.
How to create a Composite Primary Key in Microsoft Access
ruclips.net/video/hRnZVPBF8nI/видео.html
Second part brother, thanks a lot
This was really helpful, my exam is this coming week. When will Part B be released?
Can u release part B need it asap
cheers mate
17:14 in the diagram the Student ID in the student table is connected to the Class ID in the enrolment table. but in the real database the Student ID connects to the Class ID. when I was watching you make the diagram at first earlier I was questioning why Student ID connects to Class ID. It confused me a bit lol.
Also why is it bad to have a many to many relationship?
I get that the enrolment table was created as a joining table to maintain a one to many and many to one relationship, but I don't really understand it or how to phrase it. (When i say phrase it I mean for example: (subject table connected to class table) would be phrased like "one subject can be taught in many classes". How do you phrase that using the enrolment table?
Ill look for the answers elsewhere but if someone responded then that would be nice too :) my exam is in about a month. If i find the answer ill reply or edit this comment so if anyone else is thinking the same thing u can have it :)
Weeeeee, hiiii funny seeing u here :D
For example if the January exam required you to use the IIF statement, would they requure you to use that for the May exam ?
theres no way to tell, it could use it, but then again it could not use it. just gotta wait and see, but better to learn it than not to
is this for level 3?
In the input mask what do all the L’s stand for
These represent letter placeholders. Good luck for your exam on Monday
@@MyStudentSite And what do the crocodile arrows represent?
The > will turn the letters after it capital and then to make them lower case it will be < meaning everything beyond that point is lowercase
@@MyStudentSite What do the 2 consecutive L’s represent? Why wouldn’t 1 L be fine?
brother you got the asmr voice thats finna make me sleep. good video tho
Thank you soo sooo much
Thanks my exam in 2 weeks
same
same
Same I'm pretty worried about it
Can u please post on reports and quires
How come subject Id doesn’t go into the student table
watching this video the morning i have the exam
table testings??
Is this the exam for tomorrow or the exam in January and ours will be different
This is January exam
please post walkthrough on queries and reports
My exam is this week Thursday I need it asap plse
Do you not have to create a word document and document all your errors etc??
Bro just finished part a that was pretty hard but I hope I at least got 28 -30
Hey, great video again, if possible could you release activity 2 Asap as I am learning through your videos which are a great help.
Good video uno
Anything on Part B please?
get this guy to 100 comments
Imma need that part 2 asap
Bro i really respect the drip
Can u please post how to answer quires reports and form questions.
is this the may 2022 exam paper
I did this exam in January, this exact one but I have my retakes this week which is gonna be a different paper
My exam is in 2 hours budding hell
My leather jacket teacher recommended u. Hes a biker
how many comments do you need
I'm here because of Magdalena lol.
Is this the actual exam?
The one that happened in January yes, the next one will be different
pls Activity 3and 4 plsss
ur my guy and all but plz for everyone speak louder
Ty
ay broski release the others pls i need em rn pls