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
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.
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.
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.
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.
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.
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for