Computers & ICT: Post your doubts here!

[warlord]

http://www.mediafire.com/?dgcbc88stxh5f

Thank you

 

[warlord]

can any one help me with q29 of may/june 2008 P2

 

[Kernel95]

where do i find the pound sign in access?

The easiest way to do this:

1. Go to control panel
2. Go to Clock, Language and Region
3. Click "Change Location"
4. At the bottom, click Addtional settings...
5. At the top; "Currency"
6. Change the "Currency symbol"

• Now in access, when you have set a record/field to be in "currency", it will have it in pounds.

Another method of doing this, is in the format field in a record, insert "£ #,##0,00" or change the amount of 0.00 depending on how many decimal places etc.
Here is a good link
http://bit.ly/wyqg4q

 

[fah3355]

@Xenon upload your work on the word part in winter and summer 2011
i cant think of any way to present it.

 

[Jasmine Nabawy]

can any one help me with q29 of may/june 2008 P2

Hello there! I tried solving it but I couldn't. Would you please help me with question no. 25 ????????????

 

[warlord]

yi

Hello there! I tried solving it but I couldn't. Would you please help me with question no. 25 ????????????

in q25 u have to count like for route 1 how many times is the bus late more than five minutes . there is no formula to do it u have to count it manually. i have attached a file which might help u

 

[warlord]

i really need help with q 21 oct nov 2008

 

[black_berry]

extract a new field called

Days
which is calculated at run time. This must
calculate the number of whole days for each of these holidays. [4]
may/june 2009 Q8

 

[Student12]

Someoneee Help us Out !!!!

 

[Student12]

ah ok, first sort the Route column in ascending order
then in the table created, use the function COUNTIF and then manually enter the formula, I mean... like Route 1 starts from row 6 to 14.. taking this information, the formula set is =COUNTIF(Sheet1!$E$6:$E$14,">=5"), column E is used since we are dealing with time....
you can use this formula or use a bigger and more automated formula
=COUNTIFS(Sheet1!$E$6:$E$131,">=5",Sheet1!$F$6:$F$131,RIGHT(A2,1))
copy this in the first cell and drag it along to complete the table

To the most helpful person in this Group -Xexon-
I'm very thankful for all the work u've done. God Bless You !!
We've just got a couple of days left for our AS finalz we need you or someone to help us.. please !!

& again one more doubt..anyonee ??
When i transpose the cells my values for Route come as zero, why is that ??!! :O
BTW.. the paper is may/june 2008 question no. 26.

 

[Student12]

Anyone has supporting files for 2011 o/n and m/j paper 2 ? MediaFire does not have all the files.

 

[Kernel95]

To the most helpful person in this Group -Xexon-
I'm very thankful for all the work u've done. God Bless You !!
We've just got a couple of days left for our AS finalz we need you or someone to help us.. please !!

& again one more doubt..anyonee ??
When i transpose the cells my values for Route come as zero, why is that ??!! :O
BTW.. the paper is may/june 2008 question no. 26.

If you help me get question 25 right, I might be able to help with qn 26...

 

[Student12]

The question says enter formulae to count the number of buses that are 5 or more minutes late for each bus route.You may sort the data into
Route order and use ranges within the sorted data or an extra column to help you.
As said by xexon in the previous comments and i've quoted too..
First sort the Route column in ascending order
then in the table created, use the function COUNTIF and then manually enter the formula, I mean... like Route 1 starts from row 6 to 14.. taking this information, the formula set is =COUNTIF(Sheet1!$E$6:$E$14,">=5"), column E is used since we are dealing with time....
you can use this formula or use a bigger and more automated formula
=COUNTIFS(Sheet1!$E$6:$E$131,">=5",Sheet1!$F$6:$F$131,RIGHT(A2,1))

i used the first formula & iHope it helped. What all year questions have you solved ?

 

[Kernel95]

The question says enter formulae to count the number of buses that are 5 or more minutes late for each bus route.You may sort the data into
Route order and use ranges within the sorted data or an extra column to help you.
As said by xexon in the previous comments and i've quoted too..
First sort the Route column in ascending order
then in the table created, use the function COUNTIF and then manually enter the formula, I mean... like Route 1 starts from row 6 to 14.. taking this information, the formula set is =COUNTIF(Sheet1!$E$6:$E$14,">=5"), column E is used since we are dealing with time....
you can use this formula or use a bigger and more automated formula
=COUNTIFS(Sheet1!$E$6:$E$131,">=5",Sheet1!$F$6:$F$131,RIGHT(A2,1))

i used the first formula & iHope it helped. What all year questions have you solved ?

To be honest, I am not very organised, so I cannot even say which papers I have done Done little parts of everything :S

For question 26, if you didn't manage it already:

• Copy the entire array (A2:I3)
• Select the cell where you want the first title to be, (Route 1)
• Paste Special
• At the bottom, check the box "Transpose"

 

[Student12]

To be honest, I am not very organised, so I cannot even say which papers I have done Done little parts of everything :S

For question 26, if you didn't manage it already:

• Copy the entire array (A2:I3)
• Select the cell where you want the first title to be, (Route 1)
• Paste Special
• At the bottom, check the box "Transpose"

Ohh i seee.....
i did that but when i paste it my values come as 'zero'. Do that question and let me know if u get the values ?

 

[Kernel95]

Here you can see the print screens. If you still cannot do it, tell me and we'll figure it out.


I think the problem is when I said

• Select the cell where you want the first title to be, (Route 1)

With this I wanted to say that you need to paste special in the cell A5, where the Route 1 will be displayed again.

 

[Jasmine Nabawy]

Thanks alot for your help.. btw, when is your AICT exam?

 

[Kernel95]

Taking it probably on Thursday, but not 100% sure yet.

I am not sure of this neither. I find it hard to complete questions 29,30 and 31 using Excel, so have they intended us to use Access here and then export the data from access back to excel?
Thanks

 

[Student12]

Here you can see the print screens. If you still cannot do it, tell me and we'll figure it out.
View attachment 4949View attachment 4950View attachment 4951View attachment 4952

I think the problem is when I said

• Select the cell where you want the first title to be, (Route 1)

With this I wanted to say that you need to paste special in the cell A5, where the Route 1 will be displayed again.

Finally i realised what my mistake was..
i didnt use the Absoulte cell reference thing LOL i've been struggling since so long and this was my mistake -.-
Anyways Thx

 

[Jasmine Nabawy]

Taking it probably on Thursday, but not 100% sure yet.

I am not sure of this neither. I find it hard to complete questions 29,30 and 31 using Excel, so have they intended us to use Access here and then export the data from access back to excel?
Thanks

which year is it ?