access lesson 3
Order by
20 terms
Terms | Definitions |
|---|---|
 And operator | An operator used in a query that selects records that match all of two or more conditions in a query. a.o |
| AutoFilter | A menu that opens when you click the arrow on the right side of a field selector in a datasheet. a.f |
| Calculated field | a field in a query, forms, or report that displays a value that is calculated. c.f |
| Common field | A field that appears in two or more tables. co.f |
| Condition | In a query, a condition specifies which data to display in the query results. con. |
| Expression | The term given to the calculation used in a calculated field. expr. |
| Filter | A temporary rearrangement of the records in a table, query, form, or report based on one or more specified conditions.filt. |
| Filter by form | A filter that you can apply to a datasheet of from that rearranges the records based on one or more field values that you can select from a list. filt by for. |
| Filter by selection | A filter that you can apply to a datasheet or form that rearranges the records based on a selected field value or part of a field value.filt by sel. |
| Foreign key | When two tables in a database are related, the common field in the related table is called a foreign key. for. key. |
| Multitable query | A query that is based on the data in two or more tables. multi query |
| One-to-many relationship | A relationship between two tables in a database in which one record in the primary table can match many records in the related table. 1-t- man. rela. |
| Or operator | An operator used in a query that selects records that match at least one or more conditions in a query.or op. |
| Query | A database object that lets you ask the database about the data it contains. que. |
| Referential integrity | A set of rules that a DMBS follows to ensure that there are matching values in the common filed. ref. integ |
| Relationship | The feature of a DMBS that lets you connect the data in the tables in the database. rel |
| Simple query wizard | The wizard in access that lets you create a query and indicate what you'd like to see in the query results by selecting options in dialog boxes. simp. query wiz. |
| Sort | To arrange a list of words or numbers in ascending or descending order.sor. |
| Subdatasheet | W hen two tables are related. sub. |
| Total row | the optional row in a datasheet that counts the number of values in a column. total. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.