Applied ict 9713 paper2 (post your doubts here)

[Enes]

we have to make a query

Thanks a lot! :*

 

[jay_sh]

Who knows how to solve Question 6 ? Thanks

 

[jay_sh]

How to solve question 6 ?

 

[Asad.Babur]

Anyone tell me what is meant by Print? Print to file?

And, will we have internet access there?

 

[Saif-ur-Rehman]

Hi,


In the question paper 2 of AICT may 2008 paper i don't know how to complete the task number 18 and 20.

18. Select only those buses with a Due time of between 11:00 and 11:30 inclusive.

19. Create a header which says Due between 11:00 and 11:30 and a footer which contains your name, centre number, candidate number. Make sure that the contents of all cells are fully visible.

20. Save and print all details of this extract, adjusting the page layout if necessary so that the whole table fits on a single page. Make sure that the contents of all cells are fully visible.


If i select the required rows using Ctrl button and then print them, they do not get printed on a single page. Each of the row is printed on a single page. I'm using Excel 2010. Please help me.

Also, what version of MS office do they provide in british council exam centres here in Pakistan?

thanks

saif b

 

[Sakshi Agarwal]

How to solve question 9? Please Help!

 

[Zash Riyash]

Nah, that actually doesn't work! It just groups it according to the first letter but it doesn't make a small table categorized as 'personal' and business

 

[Zash Riyash]

Well, this is my file.

 

[Zash Riyash]

The biggest doubt of all: 9713_s12_qp_2 q13

 

[Sakshi Agarwal]

Use the report wizard, when you're about to group the Personal And business, click on "Grouping Options", and select the grouping intervals as "First initial letter"

Hey thanks a lot!! It worked!
And I am writing my Paper 2 this oct/nov 2014...my exam is on 7th October....but wat do u mean by post the paper??

 

[Sakshi Agarwal]

question no.9..how??

 

[Zash Riyash]

question no.9..how??

Hey Sakshi, for this question (first part) you are supposed to create a summary query, (under the query thing...) and then select the 'count records' option. (second part) you just place a validation, in the table,

 

[Zash Riyash]

question no.9..how??

 

[Sakshi Agarwal]

Hey Sakshi, for this question (first part) you are supposed to create a summary query, (under the query thing...) and then select the 'count records' option. (second part) you just place a validation, in the table,
View attachment 47750 View attachment 47751

THANK YOU!! But I have a doubt : The validation we are supposed to add has to come under the "Course" table or in the created query (design view...under criteria)?
And I am not able to open the database file...the .rar extension isn't opening .....is there some particular way to open them?

 

[Sakshi Agarwal]

Last question for today...I swear! its just that I have been collecting these doubts for the past 2 months hoping to find sum1 to solve them...and jus 3 days back I found this website...seriously its the best!! you guys are amazing!
so..getting back to the point...
I have added a note in the pdf regarding my question...and where do we use the INT function?? Cant we solve the same formula without it?

 

[Zash Riyash]

THANK YOU!! But I have a doubt : The validation we are supposed to add has to come under the "Course" table or in the created query (design view...under criteria)?
And I am not able to open the database file...the .rar extension isn't opening .....is there some particular way to open them?

I don't know why it isn't working. Its supposed to. Give me your e-mail address I'd directly send the documents and oh yeah did you do "9713_s12_qp_2 q13" this paper and this question???

 

[Zash Riyash]

Last question for today...I swear! its just that I have been collecting these doubts for the past 2 months hoping to find sum1 to solve them...and jus 3 days back I found this website...seriously its the best!! you guys are amazing!
so..getting back to the point...
I have added a note in the pdf regarding my question...and where do we use the INT function?? Cant we solve the same formula without it?

Yeah, we can. I did this paper. Unfortunately, I'll be able to send it only by 12p.m indian time. (I need to sleep you know hahah)

 

[Zash Riyash]

THANK YOU!! But I have a doubt : The validation we are supposed to add has to come under the "Course" table or in the created query (design view...under criteria)?
And I am not able to open the database file...the .rar extension isn't opening .....is there some particular way to open them?

The validation has to be placed in the normal table, not the query or report.

 

[Zash Riyash]

Last question for today...I swear! its just that I have been collecting these doubts for the past 2 months hoping to find sum1 to solve them...and jus 3 days back I found this website...seriously its the best!! you guys are amazing!
so..getting back to the point...
I have added a note in the pdf regarding my question...and where do we use the INT function?? Cant we solve the same formula without it?

Hell take me... What all papers are you giving this OCTOBER?

 

[Sakshi Agarwal]

Hell take me... What all papers are you giving this OCTOBER?

I am writing my AS Level ICT this October so the papers are: Paper 1 (theory) and paper 2 (Practical's)