How to Truncate a Table with MS Access Query

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Truncate a Table with MS Access Query
Truncate a table with a delete MS Access query. (pregunta image by caironbohemio from

Performing actions on Access queries is done via action queries. Access action queries let you update, create, delete and append table data. This can help you perform much-needed maintenance on your database. Before action queries are performed, the database will ask you to confirm the changes and show you how they will impact your database. Action queries are located on the "Query" menu.

Skill level:

Other People Are Reading


  1. 1

    Open Access 2007 and select a database where the table data needs to be truncated. Select the "Office" button and click "Open." Search your computer for the database and click on it. Select the "Open" button. The database opens.

  2. 2

    Click the "Create" tab and select "Query Design." The "Show Table" dialogue box opens. Double-click on the table that needs some information truncated. Click the "Close" button to close the "Show Table" dialogue box.

  3. 3

    Add some fields to the query window by clicking on the field and dragging the field to the query window. Once the fields are added, add criteria in the "Criteria" field. In this example, the criteria are the way to specify what information you want removed from the table. For example, if you type "<.05" in the "Amount" field, the delete query will remove from the table any values that are less that 5 cents.

  4. 4

    Click "Delete" on the "Query Tools" tab. This turns your query into a delete query. By running it, you will be removing or truncating data from the table. Save your query by clicking on the "Save" icon on the Quick Access Toolbar.

  5. 5

    Run the query by clicking on the "Run" button. Access will inform you about the quantity of records that will removed from the database. Click "Yes" to confirm this deletion. Close the delete query by clicking on the "X" in the upper right-hand corner.

  6. 6

    Select the table from the Navigation Pane. Open the table by double-clicking on it. Notice the total number of records in the table. It should be smaller due to the truncation that just occurred.

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.