Author Topic: IGCSE ICT  (Read 3421 times)

Offline Mahmed95

  • Newbie
  • *
  • Posts: 1
  • Reputation: 13
IGCSE ICT
« on: March 25, 2010, 09:27:13 am »
How do we do the June 2009 Paper 2 Database Task Step #46 onwards on Access 2007?
I was doing past papers for homework and I'm stuck on this question. Can somebody please guide me through it?! Please and thank you!  :)

Offline Usman B.Aamir

  • Newbie
  • *
  • Posts: 11
  • Reputation: 162
  • Gender: Male
Re: IGCSE ICT
« Reply #1 on: March 25, 2010, 07:21:49 pm »
OK...go to 'create Query by wizard'....select the staff and income fields....click next...select summary bullet and click on summary options...
then check on the 'sum' for income...and check the "count records in ..."
Next....click 'ok'...and click next and click finish....
U should get the correct Query or else ask ur doubt again to me....
im always there for ICT doubts...... ;) ;)

Monica

  • Guest
Re: IGCSE ICT
« Reply #2 on: March 26, 2010, 12:40:54 am »
OK...go to 'create Query by wizard'....select the staff and income fields....click next...select summary bullet and click on summary options...
then check on the 'sum' for income...and check the "count records in ..."
Next....click 'ok'...and click next and click finish....
U should get the correct Query or else ask ur doubt again to me....
im always there for ICT doubts...... ;) ;)

Thank You. +Rep

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: IGCSE ICT
« Reply #3 on: April 04, 2010, 07:01:23 pm »
can u pls tell me how to do the same question in access 2003?
Thanks...
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline °o.O-hash94-O.o°

  • SF Master
  • ******
  • Posts: 1447
  • Reputation: 7321
  • Gender: Male
  • kNoW YoUr eNeMy!
Re: IGCSE ICT
« Reply #4 on: April 04, 2010, 09:11:26 pm »

Offline ksitna

  • Allhamdullillah
  • SF Geek
  • ****
  • Posts: 497
  • Reputation: 491
  • Gender: Female
Re: IGCSE ICT
« Reply #5 on: April 19, 2010, 05:29:45 pm »
how do i do question 25
nov 2009 paper 3

Interrogate the data, to find all the Red items with a Unit Purchase price between 0.51
and 0.58 Euros.
Print this data.
Make sure that your name, Centre number and candidate number are printed in the
header.

pls someone helppp
take whatever you want and give nothing back :)

Offline DEGO

  • SF Citizen
  • ***
  • Posts: 194
  • Reputation: 289
Re: IGCSE ICT
« Reply #6 on: April 19, 2010, 06:01:58 pm »
GUYS is ict tht hard i was thinking of takin it this summer
EMRACE UR DREAMS_PROTECT UR HONOR_ DIE AS A HERO

Offline ~HyDrOgEn~

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 167
Re: IGCSE ICT
« Reply #7 on: April 20, 2010, 02:18:01 pm »
how to produce lables!!!!! , what is meant by calculated @ run time!