BSYS: Chapter 6 Matching
Terms in this set (10)
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.
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.
The field names displayed along the left side of a crosstab query.
A query that selects records from a table and then removes them from the table.
The field name displayed at the top of a crosstab query.
A query that adds, updates, or deletes data in a database.
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...
MIS test 3: pivot tables/tutorial 5
Access Chapter 5
Access 2016 Comprehensive, 1e Ch 6
Access Vocab #12
OTHER SETS BY THIS CREATOR
BSYS: Chapter 7 Multiple Choice
BSYS: Chapter 7 Matching
BSYS: Chapter 6 Multiple Choice
BSYS: Chapter 5 Multiple Choice