Tables & Queries:
Action Queries

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

An action query selects certain records and fields and then does something with them. There are four kinds of action queries:

  • Button: Make-Table Query Make-Table: Creates a new table from copies of selected records and fields. The table's records do not change when the original records change.

  • Button: Append Query Append: Adds (appends) copies of the selected records/fields to an existing table.

  • Button: Delete Query Delete: Deletes the selected whole records.

  • Button: Update Update: Updates values to new values in the selected records.

WarningNo Undo: You cannot "undo" an action query's action.

TipVerify selection first: Be sure you have selected the records that you thought you did! Use the View button Button: Views - datasheet to see the query's datasheet. Check the records carefully.  Then run the action query with the Run button Button: Rund (2003).

Where you are:
JegsWorks > Lessons > Databases

Before you start...

Project 1: Intro

Project 2: Access Basics

Project 3: Tables & Queries Arrow: subtopic open
    Designing TablesTo subtopics
    Designing Queries Arrow: subtopic open
    Icon: StepSelect Query
    Icon: StepCalculated Values-Text
    Icon: StepCalculated Values-Numbers
    Icon: StepCalculated Values-Totals
    Icon: StepCalculated Values-Dates
    Icon: StepParameter Query
        Action Queries
    Icon: StepMake-Table Query
    Icon: StepAppend Query
    Icon: StepDelete Query
    Icon: StepUpdate Query
    Icon: StepCrosstab Query
    Icon: StepDocument a Query
    ExercisesTo subtopics

Project 4: Forms & Reports