click below
click below
Normal Size Small Size show me how
DBase Unit 6
Advanced Database Vocabulary Unit 6
Question | Answer |
---|---|
Action query | a query that adds, changes, or deletes multiple table records at a time |
Append query | a query that adds selected fields in records from existing tables or queries to the end of another table |
Concantenated expression | an expression used to combine text fields together (for example: LastName & " " & FirstName |
Crosstab query | a query that performs aggregate function calculations on the values of one database field and display the result in a spreadsheet format |
Delete query | a query that deletes a group of records matching the criteria you specify from one or more tables |
Find duplicates query | a select query that finds repeated records in a table or query |
Find unmatched query | a select query that finds all records in a table or query that have no related records in a second table or query |
Parameter query | a query that displays a dialog box to prompt you to enter one or more criteria values when you run the query |
Top values query | a query property that lets you limit the number of records in the query results of a specific number or percentage (for example – top 10 or top 10%) |
Select query | finds repeated records matching the criteria you specify from one or more tables. |