• 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

Tkp

Messages
1,660
Reaction score
11,026
Points
523
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
 
Messages
1,055
Reaction score
6,654
Points
523
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 :)
 
Messages
1,055
Reaction score
6,654
Points
523
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

sd.PNG
 

Attachments

  • wwss.PNG
    wwss.PNG
    18.6 KB · Views: 9
  • Like
Reactions: Tkp

Tkp

Messages
1,660
Reaction score
11,026
Points
523
can anyone help me with may june 08 p4 ques 12
 

Attachments

  • June 2008 Question Paper 4.pdf
    123.6 KB · Views: 1
Messages
1,162
Reaction score
6,306
Points
523
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:
Capture.JPG
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)
 

Tkp

Messages
1,660
Reaction score
11,026
Points
523

Tkp

Messages
1,660
Reaction score
11,026
Points
523
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(y)
 
Messages
757
Reaction score
5,220
Points
503
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 :)
 
Top