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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

735 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