Take our quiz to find out what your revision personality is! >>

A2 Applied ICT Edexcel Unit 7 Summer 2014

Scroll to see replies

I'm sitting it starting the 6th May :O so soon!! although my teacher is doing her best haha!! what are your teachers saying?

Reply 81

reed493

Why am i getting a '#TYPE!' error when i try to type in a formula using the builder on my Student form? anyone?

Reply 82

Ozzy999

Anyone who is taking the exam and wants to discuss it in the comming weeks, pm me

Reply 83

khuzi_r

Original post by reed493

Why am i getting a '#TYPE!' error when i try to type in a formula using the builder on my Student form? anyone?

Where are u typing it in? Or could be a syntax error :confused:

Posted from TSR Mobile

Reply 84

khuzi_r

Original post by cdude

Those that are in the google drive file can contact each other :wink:

What do you guys think would be the best way to do good in this exam? Unit 7 is such a long exam with 10 hours!

I was thinkin of revising by practising the tables (although they may not be accurate) , going through making forms that mentiond on the pre release, adding the functions and all, making reports and so on...

Ahh really disliking this exam atm :unimpressed:

Posted from TSR Mobile

Reply 85

Sonia2014

Original post by cdude

I am starting a 'google drive' where we can all share resources.

If you would like to join then please drop me a message with your email and dates on when your exams start.

Please check your private message

Reply 86

012858

Original post by waynewest

Hii, would you be able to message me the pre release spreadsheet and notepad documents pleasee? My school hasnt provided them to us yet! Thanks :smile:

Hi Wayne unfortunately there is no pre-release spread sheets, it’s a matter of going on Access and guess working your way round and getting familiar with Access. If you do need help with anything specific in Access don’t hesitate to ask and I’ll try my best to help!
P.S not looking forward to this exam!!

Reply 87

Dan_Amjad

Original post by cdude

I am starting a 'google drive' where we can all share resources.

If you would like to join then please drop me a message with your email and dates on when your exams start.

Hi, please pm, I start on the 7th of May. Thanks!

Reply 88

Sonia2014

We start on friday :frown:

Reply 89

leonorago

Original post by reed493

Why am i getting a '#TYPE!' error when i try to type in a formula using the builder on my Student form? anyone?

Are you creating a query then a macro? Make sure you have your tables labelled correctly and the txt boxes (on the student form) are also labelled.

Can you link what formula you are using?

Reply 90

khuzi_r

Original post by Sonia2014

We start on friday :frown:

This Friday? That seems pretty early? :holmes:

Posted from TSR Mobile

Reply 91

Eloades11

Just a reminder, please do not post personal details (ie emails) on TSR. If this carries on I will close the thread.

Thank you :h:

(edited 10 years ago)

Reply 92

BinaSchmidt

[Please don't use TSR to discuss exam specifics- thank you. :smile:

]

(edited 9 years ago)

Reply 93

PhenilGudhka

looks like there will be 6 tables
Production
ProductionJob
Characters
Students
AssignedCharacters
AssignedJobs

Reply 94

leonorago

Original post by PhenilGudhka

looks like there will be 6 tables
Production
ProductionJob
Characters
Students
AssignedCharacters
AssignedJobs

The list of tables my teacher has come up with are as follows:
AssignedCharacters
AssignedProductionJobs
Characters
Students
TypesofJobs

These 5 are very similar to the ones you posted above, but we do not have a Production table o.o

Also, I will be updating files on the Google Drive cdude has been sending via email. I will be posting an updated example of Activity 2 as well as the form from Activity 1. If everyone could contribute, that'd be great!

1 Registering Students which involves:
- ensuring their name, gender and preferred production job are present
- generating a unique student number
- storing the students details if all requirements are met
- providing a suitable message for Vicky, so that she knows what is happening

Activity 1 on the Google Drive has been completed. Please check if you are unsure on this part of the exam.

2 Assigning students to characters and other jobs for The Wizard of Oz, using one form only, which involves:
- selecting the production
- indicating what type of production job the student is to be assigned to
- if it is an actor then:
- selecting the character
- displaying details for the character
- if it is another production job:
- allowing the job to be selected

Activity 2 is still incomplete, I have listed the tasks above which have been completed. I will update the Google Drive once these have been completed.

Please try and gain access to the Google Drive, but please contribute as well. We all want to pass this exam.

(edited 10 years ago)

Reply 95

Sonia2014