• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Computers & ICT: Post your doubts here!

Messages
291
Reaction score
1,576
Points
153
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:cry: for posting the ans late....
Tkp, AngelicBeauty, fille spéciale, AAnsarii
Hope this benefits you`ll.....
 
Messages
1,824
Reaction score
949
Points
123
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:cry: 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... :oops:

JazakAllah :)

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

Tkp

Messages
1,660
Reaction score
11,026
Points
523
well thnks fr helping me and it worked earlier but help me in q 11 and 13 of mj09
 

Tkp

Messages
1,660
Reaction score
11,026
Points
523
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:cry: 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... :oops:
thnks. no need to tell sorry.
 
Messages
2,525
Reaction score
5,728
Points
523
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:cry: 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... :oops:
no that was proer....i did it the way u showed!!!! jazakillah....n pls dont be sorry :)
 
Messages
30
Reaction score
14
Points
18
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.
 
Messages
2,525
Reaction score
5,728
Points
523
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!!!!........
 
Messages
291
Reaction score
1,576
Points
153
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....
 
Messages
1,162
Reaction score
6,306
Points
523
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
(y)May Allah purify r intentions n help us all..Aameen
 
Messages
1,824
Reaction score
949
Points
123
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
(y)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..
 
Messages
1,162
Reaction score
6,306
Points
523
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(y)
 
Messages
291
Reaction score
1,576
Points
153


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........:D
 
Messages
1,162
Reaction score
6,306
Points
523
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?
 
Messages
1,055
Reaction score
6,654
Points
523
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:cry: 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... :oops:
jazakallah...plz dont b sorry
all d best...may Allah help all of us!..ameen
btw mashallah nice signature (y)
 
Top