Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
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. |
Created by:
judyshipp
Popular Business sets