Computers & ICT: Post your doubts here!

[Student of the year]

w12 q15
Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.


And I am extremely SORRY for posting the ans late....
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....

 

[syed1995]

Hey Friends,
Just like you`ll even I found w12 q15 confusing and somehow had to complete it bcz had to submit it today,
& after spending several hours on trying diff ways to solve this ques, I finally got a simple & short method
{anyways we can solve the ques in any way until we get the right ans},
but this method is quite short:

Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.


And I am extremely SORRY for posting the unrectified earlier ans and causing trouble for you guys........
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
Sorry once again...

JazakAllah

These are much easier. When and where are you appearing for the paper mate?

 

[Tkp]

well thnks fr helping me and it worked earlier but help me in q 11 and 13 of mj09

 

[Tkp]

Hey Friends,
Just like you`ll even I found w12 q15 confusing and somehow had to complete it bcz had to submit it today,
& after spending several hours on trying diff ways to solve this ques, I finally got a simple & short method
{anyways we can solve the ques in any way until we get the right ans},
but this method is quite short:

Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.


And I am extremely SORRY for posting the unrectified earlier ans and causing trouble for you guys........
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
Sorry once again...

thnks. no need to tell sorry.

 

[AngelicBeauty]

Hey Friends,
Just like you`ll even I found w12 q15 confusing and somehow had to complete it bcz had to submit it today,
& after spending several hours on trying diff ways to solve this ques, I finally got a simple & short method
{anyways we can solve the ques in any way until we get the right ans},
but this method is quite short:

Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.


And I am extremely SORRY for posting the unrectified earlier ans and causing trouble for you guys........
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
Sorry once again...

no that was proer....i did it the way u showed!!!! jazakillah....n pls dont be sorry

 

[Student of the year]

no that was proer....i did it the way u showed!!!! jazakillah....n pls dont be sorry

Waiyakum......
i know that was right too......but this one is quicker & easier,
and finally its on you to do the way you want....
anyways,
All the best.......exams date have approached.....and do pray for me as well....

 

[Enes]

its from d marking scheme
1.go in d design view click on "release date"
2.in d validation rule enter ">=#1/1/1900# And <#1/1/2012#"
3.in d validation text enter "Data entered should be from the year 1900 and before the year 2012."
4.check if there r any dates less than 1900 or more than 2012 if not ,then its right!!
5.enter a date which does not fit in d given range like 2/3/2013 or 2/3/1800 , this will give u an error msg so u take the screenshot of that error msg and place in it the evidence document, in the table that u have created.place it in the outcome coloumn of the abnormal data!!!

i hope u understood

Thanks a lot for your help.

 

[AngelicBeauty]

Thanks a lot for your help.

no prob...u understood na???

 

[AngelicBeauty]

Waiyakum......
i know that was right too......but this one is quicker & easier,
and finally its on you to do the way you want....
anyways,
All the best.......exams date have approached.....and do pray for me as well....

yep i will surely pray 4 u
i have ma ict prac on 25th march n tmrw is ma mock.......need lot of duas ......may Allah help u n reward u for helping everyone here.....hmmm this is quickr n easier!!!!
all d best!!!!........

 

[Student of the year]

well thnks fr helping me and it worked earlier but help me in q 11 and 13 of mj09

q11:

• go to query wizard, select from all the tables the required fields
• in design view put the criteria-->31/7/10 and <1/9/10----in the O_Date column {this is acc to the ms whereas acc to me this criteria should come in both H_Date & O_Date}
• then do q12, by adding an extra column--- Balance:[Cost]-[Pay]

q13

• go to report wizard, select a;ll the fields from q11 query
• select the columnar layout of the report
• now format the detail section as per the ques, insert labels wherever needed
• your reports ready

Hope this works....

 

[Tkp]

my 1 is on tomorrow.best of luck every1

 

[Enes]

no prob...u understood na???

I understood. Can you also help me with s11_qp2(( same qp)) q13 and q14?? Those are really complicated... :S

 

[AAnsarii]

in AICT for paper 2 are we allowed to explore any site for the information that is needed and just not copy information rather write in your own words? If not please tell a specific site i can use. Thank you.

i think(n r sir 2 said so) dat v can use d net n Wikipedia is quite good...also Yahoo!Answers and Wiki answers
May Allah purify r intentions n help us all..Aameen

 

[syed1995]

i think(n r sir 2 said so) dat v can use d net n Wikipedia is quite good...also Yahoo!Answers and Wiki answers
May Allah purify r intentions n help us all..Aameen

Well as long as you change the content a little you should be fine. Lifting = zero marks for content .. from what i have read in the examiner's reports for the recent years..

 

[AAnsarii]

I understood. Can you also help me with s11_qp2(( same qp)) q13 and q14?? Those are really complicated... :S

13. qn says: by "Black Sabbath, Iron Maiden or Status Quo"; so u put in d "Name" field "Black Sabbath" or "Iron Maiden" or "Status Quo". {1st prt of qn done}
"Available on all three websites"; so in Avail1 & 2 & 3 fields u put "Yes" (u'll do so coz u've entered dese fields 4m d web tbl, n Avail will stand 4 available). {13 done}
14. New field: at d end of d query. "called Ave_Price"-- enter Ave_Price. "Average of d three prices"-- go back 2 d basics- wt do u do in average? u add all values n divide by d no. of values dat wr dere. so here, u'll add (after ":") Price1 & 2 & 3 in square brackets(coz fields r 2 b put in such a way). den u divide by no. of values dat wr dere: hw many wr dere? 3. so u add all three n den divide by 3. eg. im tkg "P" 4 price bt u've 2 add d field name hw it looks .ie. ([P1]+[P2]+P3])/3 <--round brackets coz u want it 2 add 1st n den divide.

hope it helped, by Allah's Will, And all praise belongs entirely 2 Him.
May Allah help us all Aameen

 

[Student of the year]

s09 q13 onwards
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf

see my reply..

q11:
q13

• go to report wizard, select a;ll the fields from q11 query
• select the columnar layout of the report
• now format the detail section as per the ques, insert labels wherever needed
• your reports ready

Hope it helps....and i guess you wanted only for q13&14
and not till the end from s09 q13 onwards........

 

[AAnsarii]

q11:

• go to query wizard, select from all the tables the required fields
• in design view put the criteria-->31/7/10 and <1/9/10----in the O_Date column {this is acc to the ms whereas acc to me this criteria should come in both H_Date & O_Date}
• then do q12, by adding an extra column--- Balance:[Cost]-[Pay]

4 q 11__ idk bt wn i put in ODate and wn i put in both, nth is coming
maybe importing errors...its k

n wt about d "London" thing?

 

[AAnsarii]

Hope this works....

Jazakumullah

 

[fille spéciale]

Hey Friends,
Just like you`ll even I found w12 q15 confusing and somehow had to complete it bcz had to submit it today,
& after spending several hours on trying diff ways to solve this ques, I finally got a simple & short method
{anyways we can solve the ques in any way until we get the right ans},
but this method is quite short:

Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.


And I am extremely SORRY for posting the unrectified earlier ans and causing trouble for you guys........
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
Sorry once again...

jazakallah...plz dont b sorry
all d best...may Allah help all of us!..ameen
btw mashallah nice signature

 

[Student of the year]

4 q 11__ idk bt wn i put in ODate and wn i put in both, nth is coming
maybe importing errors...its k

n wt about d "London" thing?

in both n12out & n12home the fields are all London (ie into & out of are already London)
so have to worry only about date......