All reports results on one page?

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

At work we use an Access database (badly designed IMHO) which contains many
different reports - about 25, I think. Various organisations use this
database. They are required to run each report, write down the result
(actually a percentage)on paper , then type up all their resulting
percentages into an Excel spreadsheet and email it to us.

I feel there must be a better way of doing this. It is probably hoping too
much to think that there is some way of automatically capturing all the
percentages and dumping them automatically into Excel?

If so, I thought it might at least be possible to capture all the
percentages in one report and have them send a snapshot or something
similar?

Is this a realistic possibility? If so would it slow Access down terribly,
while all the data was being captured?

Any useful suggestions would be much appreciated.
 
Access is certainly capable of doing what you ask.

Do you have the skills/understanding to work on this yourself? It may
involve correcting the design, redesigning the existing queries, forms,
reports, macros, and code, and then creating the new report to get the
results you are after.
 
Well, I thought it might be a challenge! If I could take the result from one
report and build it into my own new one, then I could probably do the rest
too eventually. The trouble is where do I start? Is there anywhere I could
read about this sort of thing?
 
How do you learn? John Viescas' book, "Microsoft Office Access 2003 Inside
Out" (Microsoft Press 2004) might be a good resource. If you learn from
others, you may be able to enrol in a class on Access if there is one
locally, purchase a video training course, e.g.:
www.keystonelearning.com/shop/detail.aspx?id=259

For a basic example, open the Northwind sample database, and start with the
Relationships diagram (Relationships on Tools menu), to understand how and
why the data is connected as it is. Search for the word "normalization" to
get more resources on this.
 
I do have a good basic knowledge of Access already, perhaps a little than
basic. However, I am not very confident about dissecting a report and
putting its results into another one.
 
Back
Top