Qualification > Miscellaneous
Official Thread for AICT Doubts !
NotAbod:
I will assume that you've solved the previous questions correctly.
Steps:
Create a new query using "Query Design"
add the four tables
add the fields: Forename, surname, cost and CustRef from the table J9cust.
click the "Sigma symbol" to show totals.
under custref's criteria, write ">1" and change "Group by" to "Count" (Select from all the records only the customers that have booked more than one holiday). CustRef is unique for every customer.
from the dropdown list of totals of "Cost", choose Avg (average).
Save your query.
Create a new report using report wizard.
choose your query and the four fields
click next.
group the data by "CountofCustRef"
click next, sory data into ascending order of surname and then ascending order of forename.
Change page layout to landscape.
click finish.
go to report's design view.
click on group and sort, and choose to show CountofCustRef Footer.
in the countofcustref footer, add a text box and paste "=avg[avgofcost]"
add your name/centre number.
Done
I've attached my working files, use them.
Mike Benn:
--- Quote from: Abod on October 04, 2011, 07:34:28 pm ---I will assume that you've solved the previous questions correctly.
Steps:
Create a new query using "Query Design"
add the four tables
add the fields: Forename, surname, cost and CustRef from the table J9cust.
click the "Sigma symbol" to show totals.
under custref's criteria, write ">1" and change "Group by" to "Count" (Select from all the records only the customers that have booked more than one holiday). CustRef is unique for every customer.
from the dropdown list of totals of "Cost", choose Avg (average).
Save your query.
Create a new report using report wizard.
choose your query and the four fields
click next.
group the data by "CountofCustRef"
click next, sory data into ascending order of surname and then ascending order of forename.
Change page layout to landscape.
click finish.
go to report's design view.
click on group and sort, and choose to show CountofCustRef Footer.
in the countofcustref footer, add a text box and paste "=avg[avgofcost]"
add your name/centre number.
Done
I've attached my working files, use them.
--- End quote ---
Oh Crap. i wz doing it all rite, just wz not sure.. sh*t man. By the way Thankx alot. now u may carry on wid AS..:P:P
Mike Benn:
Specimen 2008. Can anyone plz help me out , cz i got no idea what to write.
The company owns a website with a URL of www.southindiamotors.co.in
This advertises the company’s products. In recent weeks another website has appeared with
a URL of www.southindiamotors.net
This website pretends to advertise the company products but gives some comparisons with
other vendors’ products which are not very favourable.
The board of directors are very upset with this new website. You must word
process a brief, single page report to be given to the press explaining why
websites are not always what they appear to be. Identify any features of the
website which would show its lack of credibility. Your report will be less than
300 words. Place your name, centre number and candidate number on the
report. Save and print this report.
Malak:
Sorry for a very late reply, do you still need help with it?
NotAbod:
Nope :P
He gave his exam ;D :P
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version