click below
click below
Normal Size Small Size show me how
Access Vocab Les3
Access Vocabulary Terms Lesson 3
| Question | Answer |
|---|---|
| Query | database object that lets you aks the database about the data it contains |
| Condition (Criterion) | a way of telling the query which data you are interested in seeing |
| Simple Query Wizard | asks you what data you want to seee by letting you select options in dialog boxes |
| Sort | when you view field values in ascending or descending order from A to Z or smallest to largest |
| Filter | temporarily displays records in a datasheet based on the condition that you specify |
| Filter By Selction | you select a field value in a datasheet and click the Selection button in Sort & Filter group on the Home tab |
| Filter By Form | click Advance button in the Sort & Filter group in the Home tab; displays records that have more values based on values stored in one or more fields |
| AutoFilter | a menu that opens when you click the arrow on the right side of a field selector |
| Relationship | database management system that lets you connect the data in the tables |
| Common Field | field that appears in both tables, has the same data types and contains the same values |
| One-To-Many Relationship | one record in the first table records the second table |
| Foreign Key | common field in the related table |
| Referential Integrity | protects the data in tables to make sure data is not accidentally deleted or changed |
| Subdata Sheet | contains the related records in orders talbe |
| Multable Queries | a queries that are based on more than one table |
| And Operator | selects records that match all of two or more conditions in query |
| Or Operator | selects records that match at least one of two or more conditions in a query |
| Total Row | counts number of values in a column |
| Calculated Field | a field displays a value that is calculated using other fields in the query |
| Expression | the calculation in a calculated field |