Q&A

Q1:	Define Parameter query.
A1:	A Parameter query allows you to supply criteria at runtime.
Q2:	Define Action query.
A2:	An Action query modifies table data.
Q3:	Define aggregate function.
A3:	An aggregate function summarizes numeric data.

Part I: Introduction to Relational Databases and Access 2003

Part II: Working with Existing Databases and Objects

Part III: Creating Your Own Database and Objects

Part IV: Power Access Techniques

Hour 14. Power Table Techniques

Hour 15. Power Query Techniques

Adding Calculated Fields to Select Queries

Applying Advanced Filters

Creating and Running Parameter Queries

Creating and Running Action Queries

Using Aggregate Functions to Summarize Numeric Data

Working with Outer Joins

Refining Queries with Field, Field List, and Query Properties

Hour 16. Power Form Techniques

Hour 17. Power Report Techniques

Part V: Advanced Topics