Is there more facilities in report?

[Kutty]

I have created one report in msaccess. I would like to know can
I create a report just like creating in word and excel? I cannot
see that much facilities in msaccess report. If there is how to do?
For example : to create table there is only dragging facility. Cannot
create a row or colum like word or excel. So this way
is lot of time wasting. Am I right?

(e-mail address removed)

 

[Andy - UK Access User Group]

Access offers fairly limited reporting facilities. probably the most
significant for me has been that you can not easily fit it all on a
page (like in Excel).

I would recommend that you exploit each of the MS products for it's
strengths. For example keep all the data in Access, but link Excel
either from a table or pivot table into Access. Then you can use all
the power of Excel to manipulate the presentation of data.

Access is good for simple repetitive reporting, but for real
flexibility you need to integrate it with excel.

 

[MacDermott]

If all you want to do is create a static "report", then certainly Word, or
even Excel, is a better choice.
Access is a relational database. Data is stored in tables. Reports are
made to present this data in a user-friendly manner. (It can be entered and
manipulated using forms.) If this is not what you want to do, Access may not
be the tool for you.