• 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)

AICT 9713, Computing 9691 Problems

N

nipoonnipoonnip

Messages
38
Reaction score
21
Points
8
1995@10Sept

1995@10Sept

Messages
2,222
Reaction score
6,346
Points
523
AAnsarii said:
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(y)
Click to expand...

AngelicBeauty
 
AngelicBeauty

AngelicBeauty

Messages
2,525
Reaction score
5,728
Points
523
AAnsarii said:
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(y)
Click to expand...

i cant understand :'(
 
1995@10Sept

1995@10Sept

Messages
2,222
Reaction score
6,346
Points
523
nipoonnipoonnip said:
Can someone help me with these questions.​
​
Both are all A2 questions for 9713​
​
O/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
Click to expand...


S10 question 3
in CELL A4
=IF(A2<>"",VLOOKUP(A2,lookup table array,3,FALSE),"")

in CELL C2
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,11,FALSE),"")

here u have to change d number after d table array...for eg: it is 11 here coz IDACOPT5 is in d 11th column
so for the next cell u will put 6 n NOT 11 coz it's IDBC04 so it will b (in cell C3)
=IF($A$2<>"",VLOOKUP($A$2,lookup table array,6,FALSE),"")

in CELL D2
=IF(C2="y",VLOOKUP(B2,lookup table array,3,FALSE),"")

AAnsarii plz check if it is right coz i did it n got d correct answer...
 
1995@10Sept

1995@10Sept

Messages
2,222
Reaction score
6,346
Points
523
AAnsarii what does this mean...?? n how to do it...?? S11 q3
Assign the macro or procedure to a toolbar or menu item of your word processing application. :confused:
n the MS says this:- Toolbar/Menu – attempt to assign, in toolbar/menu, appropriate name Mrks 3
 
AAnsarii

AAnsarii

Messages
1,162
Reaction score
6,306
Points
523
1995@10Sept said:
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...
Click to expand...

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.
 
AngelicBeauty

AngelicBeauty

Messages
2,525
Reaction score
5,728
Points
523
AAnsarii said:
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 :)
Click to expand...

jazakALlh , its not getting converted into cm even after i went into word options and did it!!!
pls check ur gmail!!!
 
1995@10Sept

1995@10Sept

Messages
2,222
Reaction score
6,346
Points
523
AAnsarii said:
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.
Click to expand...

hahaaha it's supposed to b done like this...!! hahaha...i coulcn't get it so i changed d main file n all d blank spaces i put a "N"...so it automatically came N :p
yea but i know that's wrong...!! jazakillah for ur help... :)
 
AAnsarii

AAnsarii

Messages
1,162
Reaction score
6,306
Points
523
linkinpark said:
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 :)
Click to expand...

jazakallahu khair
d imgs arent opening.
i tried, then made a query 2 join both d queries u illustrated, bt d following error msg opened:
Capture.Query.Problem.JPG
 
You must log in or register to reply here.
Top