How to Print a Query in Access and VBA

Written by lisa bass
  • Share
  • Tweet
  • Share
  • Email

One of the biggest benefits of Microsoft Access is its Windows-based interface that allows users to design queries without an extensive knowledge of Structured Query Language (SQL), the programming language created in the early 1970s to collect information from databases. Access has been improved over earlier versions of the database software by allowing users to print query details without having to cut-and-paste query language into word processing documents, then print. Using the Database Documenter tool, users can now print reports showing the query properties, language and relevant column attributes.

Skill level:
Moderately Easy

Other People Are Reading


    Printing from Access

  1. 1

    Open the query. Select the "Database Tools" tab at the top of the screen.

  2. 2

    Click on the "Database Documenter" option in the middle of the top tab.

  3. 3

    Select the query you want printed by checking the appropriate box. Click on "Yes" when Access tells you to close the query.

  4. 4

    Click on the "Print" icon in the upper right-hand side of the screen.

    Printing a Query from SQL View

  1. 1

    Run your query. Save it.

  2. 2

    Click on the "Design View" icon in the upper left-hand corner of the screen. Use the pull-down menu to select the "SQL View" option.

  3. 3

    Copy the SQL language shown in the window, then paste it to a word processing file. Print it.

    Printing an Entire Query

  1. 1

    Run the query.

  2. 2

    Click on the "Office" button in the upper left-hand corner of the screen.

  3. 3

    Select "Print" from the drop-down menu.

Tips and warnings

  • When you print an entire query, be sure that you won't be getting hundreds of pages of results. It's sometimes better to select "Print Preview," then choose a range of pages to print; say, the first 10 or 20 pages.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.