MS Access Action Queries

Microsoft Access How to Use Make Table Query

The make table query is really useful for backing up data in Access. You can get it to create a new table based on criteria and save it either in the current database or add it to another Access database. …

The Delete Query in Microsoft Access

It is really important that if you are using a delete query you have made a copy or backed up your data. An Access delete query will delete data based on criteria you set. You cannot undo it. It is …

Microsoft Access How to Use the Append Query

If you have imported data or just collected data into another table in a database you may need to copy it from the one table to another to consolidate the data. Here using an append query you can do just …

Microsoft Access: How to Use the Update Query

Data in databases sometimes require updating, perhaps it is a product name that has changed and needs to be changed in many places or maybe it is a change to the system of stock codes, area codes or perhaps a …