Creating Action Query[Access]

SiteMap

Refining Queries «Prev Next»

Tables Queries Forms
Table Design Enhancement
Table Field Validation
Custom Validation Messages
Input Mask Mechanics
Specifying Input Mask
Access Lookup Fields
Data Type Aadvantages
Enhancing Table Design
Refining Queries
Access Database Filters
Creating Parameter Queries
Multiple Access Queries
Query Field Properties
UsingIndexes With Queries
Specifying Join Properties Queries
Different Types AccessQueries
Creating Action Queries
Total Queries Access
Crosstab Queries
Refining Queries Conclusion
Building Modifying Forms
Create Access Form
Add Format to Access Form
Insert Graphic Access Form
Access Form Properties
Changing Form Properties
Custom Form Properties
Aligning Sizing Multiple Controls
Customize Access Forms
Building Modifying Forms
Access Controls
Combo Box
Option Groups
Subform Control
Create Multipage Forms
Adding Chart to Form
Activex Controls
Calendar activex Control
Access Controls

Creating an action query - Exercise Result

You entered:

Course project: Creating an action query

Exercise results

One of your large clients requested that you create a separate table of clients in Arizona. A Select query would be the best way to go about this. The query you created should like this:

The new table should something look like this, although some data may be different: