Computers & ICT: Post your doubts here!

[Student of the year]

dis is wt i think..
sales personnel matlab all ppl who work in d "Sales" dept; so it means dat in d field "Department"(or ne-th lyk dat), u put d criteria s "Sales"..
hp it helped.. da angel down here
All d best!
May Allah Help us all..n purify r intentions..aameen :'(

Aameen...
your thinking is right,
but all the records in the query of q13 & q14 contain only sales staff, so you need not put the criteria as sales.

see my reply in

q15 of w12:

if you dont uderstand do ask
I`ll try my best to help you.....

 

[Student of the year]

i had done like this =(ROUNDUP(I3/300,0))*G3

Tkp, your formula means similar to AAnsarii

so see my reply

see dear,
your formula means that
so now we get the total drivers for that journey.

Hope you understood.....??

Hope it helps you too...

 

[Hussain Choudhury]

Asalamualaikum brother, I have a problem with question 6 and 7 of AICT Paper 2 Summer 2010

You are going to prepare a report and a graph or chart showing the average sale price of more
expensive cars.
6 Calculate the average sale price of each make of car for all cars in the database.
Select only the makes of car where the average price is more than £15,000. Sort this
data into ascending order of the make. [3]
7 Use this extract to prepare a report. Add the title Average sale price of luxury cars
to this report. Place your name, Centre number and candidate number in the header.
Save and print this report.
I have grouped my make and averaged price using report wizard, but I am unable to give the >15000 in report wizard.
I think some of it has to be done in query wizard but I am not sure how
Field Price
Alfa Romeo 15,650
Alfa Romeo 8,200
BMW 21,500
Example of the table structure
JazakAllah Khayr in Advance

 

[Tkp]

First make a query.Then in query design add make,sale price.then add total.in make it would be group by and in sale price it would be average and in criteria put >15000.then make a report with ascending order of make.

 

[Tkp]

i did this question......first u have to make a query in which u will write in d criteria ">1"

mine 1 is nt working.it is coming blank.cn u attach ur mj09 access pls

 

[Tkp]

q15 of w12:
i)go in query wizard, and select simple query option
ii)select the query used in q14--select all the fields
iii)in design view of this query, put the criteria for country as "Spain" or "Germany"
iv)go again in query wizard and select the crosstab query option
v)in there, mark the query circle, then select the query we just made(from i to iv)
vi)select branch name as row headings and payroll_id as column heading
vii)then select count function & any field from{forename,surname,jobcode,etc}
viii)now go to report wizard & select this crosstab query(from v to vii)
ix)only select the fields-branch name & total of jobcode/forname/etc
x)then you sort it in descending order of total of jobcode/forname/etc
xi)create the report
xii)in design view,enter a text box, and in it type =sum([total of jobcode])
your report is ready, & now you format it as per the question


Sorry guys for replying late saw this paper just today & came online today just now

Hope you`ll benifit from this..........

when i go to create report and select crosstab query it is showing only branch name and values and it is showing they cnt create report

 

[AngelicBeauty]

is it in s12 or w12
the w12 ans i`ve posted...

oopss i am sooo sorry its w12

 

[fille spéciale]

Student of the year ...jazakallah alott for d help ..may ALLAH bless u ..ameen!

 

[AngelicBeauty]

q15 of w12:
i)go in query wizard, and select simple query option
ii)select the query used in q14--select all the fields
iii)in design view of this query, put the criteria for country as "Spain" or "Germany"
iv)go again in query wizard and select the crosstab query option
v)in there, mark the query circle, then select the query we just made(from i to iv)
vi)select branch name as row headings and payroll_id as column heading
vii)then select count function & any field from{forename,surname,jobcode,etc}
viii)now go to report wizard & select this crosstab query(from v to vii)
ix)only select the fields-branch name & total of jobcode/forname/etc
x)then you sort it in descending order of total of jobcode/forname/etc
xi)create the report
xii)in design view,enter a text box, and in it type =sum([total of jobcode])
your report is ready, & now you format it as per the question


Sorry guys for replying late saw this paper just today & came online today just now

Hope you`ll benifit from this..........

thank u soooo much Student of the year .......... it was really helpful ...... Devilishangel:) acas shaikh

 

[Devilishangel:)]

AngelicBeauty thanks a ot for the tag! : )

 

[AngelicBeauty]

AngelicBeauty thanks a ot for the tag! : )

no prob

 

[Tkp]

i am so dumb.now mine 1 works.thnks fr the helphttps://www.xtremepapers.com/community/members/angelicbeauty.19411/

 

[AngelicBeauty]

i am so dumb.now mine 1 works.thnks fr the helphttps://www.xtremepapers.com/community/members/angelicbeauty.19411/

hey no prob....n i'll send u d ppr later cus i havent completed it yet plus its not proper.....
anyway i hope this can help https://mail-attachment.googleuserc...346&sads=A5gFaxrcvZobUZCJ1_zz6BJzGug&sadssc=1

 

[Tkp]

hey no prob....n i'll send u d ppr later cus i havent completed it yet plus its not proper.....
anyway i hope this can help https://mail-attachment.googleuserc...346&sads=A5gFaxrcvZobUZCJ1_zz6BJzGug&sadssc=1

ii cnt open this .cn u help me in mj 09 11,13

 

[Martee100]

M/j 2012 Q18 Graph? How can I do that?

 

[Tkp]

M/j 2012 Q18 Graph? How can I do that?

select the venue name and miles and insert bar chart.simple

 

[InternationationalGuy]

in AICT for paper 2 are we allowed to explore any site for the information that is needed and just not copy information rather write in your own words? If not please tell a specific site i can use. Thank you.

 

[Enes]

Can someone help me with S11_QP2 question 11 please?????

 

[AngelicBeauty]

ii cnt open this .cn u help me in mj 09 11,13

 

[AngelicBeauty]

Can someone help me with S11_QP2 question 11 please?????

its from d marking scheme
1.go in d design view click on "release date"
2.in d validation rule enter ">=#1/1/1900# And <#1/1/2012#"
3.in d validation text enter "Data entered should be from the year 1900 and before the year 2012."
4.check if there r any dates less than 1900 or more than 2012 if not ,then its right!!
5.enter a date which does not fit in d given range like 2/3/2013 or 2/3/1800 , this will give u an error msg so u take the screenshot of that error msg and place in it the evidence document, in the table that u have created.place it in the outcome coloumn of the abnormal data!!!

i hope u understood