Qualification > Miscellaneous

All ICT doubts here!

(1/103) > >>

shahmeerhaq:


IN THIS TOPIC WE CAN HELP EACH OTHER IN PRACTICALS.
SO PLEASE JUST POSTS QUESTIONS AND ANSWERS ONLY.





SO ENJOY GUYS AND HELP THE HELPERS SO THEY CAN ALSO GET GOOD GRADES LIKE ALL OF PEOPLES.

shahmeerhaq:
HEY IM I  NEED HELP IN THIS PAPER 3 PRACTICAL MAY/JUNE 2008
STEP NO-8
NO-8---USE A FUNCTION(THAT INCLUDES BOTH ABSOLUTE AND RELATIVE REFERENCING)IN CELL D7,TO CALCULATE THE SUM OF THE DURATION COLUMN IF THE DCODE COLUMN CONTAINS MD
DO NOT INCLUDE ROWS 1 TO 3
RELPLICATE THIS FUNCTION INTO CELLS D8 TO D13 TO SUM THE TOTAL DURATION FOR EACH.

°o.O-hash94-O.o°:
hi,

pls ask all your doubts here in this thread...and hopefully u will get the answers to ur doubts!

and dont make separate thread for ICT doubts from now on!

Thanks

haris94:
46 Produce a new report which:
• shows a summary of the week 37 sales only
• uses only the Staff and Income fields
• calculates the sum of the Income field for each member of Staff
• counts the number of holidays sold by each member of Staff

question is from m/j 2009 paper 2 (igcse ict)
i know how to do it in access 2007 but my school has 2003; so if anybody could help me do this in 2003 it would be appreciated

Vin:
hey i got this one..
in 2003 ryt...quite simple...
jus right click on the "query design view"
look for "totals"...click it n another row of totals will appear just below the "tables" row
once this is done the row automatically takes "group by"
let the staff remail grouped "group by"
now add two of the income and select "sum" or "count"
ur things done... if u wer able to do it in 2007 u'll surely get it in 2003
i feel 2007 if far better than 2003 for igcse :) :)

Navigation

[0] Message Index

[#] Next page