Access Report

Posted on 2014-03-04
Last Modified: 2014-03-05
I have a report produced from Tables in Access that I want to take out of Access to do more formatting for publication.  I know that I can export to Word, Excel, PowerPoint, PDF.  However, these applications don't have the high-end formatting capabilities that I need (although Word comes closest with its ability to create indexes).

Does someone know of a publishing tool that works really well with Access reports?  Years ago I worked with Adobe FrameMaker with some success.  Thanks!
Question by:clock1
  • 2
  • 2
LVL 14

Expert Comment

by:Bill Ross
ID: 39906156

Send to PDF and use Adobe Acrobat.  We do that and can make documents look as needed for professional presentations, binders, etc.  Added ability to create PDF books, etc. and easy to email or set up for download.

In my opinion it's worth the $.


LVL 84
ID: 39906697
Generally speaking, if you need something other than the formatting capabilities of Access you're better off with one of the more high-powered reporting engines, like Crystal Reports. CR (and most other enterprise-type reporting apps) can get data directly from Access, and you can then create the reports you need. I've worked in Crystal quite a bit in the last few years, and it is quite full-featured.

There are plenty of other reporting platforms as well, depending on how much time and money you want to invest.

Author Comment

ID: 39906848
I've worked with CR before and it works great for what you described.  My experience is nothing beats Access reports when it comes to data residing in Access. I need to locate a product/tool that will enable me to format, edit, and prepare the report for publication. Think I'm leaning more toward a publishing tool.

Author Comment

ID: 39907369
Can you tell me more about using Acrobat to create PDF books?  Or, refer me to a URL? Thanks!
LVL 14

Accepted Solution

Bill Ross earned 500 total points
ID: 39907611

There are loads of examples on the Adobe sire.  Check out: for specifics.

Try for general overview.



Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Install both Office 2010 and 2013 4 37
ms access filter query with empty combobox 5 29
Criteria for Date for DCount 4 23
Modify report 8 6
You can download the files for this tutorial here ( The .indd file in the InDesign files folder is a finished version of the file; you can start from scratch and work toward this. Also, …
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question