Search
Create
Log in
Sign up
Log in
Sign up
BSYS: Chapter 6 Matching
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
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...
MIS test 3: pivot tables/tutorial 5
37 Terms
lara_kunkel
Access Chapter 5
33 Terms
Emily_Turner39
Access 2016 Comprehensive, 1e Ch 6
30 Terms
NellyBird
Access Vocab #12
17 Terms
PriscillaTuhkanen
OTHER SETS BY THIS CREATOR
BSYS: Chapter 7 Multiple Choice
10 Terms
Esar_Cheema
BSYS: Chapter 7 Matching
18 Terms
Esar_Cheema
BSYS: Chapter 6 Multiple Choice
10 Terms
Esar_Cheema
BSYS: Chapter 5 Multiple Choice
10 Terms
Esar_Cheema
;