|
Introduction | Creating a Database | Tables | Queries | Forms | Reports
MS Access 2000
Types of Queries
A Select query retrieves data from one or more tables and displays
the results in a datasheet where you can update the records (with
some restrictions). You can also use a select query to group records
and calculate sums, counts, averages, and other types of totals.
A Parameter query displays its own dialog box prompting you for
information, such as criteria for retrieving records or a value
you want to insert in a field. You can design the query to prompt
you for more than one piece of information; for example, you can
design it to prompt you for two dates. Access can then retrieve
all records that fall between those two dates.
A Crosstab query can calculate and restructure data for easier
analysis of your data. Crosstab queries calculate a sum, average,
count, or other type of total for data that is grouped by two types
of information — one down the left side of the datasheet
and another across the top.
An Action query makes changes to or moves many records in just
one operation. There are four types of action queries: Delete
Queries, Update Queries, Append Queries, and Make-Table Queries.
An SQL query is made by using an SQL statement. You can use Structured
Query Language (SQL) to query, update, and manage relational databases
such as Access.
Continue with Forms or Return to Workshops
|
