Author Topic: HELP IN AICT PRACTICALS  (Read 2694 times)

Offline superduper2009

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 165
HELP IN AICT PRACTICALS
« 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

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #1 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
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline superduper2009

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 165
Re: HELP IN AICT PRACTICALS
« Reply #2 on: April 23, 2010, 07:44:21 am »
i use office 2003

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #3 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
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #4 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
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

~ A.F ~

  • Guest
Re: HELP IN AICT PRACTICALS
« Reply #5 on: April 23, 2010, 12:00:15 pm »
Thanks Nobody

+rep. :)

Offline superduper2009

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 165
Re: HELP IN AICT PRACTICALS
« Reply #6 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

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #7 on: April 24, 2010, 02:37:11 pm »
Thanks Nobody

+rep. :)

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



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!
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline hetarth

  • Newbie
  • *
  • Posts: 7
  • Reputation: 7
  • if u wanna study do it , for yourself - my dad
Re: HELP IN AICT PRACTICALS
« Reply #8 on: April 26, 2010, 01:29:00 pm »
one question y did u remove the time and how did you get rid of the #########

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #9 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!
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline insane.kid

  • Newbie
  • *
  • Posts: 20
  • Reputation: 17
Re: HELP IN AICT PRACTICALS
« Reply #10 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 :)

Offline hetarth

  • Newbie
  • *
  • Posts: 7
  • Reputation: 7
  • if u wanna study do it , for yourself - my dad
Re: HELP IN AICT PRACTICALS
« Reply #11 on: April 27, 2010, 12:18:03 pm »
umm dude how do u remove the ###### because when i import it it says import error

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: HELP IN AICT PRACTICALS
« Reply #12 on: April 27, 2010, 01:07:32 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 ...
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline hell0

  • Newbie
  • *
  • Posts: 26
  • Reputation: 57
Re: HELP IN AICT PRACTICALS
« Reply #13 on: October 17, 2010, 10:22:51 am »
how do you do 8  ???

Offline Monopoly

  • SF Immigrant
  • **
  • Posts: 59
  • Reputation: 775
Re: HELP IN AICT PRACTICALS
« Reply #14 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?
« Last Edit: October 17, 2010, 01:20:30 pm by Monopoly »