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
Access Definitions 3
Access Definitions from Chapter 3
| Question | Answer |
|---|---|
| And operator | A function that selects records that match all of two or more conditions in a query |
| AutoFilter | A menu that opens when you click the arrow in the right side of a field selector |
| Calculated field | A field that displays a value that is calculated using other fields in the query |
| Common field | A field that appears in two or more data tables that have the same data type and contain the same values |
| Condition/criterion | A way of telling the query which data you are interesting in seeing |
| Expression | The calculation for a calculated field |
| Filter | A function that temporarily displays records in a datasheet based on the condition(s) you specify |
| Filter by form | A function to be used when you need to display records that contain one or more values based on the values stored in one or more fields. The datasheet then hides all the records it contains and displays a list box for a selected field |
| Filter by selection | A function to be used when you need to select a field value or part of a field value. A list of options will appear and the database will display the selected records accordingly |
| Foreign key | The common field in a related table when used in a relationship |
| Multitable query | A query based on more than one table |
| One-to-many relationship | When one record in the first table can match many records in the second or related table |
| Or operator | A function that selects records that match at least one of two or many conditions in a query |
| Query | A database object that allows you to search the data in the database |
| Referential integrity | A set of rules that protects data in multiple tables from accidentilly being changed or deleted |
| Relationship | A connection between tables in a database |
| Simple query wizard | An easy way to create a query in Access. It provides step by step explanations of its options in the form of dialogue boxes |
| Sort | When you change the arrangement of the field values |
| Subdatasheet | A datasheet that contains the related records in the orders table |
| Total row | An option you can use to count the number of values in a column |
Created by:
VanilliteFTW
Popular Business sets