Access 2010: Export to PDF Document Format

Contrasting to Access 2007, in which you need to install add-ins to export database. Access 2010 offers option of exporting database in PDF (Portable Document Format) and XPS (XML paper Specification) formats. Now with Access 2010, you can export datasheet, Forms and Reports to a .pdf or .xps file, it enables you to spread information in an easy-to -distribute form that contains all formatting characteristics.

Launch Access 2010, open the Report you want to export to PDF format.

Now head over to External Data and Click PDF or XPS button.

clip image0026 Access 2010: Export to PDF Document FormatView in gallery

Choose the destination folder to save the report in PDF format. You can also choose the size of the file either to optimize for Standard (Publishing online and printing) or Minimum size (publishing online). For more options click Options. Hit Publish to start exporting.

clip image0035 Access 2010: Export to PDF Document FormatView in gallery

After successful publishing, you can also save the export steps.

clip_image004View in gallery

In the screenshot below, you can see the Report open in Access 2010 and the in PDF format.

clip_image005View in gallery

Same process can be followed to export the Forms, Queries and Tables in PDF format.

clip_image006View in gallery

clip_image007View in gallery

  • Russ Effrig

    I queried for instructions on how to generate Landscape pdf reports and this article came up. I see no reference to obtaining a landscape output in this article. The article is far too simplistic.