AICT 9713, Computing 9691 Problems

[AAnsarii]

i made this extra field module code!! is it rit?? and i am not able to establish relationships ??? pls help !! View attachment 32201View attachment 32202

in d students table, u enter d tutor id according 2 d subs dey r taking n d subs dat d tutors r teaching. den mk d relation 4m Tutors to Students.
fille spéciale

 

[Tkp]

View attachment 32200 w10 q 2 AAnsarii Tkp >> relationship ques>>xtra field??

well i just creatd another table
see u have 1 file of compute science diploma is ms word
just copy and past all the details in the ms access and add the tutor code and sace the table in the name of diploma
and show the relation ship
module code to optional module and tutors tutor id to diploma tutor id

 

[fille spéciale]

well i just creatd another table
see u have 1 file of compute science diploma is ms word
just copy and past all the details in the ms access and add the tutor code and sace the table in the name of diploma
and show the relation ship
module code to optional module and tutors tutor id to diploma tutor id

ya i got it ..ty

 

[fille spéciale]

Tkp for w 10 q6
make a query including all d required fields n in d "criteria" write d prompt eg "[tutor surname]" den run d query ..
den dis appears..write d name of d tutor

 

[Tkp]

thnks

Tkp for w 10 q6
make a query including all d required fields n in d "criteria" write d prompt eg "[tutor surname]" den run d query ..
den dis appears..write d name of d tutor

View attachment 32226

 

[Tkp]

thnks a lot

 

[Tkp]

can anyone help me with may june 08 p4 ques 12

 

[AAnsarii]

hello sir can you please give me solved paper of aict paper 1
as fast as possible thanx in advance

refer 2 d ms. v resourceful.

 

[AAnsarii]

can anyone help me with may june 08 p4 ques 12

cn u plz gv d source files?

 

[Tkp]

here are the supporting files AAnsarii

 

[AAnsarii]

here are the supporting files AAnsarii

q5. do u change d ids to 1,2,3,4,5....?

 

[Tkp]

no

q5. do u change d ids to 1,2,3,4,5....?

 

[AAnsarii]

can anyone help me with may june 08 p4 ques 12

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:

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

 

[AAnsarii]

here are the supporting files AAnsarii

1995@10Sept

 

[1995@10Sept]

1995@10Sept

jazakillah..will try n solv it later inshaAllah

 

[AAnsarii]

s08 qp4 q16
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_4.pdf
Student of the year AtemisDelta 1995@10Sept fille spéciale AngelicBeauty acas shaikh Tkp
hw do u display only d venues wid more dan 1 booking?

 

[Tkp]

i was solving this paper and also have problem in this 1.well we have to crosstab or what?:O

s08 qp4 q16
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_4.pdf
Student of the year AtemisDelta 1995@10Sept fille spéciale AngelicBeauty acas shaikh Tkp
hw do u display only d venues wid more dan 1 booking?

 

[Tkp]

well i got it earlier by clicking on the random fields and read the question and got it.btw thanks 4 helping

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:-
t item."
this is wn u finish n merge d letters.
hope it answered ur qn. sorry 4 being late.
May Allah Help us all

 

[linkinpark]

s08 qp4 q16
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_4.pdf
Student of the year AtemisDelta 1995@10Sept fille spéciale AngelicBeauty acas shaikh Tkp
hw do u display only d venues wid more dan 1 booking?

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

 

[linkinpark]

Tkp check out the solution.