Convert Access to PDF

This tutorial shows how to use novaPDF to create and convert a Microsoft Office Access report to a PDF document, as well as how to convert other database objects (tables, forms, queries) to PDF. novaPDF is a PDF converter that allows creating PDF files from any Windows application that supports printing. If you don’t have novaPDF installed, use the Download page to download and install it.

On this page: Creating a report from an Access database Converting an Access report to a PDF using novaPDF Video Tutorial Access reports to PDF Converting other Access database objects (tables, forms, queries) to PDF Programmatically save Access reports as PDFs using novaPDF SDK

Microsoft Office Access is a database management application part of the Microsoft Office suite. Converting your Access database report (or specific tables, forms and queries from the database) to PDF is an advantage if you want to share the documents with other users (in this case the user does not need Microsoft Access installed to view them).

By installing novaPDF you can convert Access reports, tables, forms and queries to PDF easier than ever. Simply choose novaPDF as a printer and once you press the Print button your database reports/objects will be converted to PDFs.

How to generate reports from Microsoft Access

To create an Access report from the Access 2013 database:

  1. Open Microsoft Access 2013 and go to File->Open (or press Ctrl+O), browse for the Access database, select it and click Open
  2. Once the database is opened go to the Create tab, click Reports->Report (or use the Report wizard) and a new tab with the report data will be created.
  • access2013 report

Converting an Access report to a PDF file using novaPDF

To convert the Access 2013 report to a PDF:

  1. Select the report you want to convert to PDF then click on  File->Print (or press Ctrl+P) and click one more time on the large Print section.
  2. From the Printer list window that opens select novaPDF.
  3. Before you create the PDF document you can adjust novaPDF’s settings by using the Properties button. You can also customize additional print options and columns settings by pressing the Setup button
  4. Click on OK and choose a location where you want the PDF file saved
  • access pdf

Video Tutorial Access Reports to PDF:

Converting other database objects (tables, forms or queries) to PDF

The other Microsoft Access database objects (tables, forms or queries) can also be converted to PDF documents in the same way as the Access reports.

To convert a Database object (table, form or query) to PDF:

  1. Open the Access database and expand the Navigation Pane on the left side to view All Access Objects.
  2. Click on the object you want to convert (i.e. a table) and go to File->Print (or press Ctrl+P)
  3. Click on Print again to open the printer selection window and choose novaPDF.
  4. If you need to adjust additional settings click on novaPDF’s Properties button. You can also customize additional print options and columns settings by pressing the Setup button
  5. Click on OK and choose a location where you want the PDF file saved
    • tables pdf

Programmatically saving Access reports as PDFs using novaPDF SDK

If you are a developer and your application communicates with Access (or stores data in its format), you can use one of our PDF tools for developers, novaPDF SDK, to programmatically convert Access reports to PDF files without any user interaction.

To create PDFs programmatically from Access:

  1. Download and install novaPDF SDK, which includes a COM interface to customize novaPDF printer options and also several code samples on how the integration can be done (including an Access sample)
  2. Integrate novaPDF SDK with your application using the provided documentation.
  3. Use the Microsoft Access sample (PDF Reports Access sample) to test its functionality (full source code files are included in the setup package).

This tutorial describes how to convert Access objects (reports, tables, forms, queries) to PDF files using novaPDF. If you have any suggestions on how to improve this article add a comment or rate it.

Applies to:

  • novaPDF Printer 1.x - 8.x
  • novaPDF SDK
  • Microsoft Office Access 2003 or higher

Comments


NEW: novaPDF 8.2.929