Generating Reports with Access

[Guest]

Hello.

I would like to generate an annual report for a group. Which Microsoft
application should I use to generate the report by including information from
various departments. Excel (spreadsheets) or Access (tables, queries,
forms). Isn't Access the most versatile applicaton for generating reports?

 

[Arvin Meyer]

Hard question to answer. I'd use both Access and Excel. Excel is perfect for
data analysis and charting. Access is perfect for storing and retrieving
data. Both do good reporting, although I believe you can use Access more
effectively for reporting. The charts can be created in Excel, then saved as
gifs or jpgs and used in Access reports. The code to do that as automation
is relatively simple:

Look at automation examples at:

http://www.mvps.org/access/modules/mdl0006.htm

Then add some code like:
Dim strPath As String
Dim chtXL As Excel.Chart

strPath = "C:\Audiology\Images\Exam" & wks.Cells(2, 1) & ".gif"

' Build a GIF image from the Excel chart
Set chtXL = wks.ChartObjects(1).Chart
chtXL.Export FileName:=strPath, FilterName:="GIF"

DoEvents

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Hello.

I would like to generate an annual report for a group. Which Microsoft
application should I use to generate the report by including information from
various departments. Excel (spreadsheets) or Access (tables, queries,
forms). Isn't Access the most versatile applicaton for generating

reports?