- Messages
- 1,055
- Reaction score
- 6,654
- Points
- 523
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)
well wait till i solve this paper
have u completed all the yearsokies..
hope aansarii has done it
have u completed all the years
okayyup..winter pprs!
alhamdulilah
will start summer IA
u need 2 send letters 2 customers (will need customer tbl) who've ordered white dining chairs and booked b/w 2 & 9 Aug (newbookings tbl). so need 2 tk both tbls
query criteria specified in qp:-
You are required to merge letters to the customers who have:
• received an acknowledgement
• ordered the white dining chairs (code wd)
• made a booking between 2nd and 9th August inclusive.
open apologies n insert the relevant fields wr required.
then, qp also says "Insert, where indicated, fields that will require keyboard input when the merge is created.
Use unavailable item and replacement item as the text for relevant prompts."
keyboard input, prompts: u'll need 2 do a fillin. u noe wr as is there in d master doc. after u type a sensible instruction 4 d user in d fillin window, another window opens:
View attachment 32294
here u enter unavailable item, n wn u do d fillin 4 replacement, u enter replacement item.
then they tell u,"Enter white dining chairs when prompted for the unavailable item and gilt dining chairs when prompted for the replacement item."
this is wn u finish n merge d letters.
hope it answered ur qn. sorry 4 being late.
May Allah Help us all
u need 2 send letters 2 customers (will need customer tbl) who've ordered white dining chairs and booked b/w 2 & 9 Aug (newbookings tbl). so need 2 tk both tbls
query criteria specified in qp:-
You are required to merge letters to the customers who have:
• received an acknowledgement
• ordered the white dining chairs (code wd)
• made a booking between 2nd and 9th August inclusive.
open apologies n insert the relevant fields wr required.
then, qp also says "Insert, where indicated, fields that will require keyboard input when the merge is created.
Use unavailable item and replacement item as the text for relevant prompts."
keyboard input, prompts: u'll need 2 do a fillin. u noe wr as is there in d master doc. after u type a sensible instruction 4 d user in d fillin window, another window opens:
View attachment 32294
here u enter unavailable item, n wn u do d fillin 4 replacement, u enter replacement item.
then they tell u,"Enter white dining chairs when prompted for the unavailable item and gilt dining chairs when prompted for the replacement item."
this is wn u finish n merge d letters.
hope it answered ur qn. sorry 4 being late.
May Allah Help us all
i cant understand :'(
Can someone help me with these questions.Both are all A2 questions for 9713O/N 2008 question 15, i just dont understand what they are asking.M/J 2010 question 3, i just dont to how to use the lookup formulae for it.
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_w08_qp_4.pdf
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s10_qp_4.pdf
start recording d macro
S10 question 3
...in CELL C2
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,11,FALSE),"")
....AAnsarii plz check if it is right coz i did it n got d correct answer...
start recording d macro
1st put d margins, den d vertical line, den 4mat all txt 2 12pt Serif. last of all, put d logo.
stop d macro.
i still dnt noe hw 2 add d comments Student of the year Tkp
agar still problem hai, den tell. n b more explicit on wr is ur query if u can
in column C, d heading specifies Y/N. so u just add an if:
=IF($A$2<>"",IF(VLOOKUP($A$2,lookup table array,11)<>"","Y","N"),"")
ie, if its nt empty, (so it'll hv "y" in it) u put Y, n if it is empty, put N.
this is quite a tricky part. Here's the method of how to solve it
make a query first including the 4 specified fields
http://prntscr.com/1yjo15
make a find duplicate query
http://prntscr.com/1yjosz
select the query of multivenue
http://prntscr.com/1yjosx
we need to find the duplicated venues right? so we will insert venue in the duplicate field
http://prntscr.com/1yjotk
add the rest of the fields and proceed to finish. Here you go.
http://prntscr.com/1yjotu
Hope it helped
If you've got any other problem, lemme know. I'll solve it
jazakALlh , its not getting converted into cm even after i went into word options and did it!!!
pls check ur gmail!!!
nt getting converted into what?
into centimetres
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now