Author Topic: help in access  (Read 2060 times)

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
help in access
« on: April 25, 2009, 08:33:48 pm »

I need help in Access!!!!!!!!!!!!

I don't understand the count and sum,
especially when the question asks about EACH record!!!!


I just have few hours left, i need help very quickly!

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: help in access
« Reply #1 on: April 25, 2009, 08:37:54 pm »
Post a specific question from any past paper and Ill answer

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
Re: help in access
« Reply #2 on: April 25, 2009, 08:45:28 pm »
I really appreciate ur respond! :D

here is the question:

Produce a new report from all the data which:
• shows a summary of only the Code and Potential Area fields
• performs a count of the number of sites in each Code
• calculates the sum of the Potential Area within each code

Waiting... ::)

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: help in access
« Reply #3 on: April 25, 2009, 08:58:46 pm »
Oh god :D
You couldnt find any question except the summary one!  8)
I'm not at it at all..And I did it in such a way in the exam..What I know you should do in one of the steps..
That while doing the Query ...using a wizard ofcourse..use the 1st query not the table...thats what one of the teachers said,,,then click next.."Summary" and do what you are told...note that not everything will be done from here...finish
when you go to  the disign view of the query you made..click on the "Totals" icon that looks like an "E"
and a new row will appear "Group By" and you choose the criteria...Till here I can do things but after this im not good at all...I hope someone comes and tell you the rest..

Any other question in ICT please ask (without the summary thing :P)
Good luck

Offline SGVaibhav

  • SF Farseer
  • *******
  • Posts: 3013
  • Reputation: 5737
  • Gender: Male
  • Bugatti Veyron 16.4
Re: help in access
« Reply #4 on: April 25, 2009, 09:02:38 pm »
ok i will continue from where sweetsh stopped.

ok i dont know the exact question.
but i will tell the general things to be done in this query.

  • shows a summary of only the Code and Potential Area fields
After that new row appears.
for code , u can select group by     (do not select group by for potential area, because we want its sum so leave it intact)


performs a count of the number of sites in each Code

put sites as a new column
in that new row, select "Count", this will count the number of sites.



• calculates the sum of the Potential Area within each code
in the potential area column, select sum.

i think ur done!
« Last Edit: April 25, 2009, 09:11:48 pm by sgvaibhav »

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
Re: help in access
« Reply #5 on: April 25, 2009, 09:03:27 pm »
Guess What!

This is funny!

I knw all thse steps,
but i dnt knw what to do next!

Ok I'll keep trying,

Thank u anyway Sweetsh :D

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
Re: help in access
« Reply #6 on: April 25, 2009, 09:04:46 pm »
OK good, sgvaibhav !

I'll be waiting. :D

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: help in access
« Reply #7 on: April 25, 2009, 09:17:26 pm »
thank you sgvaibhav  :) and you welcome DE

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
Re: help in access
« Reply #8 on: April 25, 2009, 09:19:51 pm »
Ok sgvaibhav ,

I have to go now, pls try to post the answer so that i can knw
it b4 the exam, which is after 8 hrs !!!
(ok i knw im very annoying bt i really need the steps ::) )



and thank u again sweetsh!

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: help in access
« Reply #9 on: April 25, 2009, 09:23:01 pm »
We all wish you and everybody else a good luck

Offline SGVaibhav

  • SF Farseer
  • *******
  • Posts: 3013
  • Reputation: 5737
  • Gender: Male
  • Bugatti Veyron 16.4
Re: help in access
« Reply #10 on: April 25, 2009, 09:23:49 pm »
i wrote the answer b4 9mins b4 u posted that!



Ok sgvaibhav ,

I have to go now, pls try to post the answer so that i can knw
it b4 the exam, which is after 8 hrs !!!
(ok i knw im very annoying bt i really need the steps Roll Eyes )



and thank u again sweetsh!
« Last Edit: April 25, 2009, 09:25:31 pm by sgvaibhav »

Offline emi

  • SF Geek
  • ****
  • Posts: 530
  • Reputation: 2581
  • former member
Re: help in access
« Reply #11 on: April 25, 2009, 10:52:59 pm »
i do it like this

go to the place where u make the Queries,,

1) choose creat Query by wizard
2) in the selected field add the fiels required by the Question ( code and potential area here ) then click next
3) then choose Summary and then summary options
4) tick mark the box under the SUM and also mark the option at the bottom right side ( below ok and those )  then click ok
5) click next and then add a name and then finish

you are DONE
former member

Offline MissDE

  • SF Citizen
  • ***
  • Posts: 227
  • Reputation: 105
Re: help in access
« Reply #12 on: April 26, 2009, 03:38:32 am »
Sorry sgvaibhav, that time i just wanted to sleep...! :D

and

thank u everybody this is great and i'm very thankful!

I'm now going to the exam,

wish me the good luck....... ::)