Really new to this query stuff,please help

[HopelessITstude]

I am trying to do an access assignment at college. I have to do a count query, where I have to find the sum of the balance outstanding on a debt, average balance per customer,min outstanding balance,and max outstanding debt. (1000 customers)
I have not done much in the way of computing before and this is a massive learning curve for me, but I am eager to learn about this stuff.
I have tried using the query wizard but quite frankly I haven't got a clue where to start.Could anyone sympathetic to my needs spare me some time to talk me through this?
Thanks

 

[o1110010]

I have to do a count query, where I have to find the sum of the balance outstanding on a debt, average balance per customer,min outstanding balance,and max outstanding debt. (1000 customers)

When you are in design view of the query, click View then Totals. This adds the Total row to the query. From there, add the corresponding field and click on the Total: editbox to get a drop down list of available options. (Group By, Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where.)

That should get you going. If you need anything more specific, just write back! You may need to give us a little bit more information for more specific info.

Welcome to Access. Good luck.

 

[HopelessITstude]

from hopeless IT student

Thanks for your help. I have been busy trying to get to grips with it all, so far I have managed to do some simple queries and some cross tab queries, now I have to use that info to do some reports. I have used the wizard which is very helpful, but I have come up against a snag. When I go to print preview the document says it is 1 out of 12 pages, but it should not be that long. After the first page I have another page with nothing on it. Then after the third page the same thing. I have been into design view but nothing is obviously wrong. This would be okay if I was printing it out but I have to hand in an electronic version so I need to know how to delete unwanted pages in a report. Any ideas?
Also I have to do an Input form, so that telephone clerks can easily input new data(i.e. customers details) into the database. Where do I look for help on this? Is there a wizard that can help me?
Thanks for your help so far, maybe you could stretch to helping me just a little bit more?
Cheers

 

[aaron.orrell]

Access Report

Thanks for your help. I have been busy trying to get to grips with it all, so far I have managed to do some simple queries and some cross tab queries, now I have to use that info to do some reports. I have used the wizard which is very helpful, but I have come up against a snag. When I go to print preview the document says it is 1 out of 12 pages, Cheers

Hello HopelessITStude,

You need to adjust the page margins to accomodate the contents of the report. You can access these options during the preview mode, or you can access them through the file menu during design-time.

If the objects that are contained within the report are too large for the paper that you are using you can change the orientation to landscape or you can rearrange the objects to fit the page.

Kind regards,
Aaron

 

[HopelessITstude]

Thanks

Thanks
I knew it would be easy to do if I only knew where to look. Thanks for that it is now sorted and I am onto the next part of the assignment.
I have to create an "input form", haven't got a clue where to start any ideas?
Cheers