SQLConfiguration SQLConfiguration


Refining Queries  «Prev  Next»

Creating action queries - Exercise

Course project: Creating an action query

Objective: Gain experience creating an action query.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. One of your large clients has requested that you create a separate table of clients in Arizona.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.

Instructions

  1. Create a Select query that displays all the fields in the Clients table for clients in the state of Arizona.
  2. Pick the Make Table query using the Query Type toolbar button.
  3. Name the new table ArizonaClients.
  4. Run the query.