IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => GCE AS & A2 Level => Queries => Topic started by: superduper2009 on April 22, 2010, 07:48:33 am

Title: HELP IN AICT PRACTICALS
Post by: superduper2009 on April 22, 2010, 07:48:33 am: guys can u please please explain how to do q 10 in 9713_s09_qp_2.pdf (paper 2 may june 2009)
thanks in advance...
superduper2009
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 22, 2010, 12:10:41 pm: wait for few minutes...
also tell me what office you use.??
MS office 2003 OR MS office 2007
Title: Re: HELP IN AICT PRACTICALS
Post by: superduper2009 on April 23, 2010, 07:44:21 am: i use office 2003
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 23, 2010, 08:12:26 am: cool...
I think that the files have some problem with their format..
open excel and check both files..
J9OUT & J9HOME
I have uploaded the files..but i have removed the time from the date field.
I'll do that question & put it up!..... ;D
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 23, 2010, 11:41:58 am: 1. create a summary of a query, calculate avg of cost
2. in either out or home add ">2" and make sure that you change Total from "first of" to "count"
3. select the query to make a report (using wizard)
4. sort data as required
5. Add candidate name and candidate number and center number to report header also change the heading
6. view as print layout and check that heading of fields doesn't overlap and the data fits in one page
Title: Re: HELP IN AICT PRACTICALS
Post by: ~ A.F ~ on April 23, 2010, 12:00:15 pm: Thanks Nobody

+rep. :)
Title: Re: HELP IN AICT PRACTICALS
Post by: superduper2009 on April 23, 2010, 12:55:51 pm: nobody's amazing...
LOL...
Thanks for helping me out.... It was so nice of you :D

+rep
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 24, 2010, 02:37:11 pm: Quote from: ~ A.F ~ on April 23, 2010, 12:00:15 pm
Thanks Nobody

+rep. :)

hey...A.F. ....thanks....
hey..have you taken aict for as levels?

Quote from: superduper2009 on April 23, 2010, 12:55:51 pm
nobody's amazing...
LOL...
Thanks for helping me out.... It was so nice of you :D

+rep

oh!. Nobody is amazing?.. Not even me?? :( :P :P :P :P :P :P
thanks...superduper2009! tell me if you have any other doubts..!!
Happy to help!
Title: Re: HELP IN AICT PRACTICALS
Post by: hetarth on April 26, 2010, 01:29:00 pm: one question y did u remove the time and how did you get rid of the #########
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 26, 2010, 03:30:01 pm: me..??
### is because the cell size is too small.
enlarge the size of the cell.
and..no! i did not remove time!
Title: Re: HELP IN AICT PRACTICALS
Post by: insane.kid on April 26, 2010, 08:43:56 pm: Ppl u are doing a great job

I have one question which I cldnt solve it would be great if u can help me. It is question 15 from W08 paper 4. I use office 03 and plz attach your screen shots thank you :)
Title: Re: HELP IN AICT PRACTICALS
Post by: hetarth on April 27, 2010, 12:18:03 pm: umm dude how do u remove the ###### because when i import it it says import error
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on April 27, 2010, 01:07:32 pm: Quote from: hetarth on April 27, 2010, 12:18:03 pm
umm dude how do u remove the ###### because when i import it it says import error

I think you will have some problem in csv file!
Check the format of all the fields ...
Title: Re: HELP IN AICT PRACTICALS
Post by: hell0 on October 17, 2010, 10:22:51 am: how do you do 8 ???
Title: Re: HELP IN AICT PRACTICALS
Post by: Monopoly on October 17, 2010, 01:11:58 pm: Someone please help me out with this question of A2 specimen paper:

# Question 16 of Task C
Actually, i didn't understand even half of question 16. Specifically how do u
----“Call up the test dates records” of the first point."
----"Make sure that when updating the records, only valid branch codes can be entered and that branch codes in the Service centres file must be unique"
----"can distinguish first tests from repeat tests"

And for Task C, do I need to create new tables (Access) or use the ones prepared in task A and B?
Title: Re: HELP IN AICT PRACTICALS
Post by: Nobody on October 17, 2010, 04:50:10 pm: Quote from: hell0 on October 17, 2010, 10:22:51 am
how do you do 8 ???

what 8? didn't get you. :-\