Easiest way to print AND display data on screen.

[cr113]

I've got a project that involves displaying and printing data. All the
data is readonly in Access 2007. All I have to do is display the data
using various charts and lists. I'm trying to decide whether to use
Access or Excel to display the data. The thing I like about Excel is
that I can display the data on the screen and it can also be printed.
It seems to me that if I do it in Access I will have to do double the
work. I'll have to display charts on a form to show it on the screen
but create a report to print it. Is this correct? Is there a way to
print a form in Access 2007? Or can I display the charts in an Access
report and also view them on the screen?

 

[Daniel Pineault]

Yes, you can print a form, but typically is not the best approach. That is
what reports are for.

If you do not need to work with the data, just display and print, you could
do it in a report alone and skip the form. You can display the report in
preview mode and then it can be printed as required by the user.
Furthermore, you can incorporate charts directly into your reports.

In the long run, I can assure you access give you much more power over your
data than Excel when it come to reporting, amongst other things, even if you
do need to create both a form and a report.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.