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
AR Adv DB Unit 6
Advanced Database Unit 6
| Term | Definition |
|---|---|
| Update query | a query that changes selected fields from selected records in one or more tables bases on the criteria you specify |
| Make–table query | a query that creates a new table by copying selected fields in records from one or more existing tables |
| 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 |
| Delete query | a query that deletes a group of records matching the criteria you specify from one or more tables |
| 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 |
| Index | a list that relates field values to the records that contain those field values that can quickly locate records |
| Append query | a query that adds selected fields in records from existing tables or queries to the end of another table |
| Concatenated 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 |
| Action query | a query that adds, changes, or deletes multiple table records at a time |
| Find duplicates query | a select query that finds repeated records in a table or query |
Created by:
Jame Pearce
Popular Computers sets