BSYS: Chapter 6 Matching

Terms in this set (10)

Append Query
A Query that selects records from one or more tables (the source) and adds them to an existing table (the destination).
Find Unmatched Query
A Query that compares records in two related tables, and then displays the records found in one table but not the other.
Crosstab Query
A Query that summarizes a data source into a few key rows and columns; the intersection of each row and column displays aggregate data.
Make Table Query
A query that selects records from one or more tables and uses them to create a new table.
Row Headings
The field names displayed along the left side of a crosstab query.
Delete Query
A query that selects records from a table and then removes them from the table.
Column Headings
The field name displayed at the top of a crosstab query.
Action Query
A query that adds, updates, or deletes data in a database.
Update Query
A query that changes the data values in one or more fields for all records that meet specific criteria.
Find Duplicate Query
A query that helps you identify repeated values in a table.
YOU MIGHT ALSO LIKE...
;