Computers & ICT: Post your doubts here!

[Student12]

Go to control panel and find "Region and Language" change the place to United Kingdom or ur desired one. And then automatically in query u click in the currency its changes.

Is that how i'll do it in the exam too ?

 

[Raiyan3]

Is that how i'll do it in the exam too ?

Did it work for you? umm yes you can do that or u can tell ur AS ICT teacher to write a report to CIE saying that the currency was in dollar format

 

[Raiyan3]

Can anyone please help me with may june 2011 cause every time import the table and makes in the field "Price 1'' of table named "J11WEB", access tells me 104 records are deleted !! whyy? :/

 

[Student12]

i just tried it doesn't work out :/ As far as i remember there was a way in access to do it.. i dont remember thats the problem >.<

 

[fah3355]

Could you guys tell me if in summer 10,how many question papers are there of practicals?

 

[Student12]

Could you guys tell me if in summer 10,how many question papers are there of practicals?

What do you mean how many question papers ? Its only one Paper 2 for AS-practicals and Paper 4 for A2. Is that what you asked ?

 

[Xenon]

Its not a very sensible question to ask
How do you change the dollar sign to pounds sign in access while ur doing the report or quary ?

Go to control panel and find "Region and Language" change the place to United Kingdom or ur desired one. And then automatically in query u click in the currency its changes.

i just tried it doesn't work out :/ As far as i remember there was a way in access to do it.. i dont remember thats the problem >.<

yes, it can be done without changing the settings of Windows.. to do so, open the table/report/query in design view and then follow the picture below (I've taken a report as an example)

select the required field in and then open property sheet... on the format box enter as $ #,###.00 . Obviously the $ assigns the custom format, # makes sure that either a digit is placed or nothing. The 0 ensures that either a digit is place or zero. The "," is thousand seperator
If you want to place any other currency format, you can do it like this way, lets take the Canadian dollar CAD as example, "CAD" #,###.00

 

[Xenon]

Can anyone please help me with may june 2011 cause every time import the table and makes in the field "Price 1'' of table named "J11WEB", access tells me 104 records are deleted !! whyy? :/

I might be able to help you if you provide me with the qp and support files.... I don't have them

 

[Xenon]

Thanks but i still i din't get how to make the query and the ''average pay''. Can you pleasee help me out on this? thanks in advanced again

This is the query:


this is how you make the graph in access. The average calculation is performed while creating the graph (note the graph shown here is not complete, it just shows how to calculate the average):

 

[fah3355]

What do you mean how many question papers ? Its only one Paper 2 for AS-practicals and Paper 4 for A2. Is that what you asked ?

i mean in summer 11 how many are there?

 

[fah3355]

and guys wht do you do during relationships ,do w have to tick enforce referential integrity or not?

 

[fah3355]

guys can you help me with this summer 11 paper from 13 to 15.i dont get it :S

 

[fah3355]

guys can you help me with this summer 11 paper from 13 to 15.i dont get it :S

 

[fah3355]

can anyone upload the winter 11 practical question for As

 

[Raiyan3]

I might be able to help you if you provide me with the qp and support files.... I don't have them

Yeah sure bro !!

And the question paper here's the link
http://www.xtremepapers.com/CIE/Int...nd Communication Technology/9713_s11_qp_2.pdf

 

[Raiyan3]

Can you please tell me how to point number 5 in june 2010..the queries? i mean i got it right but i cant get the date in the way MS wants :/ and how to find the grand total of profit in the end? PLEASE HELP and the last post aswell please!! Thanks in advanced

 

[Xenon]

Can anyone please help me with may june 2011 cause every time import the table and makes in the field "Price 1'' of table named "J11WEB", access tells me 104 records are deleted !! whyy? :/

well, I didn't have any problem importing the files, brief me on how you are doing it

 

[Xenon]

hey ! can anybody help me in mj2011
step 14 Add to this extract a new field called Ave_Price This is calculated at run-time and works out, for each album, the average of the three
prices. Format this numeric field as currency, in pounds (£) with 2 decimal places. in this how we gonna find avg of all the three prices

guys can you help me with this summer 11 paper from 13 to 15.i dont get it :S

@fah3355 I don't think you'll face any problems with creating the report, so here's the query:

 

[fah3355]

Yeah sure bro !!

And the question paper here's the link
http://www.xtremepapers.com/CIE/International A And AS Level/9713 - Applied Information And Communication Technology/9713_s11_qp_2.pdf

thnaks bro....thnk you very much
hey...could u tell me during creating relationships in access do u put on enforce referential integrity or not ?

 

[Xenon]

thnaks bro....thnk you very much
hey...could u tell me during creating relationships in access do u put on enforce referential integrity or not ?

you can though I'm not sure about its significance