How to Insert a Blank Column in an Access Query

Written by francine richards
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Insert a Blank Column in an Access Query
Use the Design View to add a column to an Access query. (deep in database image by .shock from

Microsoft Access queries are useful in showing specific raw data records in a specific order or grouping. Editing is limited for a query format, which comes from a larger database table containing records. For advanced formatting and a more presentable display, the reports function is a better choice. Editing an Access query, using the design view, allows you to insert blank columns and modify other design changes, however, you should realise how they will affect your table and other data associated with the database.

Skill level:


  1. 1

    Open the Access database containing the query to which you wish to add a column. Select "File" and "Open" and highlight the file you wish to open and click "Open."

  2. 2

    Open the query by double-clicking it from the navigation pane on the left side of your screen. The navigation pane will show all tables, queries, reports and forms within the Access database file.

  3. 3

    Edit the query from the design view by selecting the "Home" tab and clicking "Design View" from the "View" group. Use the command in the "Query Set-up" group to insert a blank column into your Access query.

  4. 4

    Rerun your query by clicking "Run" from the "Results" group with these updates. Save by selecting the "Save" icon from the quick access toolbar at the top left of your screen.

  5. 5

    Add data directly to the new blank column in the query as you need. Changes you make to the query will also change automatically in the associated database table.

Tips and warnings

  • Changes to data design is better accomplished in the database tables or reports. Queries are best for viewing records but not designed for advanced formatting, rather a display of raw data.
  • Creating a new query using the wizard may be quicker than manually adding multiple design changes to an existing query.

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.